{"id":2612,"date":"2019-05-24T07:12:17","date_gmt":"2019-05-24T07:12:17","guid":{"rendered":"http:\/\/tridenstechnology.com\/?p=2612"},"modified":"2021-12-01T15:36:38","modified_gmt":"2021-12-01T15:36:38","slug":"utilisation-de-loutil-oracle-brm-pin-del-closed-accts-pour-repondre-aux-exigences-du-rgpd","status":"publish","type":"post","link":"https:\/\/tridenstechnology.com\/fr\/using-oracle-brm-pin-del-closed-accts-tool-to-meet-the-gdpr-requirements\/","title":{"rendered":"Utiliser l'outil pin_del_closed_accts d'Oracle BRM pour r\u00e9pondre aux exigences du GDPR"},"content":{"rendered":"

Our reason to start analysing and testing Oracle BRM pin_del_closed_accts tool was GPRS Article 17: “Right to erasure (\u2018right to be forgotten\u2019)<\/a>“.<\/p>\n

To meet all the GDPR requirements, all closed accounts must be deleted from Oracle BRM after a 24 months retention period. Till now we anonymized all customer information directly in the Oracle BRM database because there was no tool in Oracle BRM billing to properly delete closed accounts and all related data. With Oracle BRM 7.5 Patch Set 22<\/a>, a tool for deleting closed accounts was added.<\/p>\n

\"Oracle-BRM-anonymized\"<\/a><\/p>\n

Picture 1. Oracle BRM 7.5 PS22 Customer Center anonymized customer data<\/p>\n

Tool pin_del_closed_accts deletes all accounts and all referenced data for accounts that are older than a specified retention time. But keep in mind that the utility deletes only OOTB data objects; all custom data objects must be deleted by implementing custom logic and triggering it with the \/event\/notification\/account\/pre_delete<\/em> or \/event\/notification\/account\/delete<\/em> events, which are generated by PCM_OP_CUST_DELETE_ACCT opcode.<\/p>\n

The retention period can be set by configuring ClosedAcctsRetentionMonths entry in bus_params_customer.xml<\/em> and loading it into the Oracle BRM DB.<\/p>\n

The utility should be run from BRM_home\/apps\/pin_billd folder<\/em>. In pin.conf Set the number of threads to properly adjust the load on your Oracle BRM<\/strong> server. At the beginning, there were some very bad performances and lots of locked threads in the DB. Therefore, we created indexes on audit tables because searching for and deleting records in those tables takes a lot of time. If you need detailed information regarding creating indexes, please feel free to contact us<\/a>.<\/p>\n

The utility accepts several input parameters, so accounts can be deleted in specific order:<\/p>\n

1. Deleting all the closed non-paying child accounts in hierarchy at different levels:<\/p>\n

pin_del_closed_accts -subord -leaf<\/em>
\npin_del_closed_accts -subord<\/em><\/p>\n

2. Deleting member accounts of the sharing groups:<\/p>\n

pin_del_closed_accts -members_sharing<\/em><\/p>\n

3. Deleting paying child accounts at different levels in a hierarchy:<\/p>\n

pin_del_closed_accts -members_billing<\/em><\/p>\n

4. Deleting all remaining closed accounts:<\/p>\n

pin_del_closed_accts<\/em><\/p>\n

It is also possible to use an input list with accounts POID to delete specified accounts:<\/p>\n

pin_del_closed_accts -file file_name<\/em><\/p>\n

Example of input file:
\n0 PIN_FLD_RESULTS ARRAY [0] allocated 20, used 1<\/em>
\n1 PIN_FLD_POID POID [0] 0.0.0.1 \/account 1111 0<\/em>
\n0 PIN_FLD_RESULTS ARRAY [1] allocated 20, used 1<\/em>
\n1 PIN_FLD_POID POID [0] 0.0.0.1 \/account 2222 0<\/em>
\n0 PIN_FLD_RESULTS ARRAY [1] allocated 20, used 1<\/em>
\n1 PIN_FLD_POID POID [0] 0.0.0.1 \/account 3333 0<\/em>
\n0 PIN_FLD_RESULTS ARRAY [1] allocated 20, used 1<\/em>
\n1 PIN_FLD_POID POID [0] 0.0.0.1 \/account 4444 0<\/em><\/p>\n

If there are references between accounts, referenced accounts won’t be deleted.<\/p>\n

We are deleting accounts older than 24 months once per month to meet GDPR requirements. Deleting causes quite a heavy load on the DB, so it is done during the night, when the load on our real time Oracle BRM<\/a> billing system is low.<\/p>\n

Complying to GDPR requirements with the pin_del_closed_accts tool was a step in the right direction because everything is done automatically; therefore, we do not have to worry about this anymore.<\/p>\n","protected":false},"excerpt":{"rendered":"

La raison pour laquelle nous avons commenc\u00e9 \u00e0 analyser et \u00e0 tester l'outil pin_del_closed_accts de Oracle BRM est l'article 17 du RGPD : \u201cDroit \u00e0 l'effacement (\u2018droit \u00e0 l'oubli\u2019)\u201c. Pour r\u00e9pondre \u00e0 toutes les exigences du GDPR, tous les comptes cl\u00f4tur\u00e9s doivent \u00eatre supprim\u00e9s de Oracle BRM apr\u00e8s une p\u00e9riode de conservation de 24 mois. Jusqu'\u00e0 pr\u00e9sent, nous rendions anonymes toutes les informations relatives aux clients directement dans Oracle BRM...<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[38],"tags":[],"class_list":["post-2612","post","type-post","status-publish","format-standard","hentry","category-oracle-billing","category-38","description-off"],"yoast_head":"\nUsing Oracle BRM pin_del_closed_accts tool to meet GDPR requirements<\/title>\n<meta name=\"description\" content=\"Learn how to meet the GDPR requirements with the use of pin_del_closed_accts tool for your Oracle BRM billing application.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/tridenstechnology.com\/fr\/utilisation-de-loutil-oracle-brm-pin-del-closed-accts-pour-repondre-aux-exigences-du-rgpd\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Using Oracle BRM pin_del_closed_accts tool to meet the GDPR requirements\" \/>\n<meta property=\"og:description\" content=\"Learn how to meet the GDPR requirements with the use of pin_del_closed_accts tool for your Oracle BRM billing application.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/tridenstechnology.com\/fr\/utilisation-de-loutil-oracle-brm-pin-del-closed-accts-pour-repondre-aux-exigences-du-rgpd\/\" \/>\n<meta property=\"og:site_name\" content=\"Tridens\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/tridenstechnology\" \/>\n<meta property=\"article:published_time\" content=\"2019-05-24T07:12:17+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-12-01T15:36:38+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/tridenstechnology.com\/wp-content\/uploads\/2019\/05\/Oracle-BRM-anonymized.png\" \/>\n<meta name=\"author\" content=\"Ale\u0161\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@TridensTech\" \/>\n<meta name=\"twitter:site\" content=\"@TridensTech\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ale\u0161\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Utiliser l'outil pin_del_closed_accts d'Oracle BRM pour r\u00e9pondre aux exigences du GDPR","description":"D\u00e9couvrez comment r\u00e9pondre aux exigences du GDPR en utilisant l'outil pin_del_closed_accts pour votre application de facturation Oracle BRM.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/tridenstechnology.com\/fr\/utilisation-de-loutil-oracle-brm-pin-del-closed-accts-pour-repondre-aux-exigences-du-rgpd\/","og_locale":"fr_FR","og_type":"article","og_title":"Using Oracle BRM pin_del_closed_accts tool to meet the GDPR requirements","og_description":"Learn how to meet the GDPR requirements with the use of pin_del_closed_accts tool for your Oracle BRM billing application.","og_url":"https:\/\/tridenstechnology.com\/fr\/utilisation-de-loutil-oracle-brm-pin-del-closed-accts-pour-repondre-aux-exigences-du-rgpd\/","og_site_name":"Tridens","article_publisher":"https:\/\/www.facebook.com\/tridenstechnology","article_published_time":"2019-05-24T07:12:17+00:00","article_modified_time":"2021-12-01T15:36:38+00:00","og_image":[{"url":"http:\/\/tridenstechnology.com\/wp-content\/uploads\/2019\/05\/Oracle-BRM-anonymized.png","type":"","width":"","height":""}],"author":"Ale\u0161","twitter_card":"summary_large_image","twitter_creator":"@TridensTech","twitter_site":"@TridensTech","twitter_misc":{"\u00c9crit par":"Ale\u0161","Dur\u00e9e de lecture estim\u00e9e":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/tridenstechnology.com\/using-oracle-brm-pin-del-closed-accts-tool-to-meet-the-gdpr-requirements\/#article","isPartOf":{"@id":"https:\/\/tridenstechnology.com\/using-oracle-brm-pin-del-closed-accts-tool-to-meet-the-gdpr-requirements\/"},"author":{"name":"Ale\u0161","@id":"https:\/\/tridenstechnology.com\/#\/schema\/person\/ccd247e07a5e0f856ec13af63d611358"},"headline":"Using Oracle BRM pin_del_closed_accts tool to meet the GDPR requirements","datePublished":"2019-05-24T07:12:17+00:00","dateModified":"2021-12-01T15:36:38+00:00","mainEntityOfPage":{"@id":"https:\/\/tridenstechnology.com\/using-oracle-brm-pin-del-closed-accts-tool-to-meet-the-gdpr-requirements\/"},"wordCount":520,"commentCount":1,"publisher":{"@id":"https:\/\/tridenstechnology.com\/#organization"},"image":{"@id":"https:\/\/tridenstechnology.com\/using-oracle-brm-pin-del-closed-accts-tool-to-meet-the-gdpr-requirements\/#primaryimage"},"thumbnailUrl":"http:\/\/tridenstechnology.com\/wp-content\/uploads\/2019\/05\/Oracle-BRM-anonymized.png","articleSection":["Oracle Billing"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/tridenstechnology.com\/using-oracle-brm-pin-del-closed-accts-tool-to-meet-the-gdpr-requirements\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/tridenstechnology.com\/using-oracle-brm-pin-del-closed-accts-tool-to-meet-the-gdpr-requirements\/","url":"https:\/\/tridenstechnology.com\/using-oracle-brm-pin-del-closed-accts-tool-to-meet-the-gdpr-requirements\/","name":"Utiliser l'outil pin_del_closed_accts d'Oracle BRM pour r\u00e9pondre aux exigences du GDPR","isPartOf":{"@id":"https:\/\/tridenstechnology.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/tridenstechnology.com\/using-oracle-brm-pin-del-closed-accts-tool-to-meet-the-gdpr-requirements\/#primaryimage"},"image":{"@id":"https:\/\/tridenstechnology.com\/using-oracle-brm-pin-del-closed-accts-tool-to-meet-the-gdpr-requirements\/#primaryimage"},"thumbnailUrl":"http:\/\/tridenstechnology.com\/wp-content\/uploads\/2019\/05\/Oracle-BRM-anonymized.png","datePublished":"2019-05-24T07:12:17+00:00","dateModified":"2021-12-01T15:36:38+00:00","description":"D\u00e9couvrez comment r\u00e9pondre aux exigences du GDPR en utilisant l'outil pin_del_closed_accts pour votre application de facturation Oracle BRM.","breadcrumb":{"@id":"https:\/\/tridenstechnology.com\/using-oracle-brm-pin-del-closed-accts-tool-to-meet-the-gdpr-requirements\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/tridenstechnology.com\/using-oracle-brm-pin-del-closed-accts-tool-to-meet-the-gdpr-requirements\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/tridenstechnology.com\/using-oracle-brm-pin-del-closed-accts-tool-to-meet-the-gdpr-requirements\/#primaryimage","url":"http:\/\/tridenstechnology.com\/wp-content\/uploads\/2019\/05\/Oracle-BRM-anonymized.png","contentUrl":"http:\/\/tridenstechnology.com\/wp-content\/uploads\/2019\/05\/Oracle-BRM-anonymized.png"},{"@type":"BreadcrumbList","@id":"https:\/\/tridenstechnology.com\/using-oracle-brm-pin-del-closed-accts-tool-to-meet-the-gdpr-requirements\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/tridenstechnology.com\/"},{"@type":"ListItem","position":2,"name":"Using Oracle BRM pin_del_closed_accts tool to meet the GDPR requirements"}]},{"@type":"WebSite","@id":"https:\/\/tridenstechnology.com\/#website","url":"https:\/\/tridenstechnology.com\/","name":"Tridens","description":"Mon\u00e9tisation, facturation et recharge des v\u00e9hicules \u00e9lectriques","publisher":{"@id":"https:\/\/tridenstechnology.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/tridenstechnology.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/tridenstechnology.com\/#organization","name":"Tridens","url":"https:\/\/tridenstechnology.com\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/tridenstechnology.com\/#\/schema\/logo\/image\/","url":"https:\/\/d2xqcz296oofyv.cloudfront.net\/wp-content\/uploads\/2019\/02\/tridens_logo_invert.png","contentUrl":"https:\/\/d2xqcz296oofyv.cloudfront.net\/wp-content\/uploads\/2019\/02\/tridens_logo_invert.png","width":600,"height":191,"caption":"Tridens"},"image":{"@id":"https:\/\/tridenstechnology.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/tridenstechnology","https:\/\/x.com\/TridensTech","https:\/\/www.instagram.com\/tridenstechnology\/","https:\/\/www.linkedin.com\/company\/tridens","https:\/\/www.youtube.com\/user\/TridensIT"]},{"@type":"Person","@id":"https:\/\/tridenstechnology.com\/#\/schema\/person\/ccd247e07a5e0f856ec13af63d611358","name":"Ale\u0161","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/secure.gravatar.com\/avatar\/0df040b8c52446051022ab32cd2ac1dc64d3c7eed18d5bd5ab9f2992b8935fc8?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/0df040b8c52446051022ab32cd2ac1dc64d3c7eed18d5bd5ab9f2992b8935fc8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0df040b8c52446051022ab32cd2ac1dc64d3c7eed18d5bd5ab9f2992b8935fc8?s=96&d=mm&r=g","caption":"Ale\u0161"},"description":"Ales Pristovnik est le PDG de Tridens Technology, une entreprise slov\u00e8ne sp\u00e9cialis\u00e9e dans le d\u00e9veloppement de solutions logicielles pour l'industrie automobile. Il a une longue exp\u00e9rience dans le secteur des technologies de l'information, ayant travaill\u00e9 pour plusieurs grandes entreprises dans le pass\u00e9. Passionn\u00e9 par la technologie et l'innovation, il se concentre actuellement sur le d\u00e9veloppement de solutions qui am\u00e9lioreront la s\u00e9curit\u00e9 et l'efficacit\u00e9 de l'industrie automobile. Il poss\u00e8de une solide exp\u00e9rience en mati\u00e8re de leadership et de gestion et s'est engag\u00e9 \u00e0 faire progresser son entreprise dans le secteur technologique en constante \u00e9volution.","url":"https:\/\/tridenstechnology.com\/fr\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/tridenstechnology.com\/fr\/wp-json\/wp\/v2\/posts\/2612","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tridenstechnology.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tridenstechnology.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tridenstechnology.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tridenstechnology.com\/fr\/wp-json\/wp\/v2\/comments?post=2612"}],"version-history":[{"count":0,"href":"https:\/\/tridenstechnology.com\/fr\/wp-json\/wp\/v2\/posts\/2612\/revisions"}],"wp:attachment":[{"href":"https:\/\/tridenstechnology.com\/fr\/wp-json\/wp\/v2\/media?parent=2612"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tridenstechnology.com\/fr\/wp-json\/wp\/v2\/categories?post=2612"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tridenstechnology.com\/fr\/wp-json\/wp\/v2\/tags?post=2612"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}