My Oracle Support Banner

Receipt Workbench: Creating A New Global Receipt Method Account Produces APP-SQLAP-10000 ORA-00001 (Doc ID 744070.1)

Last updated on FEBRUARY 03, 2019

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

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
Changes
Cause
Solution
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
 Still Have Questions?
References


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