Removal of Personally Identifiable Information
The General Data Protection Regulation is a regulation in European Union (EU) law. It protects the data and privacy of all individuals within the EU and the European Economic Area.
Your organization can comply with the GDPR regarding the collection and use of personal data of EU residents.
You can remove an individual's personal data:
-
If requested by an individual
-
If the individual is no longer working with your organization
If you remove personally identifiable information, it can't be retrieved.
To run the removal process, you must have the Remove Personally Identifiable Information in Financials privilege.
To remove an individual's personally identifiable information for any product in Oracle Financials applications, you submit the Remove Personally Identifiable Information in Financials process.
-
Navigate: Navigator > Tools > Scheduled Processes.
-
On the Scheduled Processes page, click Schedule New Process.
-
Search and select Remove Personally Identifiable Information in Financials.
-
From the Party choice list, select the person's name for whom you want to remove personally identifiable information.
-
Click Submit.
Table and Column Details for Potential Removal of Personally Identifiable Information
Here's a table that lists applications and their corresponding tables and columns that store sensitive data. It also lists the data type stored in each column, whether you can redact the data from the column, and the reason for redaction.
Sequence Number and Product |
Table |
Column |
Data Type |
Redact? |
Reason for Redaction |
---|---|---|---|---|---|
1 Oracle Payments |
IBY_CREDITCARD |
CC_NUMBER_HASH1 |
VARCHAR2(64 CHAR) |
No |
Unreadable data. |
2 Oracle Payments |
IBY_CREDITCARD |
CC_NUMBER_HASH2 |
VARCHAR2(64 CHAR) |
No |
Unreadable data. |
3 Oracle Payments |
IBY_CREDITCARD |
CCNUMBER |
VARCHAR2(30 CHAR) |
No |
Tokenized or encrypted data. |
4 Oracle Payments |
IBY_CREDITCARD |
CHNAME |
VARCHAR2(80 CHAR) |
No |
Nonsensitive since card is secured. |
5 Oracle Payments |
IBY_CREDITCARD |
EXPIRYDATE |
DATE |
No |
Nonsensitive since card is secured. |
6 Oracle Payments |
IBY_CREDITCARD |
MASKED_CC_NUMBER |
VARCHAR2(30 CHAR) |
No |
Nonsensitive since card is secured. |
7 Oracle Payments |
IBY_EXT_BANK_ACCOUNTS |
BANK_ACCOUNT_NAME |
VARCHAR2(80 CHAR) |
Yes |
Sensitive data. |
8 Oracle Payments |
IBY_EXT_BANK_ACCOUNTS |
BANK_ACCOUNT_NAME_ALT |
VARCHAR2(320 CHAR) |
Yes |
Sensitive data. |
9 Oracle Payments |
IBY_EXT_BANK_ACCOUNTS |
BANK_ACCOUNT_NUM |
VARCHAR2(100 CHAR) |
Yes |
Sensitive when bank account isn't encrypted or masked. |
10 Oracle Payments |
IBY_EXT_BANK_ACCOUNTS |
BANK_ACCOUNT_NUM_ELECTRONIC |
VARCHAR2(100 CHAR) |
Yes |
Sensitive when bank account isn't encrypted or masked. |
11 Oracle Payments |
IBY_EXT_BANK_ACCOUNTS |
BANK_ACCOUNT_NUM_HASH1 |
VARCHAR2(64 CHAR) |
No |
Unreadable data. |
12 Oracle Payments |
IBY_EXT_BANK_ACCOUNTS |
BANK_ACCOUNT_NUM_HASH2 |
VARCHAR2(64 CHAR) |
No |
Unreadable data. |
13 Oracle Payments |
IBY_EXT_BANK_ACCOUNTS |
IBAN |
VARCHAR2(50 CHAR) |
Yes |
Sensitive when bank account isn't encrypted or masked. |
14 Oracle Payments |
IBY_EXT_BANK_ACCOUNTS |
IBAN_HASH1 |
VARCHAR2(64 CHAR) |
No |
Unreadable data. |
15 Oracle Payments |
IBY_EXT_BANK_ACCOUNTS |
IBAN_HASH2 |
VARCHAR2(64 CHAR) |
No |
Unreadable data. |
16 Oracle Payments |
IBY_EXT_BANK_ACCOUNTS |
MASKED_BANK_ACCOUNT_NUM |
VARCHAR2(100 CHAR) |
Yes |
Denormalized value. Sensitive when bank account isn't encrypted or masked. |
17 Oracle Payments |
IBY_EXT_BANK_ACCOUNTS |
MASKED_IBAN |
VARCHAR2(50 CHAR) |
Yes |
Denormalized value. Sensitive when bank account isn't encrypted or masked. |
18 Oracle Payments |
IBY_FNDCPT_TX_EXTENSIONS |
INSTRUMENT_SECURITY_CODE |
VARCHAR2(10 CHAR) |
No |
No longer store card verification value. |
19 Oracle Payments |
IBY_TRXN_SUMMARIES_ALL |
DEBIT_ADVICE_EMAIL |
VARCHAR2(255 CHAR) |
Yes |
Denormalized value. Sensitive data. |
20 Oracle Payments |
IBY_PAYMENTS_ALL |
EXT_BANK_ACCOUNT_NAME |
VARCHAR2(360 CHAR) |
Yes |
Nonsensitive when person data is redacted. |
21 Oracle Payments |
IBY_PAYMENTS_ALL |
EXT_BANK_ACCOUNT_NUMBER |
VARCHAR2(100 CHAR) |
Yes |
Denormalized value. Sensitive when bank account isn't encrypted or masked. |
22 Oracle Payments |
IBY_PAYMENTS_ALL |
EXT_BANK_ACCOUNT_IBAN_NUMBER |
VARCHAR2(50 CHAR) |
Yes |
Denormalized value. Sensitive when bank account isn't encrypted or masked. |
23 Oracle Payments |
IBY_PAYMENTS_ALL |
PAYEE_NAME |
VARCHAR2(360 CHAR) |
Yes |
Payee name is sensitive data. |
24 Oracle Payments |
IBY_PAYMENTS_ALL |
PAYEE_ADDRESS1 |
VARCHAR2(240 CHAR) |
Yes |
Address data. |
25 Oracle Payments |
IBY_PAYMENTS_ALL |
PAYEE_ADDRESS2 |
VARCHAR2(240 CHAR) |
Yes |
Address data. |
26 Oracle Payments |
IBY_PAYMENTS_ALL |
PAYEE_ADDRESS3 |
VARCHAR2(240 CHAR) |
Yes |
Address data. |
27 Oracle Payments |
IBY_PAYMENTS_ALL |
PAYEE_ADDRESS4 |
VARCHAR2(240 CHAR) |
Yes |
Address data. |
28 Oracle Payments |
IBY_PAYMENTS_ALL |
PAYEE_CITY |
VARCHAR2(60 CHAR) |
Yes |
Address data. |
29 Oracle Payments |
IBY_PAYMENTS_ALL |
PAYEE_POSTAL_CODE |
VARCHAR2(60 CHAR) |
Yes |
Address data. |
30 Oracle Payments |
IBY_PAYMENTS_ALL |
PAYEE_STATE |
VARCHAR2(120 CHAR) |
Yes |
Address data. |
31 Oracle Payments |
IBY_PAYMENTS_ALL |
PAYEE_PROVINCE |
VARCHAR2(120 CHAR) |
Yes |
Address data. |
32 Oracle Payments |
IBY_PAYMENTS_ALL |
PAYEE_COUNTY |
VARCHAR2(120 CHAR) |
Yes |
Address data. |
33 Oracle Payments |
IBY_PAYMENTS_ALL |
PAYEE_COUNTRY |
VARCHAR2(60 CHAR) |
Yes |
Address data. |
34 Oracle Payments |
IBY_PAYMENTS_ALL |
REMIT_ADVICE_EMAIL |
VARCHAR2(255 CHAR) |
Yes |
Address data. |
35 Oracle Payments |
IBY_PAYMENTS_ALL |
PAYEE_PARTY_NAME |
VARCHAR2(360 CHAR) |
Yes |
Party name is sensitive data. |
36 Oracle Payments |
IBY_PAYMENTS_ALL |
PAYEE_LE_REGISTRATION_NUM |
VARCHAR2 (50 CHAR) |
Yes |
Denormalized value. Sensitive data. |
37 Oracle Payments |
IBY_PAYMENTS_ALL |
PAYEE_TAX_REGISTRATION_NUM |
VARCHAR2 (50 CHAR) |
Yes |
Denormalized value. Sensitive data. |
38 Oracle Payments |
IBY_PAYMENTS_ALL |
PAYEE_ADDRESS_CONCAT |
VARCHAR2 (2000 CHAR) |
Yes |
Address data. |
39 Oracle Payments |
IBY_PAYMENTS_ALL |
BENEFICIARY_NAME |
VARCHAR2 (360 CHAR) |
Yes |
Beneficiary name is sensitive data. |
40 Oracle Payments |
IBY_PAYMENTS_ALL |
PAYEE_ALTERNATE_NAME |
VARCHAR2 (360 CHAR) |
Yes |
Payee alternate name is sensitive data. |
41 Oracle Payments |
IBY_PAYMENTS_ALL |
EXT_BANK_ACCOUNT_ALT_NAME |
VARCHAR2 (320 CHAR) |
Yes |
Bank account alternate name is sensitive data. |
42 Oracle Payments |
IBY_PAYMENTS_ALL |
EXT_BANK_ACCOUNT_NUM_ELEC |
VARCHAR2 (100 CHAR) |
Yes |
Denormalized value. Sensitive when bank account isn't encrypted or masked. |
43 Oracle Payments |
IBY_PAYMENTS_ALL |
EXT_BANK_ACCT_OWNER_PARTY_NAME |
VARCHAR2 (360 CHAR) |
Yes |
Owner party name is sensitive data. |
44 Oracle Payments |
IBY_EXTERNAL_PAYEES_ALL |
REMIT_ADVICE_EMAIL |
VARCHAR2(255 CHAR) |
Yes |
Sensitive data. |
45 Oracle Payments |
IBY_EXTERNAL_PAYERS_ALL |
DEBIT_ADVICE_EMAIL |
VARCHAR2(255 CHAR) |
Yes |
Sensitive data. |
46 Oracle Payables |
AP_CHECKS_ALL |
ADDRESS_LINE1 |
VARCHAR2(240 CHAR) |
Yes |
Address data. |
47 Oracle Payables |
AP_CHECKS_ALL |
ADDRESS_LINE2 |
VARCHAR2(240 CHAR) |
Yes |
Address data. |
48 Oracle Payables |
AP_CHECKS_ALL |
ADDRESS_LINE3 |
VARCHAR2(240 CHAR) |
Yes |
Address data. |
49 Oracle Payables |
AP_CHECKS_ALL |
CITY |
VARCHAR2(60 CHAR) |
Yes |
Address data. |
50 Oracle Payables |
AP_CHECKS_ALL |
COUNTRY |
VARCHAR2(60 CHAR) |
Yes |
Address data. |
51 Oracle Payables |
AP_CHECKS_ALL |
ZIP |
VARCHAR2(60 CHAR) |
Yes |
Address data. |
52 Oracle Payables |
AP_CHECKS_ALL |
VENDOR_NAME |
VARCHAR2(240 CHAR) |
Yes |
Supplier name is sensitive data. |
53 Oracle Payables |
AP_CHECKS_ALL |
BANK_ACCOUNT_NUM |
VARCHAR2(30 CHAR) |
Yes |
Denormalized value. |
54 Oracle Payables |
AP_CHECKS_ALL |
ADDRESS_LINE4 |
VARCHAR2(240 CHAR) |
Yes |
Address data. |
55 Oracle Payables |
AP_CHECKS_ALL |
COUNTY |
VARCHAR2(150 CHAR) |
Yes |
Address data. |
56 Oracle Payables |
AP_CHECKS_ALL |
IBAN_NUMBER |
VARCHAR2(40 CHAR) |
Yes |
Denormalized value. |
57 Oracle Cash Management |
CE_PAYEES |
TAX_REGISTRATION_NUMBER |
VARCHAR2(20 CHAR) |
Yes |
Sensitive data. |
58 Oracle Receivables |
AR_CUSTOMER_ALT_NAMES |
ALT_NAME |
VARCHAR2(320 CHAR) |
Yes |
Alternate customer name using Zengin characters. |
59 Oracle Receivables |
AR_PAYMENT_SCHEDULES_ALL |
DEL_CONTACT_EMAIL_ADDRESS |
VARCHAR2(1000 CHAR) |
Yes |
Email of the customer bill-to contact who receives printed transactions. |
60 Oracle Receivables |
RA_CUSTOMER_TRX_ALL |
DEL_CONTACT_EMAIL_ADDRESS |
VARCHAR2(1000 CHAR) |
Yes |
Email of the customer bill-to contact who receives printed transactions. |
61 Oracle Advanced Collections |
IEX_DUNNINGS |
CONTACT_DESTINATION |
VARCHAR2(240 CHAR) |
Yes |
Contact who receives the dunning. |