ECM: Book to Bank Reconciliation abends at Step TR_BTB_CALC.Populate.Table2 with Unique Constraint error (Doc ID 1448489.1)

Last updated on MAY 30, 2016

Applies to:

PeopleSoft Enterprise FIN Cash Management - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.

Symptoms

When an AR Payment with an Accounting Date in the next fiscal period is unposted, Book to Bank Reconciliation TR_BTB_CALC will abend with a unique constraint.

ERROR
Process ABENDED at Step TR_BTB_CALC.Populate.Table2
(Action SQL) -- RC = 805
ROLLBACK
/
SQL Error: ORA-00001: unique constraint (EMDBO.PS_BNK_BTB_DTL) violated

STEPS
1. Go to Banking > Bank Accounts > External Accounts and assign Reconciliation Rule PS_BNK_RCN_PAYMENT to bank account.

2. Go to Accounts Receivable > Payments > Online Payments > Regular Deposit and create a payment in the next fiscal period of the AsOfDate of the bank statement.

3. Go to Accounts Receivable > Payments > Apply Payments > Create Worksheet and apply the payment.

4. Go to Accounts Receivable > Receivables Update > Request Receivables Update and run AR Update.

5. Go to Banking > Reconcile Statements > Semi-Manual Reconciliation and reconcile bank statement to AR payment.

6. Go to Accounts Receivable > Receivables Update > Unpost Group > Payment Group and unpost the AR payment.

7. Go to General Ledgers > Journals > Subsystem Journals > Generate Journals and run Journal Generate for the next fiscal for templates AR_PAYMENT and AR_MAINT (Payment Unpost) so that both the AR Payment and Payment Unpost are posted to GL.

8. Go to Banking > Reconcile Statements > Select Book to Bank Reconciliation and Select and Calculate Book to Bank Reconciliation.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms