{"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":"utilizzare-lo-strumento-oracle-brm-pin-del-closed-accts-per-soddisfare-i-requisiti-gdpr","status":"publish","type":"post","link":"https:\/\/tridenstechnology.com\/it\/using-oracle-brm-pin-del-closed-accts-tool-to-meet-the-gdpr-requirements\/","title":{"rendered":"Utilizzando lo strumento Oracle BRM pin_del_closed_accts per soddisfare i requisiti 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":"

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)“. 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…<\/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\/it\/utilizzare-lo-strumento-oracle-brm-pin-del-closed-accts-per-soddisfare-i-requisiti-gdpr\/\" \/>\n<meta property=\"og:locale\" content=\"it_IT\" \/>\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\/it\/utilizzare-lo-strumento-oracle-brm-pin-del-closed-accts-per-soddisfare-i-requisiti-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=\"Scritto da\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ale\u0161\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tempo di lettura stimato\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minuti\" \/>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Utilizzando lo strumento Oracle BRM pin_del_closed_accts per soddisfare i requisiti GDPR","description":"Scopra come soddisfare i requisiti del GDPR con l'uso dello strumento pin_del_closed_accts per la sua applicazione di fatturazione 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\/it\/utilizzare-lo-strumento-oracle-brm-pin-del-closed-accts-per-soddisfare-i-requisiti-gdpr\/","og_locale":"it_IT","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\/it\/utilizzare-lo-strumento-oracle-brm-pin-del-closed-accts-per-soddisfare-i-requisiti-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":{"Scritto da":"Ale\u0161","Tempo di lettura stimato":"3 minuti"},"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":"it-IT","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":"Utilizzando lo strumento Oracle BRM pin_del_closed_accts per soddisfare i requisiti 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":"Scopra come soddisfare i requisiti del GDPR con l'uso dello strumento pin_del_closed_accts per la sua applicazione di fatturazione Oracle BRM.","breadcrumb":{"@id":"https:\/\/tridenstechnology.com\/using-oracle-brm-pin-del-closed-accts-tool-to-meet-the-gdpr-requirements\/#breadcrumb"},"inLanguage":"it-IT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/tridenstechnology.com\/using-oracle-brm-pin-del-closed-accts-tool-to-meet-the-gdpr-requirements\/"]}]},{"@type":"ImageObject","inLanguage":"it-IT","@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":"Monetizzazione, fatturazione e ricarica EV","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":"it-IT"},{"@type":"Organization","@id":"https:\/\/tridenstechnology.com\/#organization","name":"Tridens","url":"https:\/\/tridenstechnology.com\/","logo":{"@type":"ImageObject","inLanguage":"it-IT","@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":"it-IT","@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 \u00e8 il CEO di Tridens Technology, un'azienda slovena specializzata nello sviluppo di soluzioni software per l'industria automobilistica. Ha una lunga esperienza nel settore IT, avendo lavorato in passato per diverse grandi aziende. Ha una passione per la tecnologia e l'innovazione, e la sua attenzione attuale \u00e8 rivolta allo sviluppo di soluzioni che migliorino la sicurezza e l'efficienza dell'industria automobilistica. Ha un forte background di leadership e di gestione e si impegna a far progredire la sua azienda nel settore tecnologico in continua evoluzione.","url":"https:\/\/tridenstechnology.com\/it\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/tridenstechnology.com\/it\/wp-json\/wp\/v2\/posts\/2612","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tridenstechnology.com\/it\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tridenstechnology.com\/it\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tridenstechnology.com\/it\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tridenstechnology.com\/it\/wp-json\/wp\/v2\/comments?post=2612"}],"version-history":[{"count":0,"href":"https:\/\/tridenstechnology.com\/it\/wp-json\/wp\/v2\/posts\/2612\/revisions"}],"wp:attachment":[{"href":"https:\/\/tridenstechnology.com\/it\/wp-json\/wp\/v2\/media?parent=2612"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tridenstechnology.com\/it\/wp-json\/wp\/v2\/categories?post=2612"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tridenstechnology.com\/it\/wp-json\/wp\/v2\/tags?post=2612"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}