Receipt Workbench: Creating A New Global Receipt Method Account Produces APP-SQLAP-10000 ORA-00001

(Doc ID 744070.1)

Last updated on APRIL 17, 2018

Applies to:

Oracle Financials for the Americas - Version 12.0.4 and later
Information in this document applies to any platform.
This problem can occur on any platform.
ARXSUDRC

Symptoms

When trying to create a global receipt method the following error occurs:


APP-SQLAP-10000: ORA-00001: unique constraint
(JL.JL_BR_AR_REC_MET_ACC_EXT_U1) violated occured in
JL_BR_AR_REC_MET_ACCTS_EXT_PKG.INSERT_ROW<-JLBRRDPM
with parameters (receipt_method_id = 1000bank_acct_use_id = 10002)
while performing the following operation:
Insert into JL_BR_AR_REC_MET_ACCTS_EXT


Steps to Reproduce:

Responsibility: Receivables Manager
Navigation
: Setup > Receipts > Receipt Class

  1.  enter information

Changes

Upgrade to Release 12

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