My Oracle Support Banner

EAR 9.2: When Running AR_DIRDEBIT Application Engine for Multiple Business Units From Different Setid Is Failing At AR_DIRDEBIT.GETID_SM.Step 10 "ORA-00001:Unique Constraint(sysadm.PS_DD_CONTROL) Violated" (Doc ID 2915386.1)

Last updated on SEPTEMBER 21, 2023

Applies to:

PeopleSoft Enterprise FIN Receivables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms


AR_DIRDEBIT Application engine is going into no success with the following error when running for multiple business units under different setid.

 


Replication:
--------------
1: Setup multiple business units under different setids.( Setup financials> Business unit related> Receivables> Receivable definition)
2: Create pending items under different business units with payment method as DD, and post these items. ( Accounts Receivable> Pending Items> Online Items> Online Item Group Entry)
3: Run AR_DIRDEBIT process with multiple business units. (Accounts Receivable> Direct Debits> Administer Direct Debits> Create Direct Debits)
4: Process fails with unique constraint error.


 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


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