{"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":"utilizar-oracle-brm-pin-del-closed-accts-tool-para-cumprir-os-requisitos-gdpr","status":"publish","type":"post","link":"https:\/\/tridenstechnology.com\/pt\/using-oracle-brm-pin-del-closed-accts-tool-to-meet-the-gdpr-requirements\/","title":{"rendered":"Utilize a ferramenta pin_del_closed_accts do Oracle BRM para cumprir os requisitos do RGPD"},"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":"

A nossa raz\u00e3o para come\u00e7ar a analisar e testar a ferramenta pin_del_closed_accts do Oracle BRM foi o artigo 17\u00ba do RGPD: \u201cDireito ao apagamento (\u2018direito a ser esquecido\u2019)\u201c. Para cumprir todos os requisitos do RGPD, todas as contas fechadas devem ser eliminadas do Oracle BRM ap\u00f3s um per\u00edodo de reten\u00e7\u00e3o de 24 meses. At\u00e9 agora, anonimiz\u00e1mos todas as informa\u00e7\u00f5es dos clientes diretamente no 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\/pt\/utilizar-oracle-brm-pin-del-closed-accts-tool-para-cumprir-os-requisitos-gdpr\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\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\/pt\/utilizar-oracle-brm-pin-del-closed-accts-tool-para-cumprir-os-requisitos-gdpr\/\" \/>\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=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ale\u0161\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tempo estimado de leitura\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutos\" \/>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Utilize a ferramenta pin_del_closed_accts do Oracle BRM para cumprir os requisitos do RGPD","description":"Saiba como cumprir os requisitos do RGPD com a utiliza\u00e7\u00e3o da ferramenta pin_del_closed_accts para a sua aplica\u00e7\u00e3o de factura\u00e7\u00e3o 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\/pt\/utilizar-oracle-brm-pin-del-closed-accts-tool-para-cumprir-os-requisitos-gdpr\/","og_locale":"pt_PT","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\/pt\/utilizar-oracle-brm-pin-del-closed-accts-tool-para-cumprir-os-requisitos-gdpr\/","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":{"Escrito por":"Ale\u0161","Tempo estimado de leitura":"3 minutos"},"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":"pt-PT","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":"Utilize a ferramenta pin_del_closed_accts do Oracle BRM para cumprir os requisitos do RGPD","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":"Saiba como cumprir os requisitos do RGPD com a utiliza\u00e7\u00e3o da ferramenta pin_del_closed_accts para a sua aplica\u00e7\u00e3o de factura\u00e7\u00e3o Oracle BRM.","breadcrumb":{"@id":"https:\/\/tridenstechnology.com\/using-oracle-brm-pin-del-closed-accts-tool-to-meet-the-gdpr-requirements\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/tridenstechnology.com\/using-oracle-brm-pin-del-closed-accts-tool-to-meet-the-gdpr-requirements\/"]}]},{"@type":"ImageObject","inLanguage":"pt-PT","@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":"Monetiza\u00e7\u00e3o, fatura\u00e7\u00e3o e carregamento de ve\u00edculos el\u00e9ctricos","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":"pt-PT"},{"@type":"Organization","@id":"https:\/\/tridenstechnology.com\/#organization","name":"Tridens","url":"https:\/\/tridenstechnology.com\/","logo":{"@type":"ImageObject","inLanguage":"pt-PT","@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":"pt-PT","@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 \u00e9 o CEO da Tridens Technology, uma empresa eslovena especializada no desenvolvimento de solu\u00e7\u00f5es de software para a ind\u00fastria autom\u00f3vel. Ele tem uma longa hist\u00f3ria na ind\u00fastria de TI, tendo trabalhado para v\u00e1rias grandes empresas no passado. Ele tem uma paix\u00e3o pela tecnologia e inova\u00e7\u00e3o, e o seu foco actual \u00e9 o desenvolvimento de solu\u00e7\u00f5es que ir\u00e3o melhorar a seguran\u00e7a e efici\u00eancia da ind\u00fastria autom\u00f3vel. Ele tem um forte background em lideran\u00e7a e gest\u00e3o, e est\u00e1 empenhado em impulsionar a sua empresa no sector da tecnologia em constante evolu\u00e7\u00e3o.","url":"https:\/\/tridenstechnology.com\/pt\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/tridenstechnology.com\/pt\/wp-json\/wp\/v2\/posts\/2612","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tridenstechnology.com\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tridenstechnology.com\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tridenstechnology.com\/pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tridenstechnology.com\/pt\/wp-json\/wp\/v2\/comments?post=2612"}],"version-history":[{"count":0,"href":"https:\/\/tridenstechnology.com\/pt\/wp-json\/wp\/v2\/posts\/2612\/revisions"}],"wp:attachment":[{"href":"https:\/\/tridenstechnology.com\/pt\/wp-json\/wp\/v2\/media?parent=2612"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tridenstechnology.com\/pt\/wp-json\/wp\/v2\/categories?post=2612"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tridenstechnology.com\/pt\/wp-json\/wp\/v2\/tags?post=2612"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}