ECM: Parse Statement Addenda (BNK_RCN_ADDN) Deletes Reconciled Data from PS_BANK_ADDEND_TBL (Doc ID 2904956.1)

Last updated on OCTOBER 25, 2022

Applies to:

Symptoms

Parse Statement Addenda (BNK_RCN_ADDN) Deletes PS_BANK_ADDEND_TBL for Reconciled Lines

STEPS

1. Set Up Financials/Supply Chain > Common Definitions > Data Export Import Utility > DEIU Map Definition > use delivered Map ID = BANK_RECON_PD_MAP

2. Banking > Administer Reconciliation > Assign Addenda Parse ID > Map ID = BANK_RECON_DS_MAP

3. Banking > Bank Statements > Enter Bank Statements > enter a Bank Statement with multiple lines with each containing Addenda information

4. Banking > Reconcile Statements > Parse Statement Addenda > process populates PS_BANK_ADDEND_TBL

5. Banking > Reconcile Statements > Semi-Manual Reconciliation > reconcile some of the Bank Statement lines > reconciled lines seen in PS_BANK_ADDEND_TBL

6. Set Up Financials/Supply Chain > Common Definitions > Data Export Import Utility > DEIU Map Definition > Map ID = BANK_RECON_PD_MAP > make any change to the delivered BANK_RECON_PD_MAP > Save

7. Run Parse Statement Addenda > Banking > Reconcile Statements > Parse Statement Addend

8. Query PS_BANK_ADDEND_TBL > Reconciled bank statement lines from step 3 are no longer in PS_BANK_ADDEND_TBL

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.