Accounting Program (XLAACCUP) Ends with Error - Internal Error Has Occurred - ORA-06503 Function Returned without Value and ORA-00001 Unique Constraint Violated (Doc ID 1503495.1)

Last updated on FEBRUARY 01, 2017

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Accounting Program ends with following error after applying patch:13099983 :

---------------------------------------------------------------------------
Subledger Accounting: Version : 12.0.0
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
XLAACCUP module: Accounting Program
---------------------------------------------------------------------------
Current system time is 03-NOV-2012 11:39:56
---------------------------------------------------------------------------
**Starts**03-NOV-2012 11:39:56
**Ends**03-NOV-2012 11:40:06
An internal error occurred.  Please inform your system administrator or support representative that:

An internal error has occurred in the program XLA_00222_AAD_S_000002_PKG.EventClass_164.  ORA-06503: PL/SQL: Function returned without value.
---------------------------------------------------------------------------
Start of log messages from FND_FILE
---------------------------------------------------------------------------
03-NOV-2012 11:39:56 - Executing Unit Processor ...
03-NOV-2012 11:39:56 - Initializing variables
03-NOV-2012 11:39:56 - Security Context Set
03-NOV-2012 11:39:56 - Ready to cache the Application and Ledger Level Sources ...
03-NOV-2012 11:39:57 - Cached the Application and Ledger Level Sources
03-NOV-2012 11:39:58 - AAD Package XLA_00222_AAD_S_000002_PKG is valid. Ledger Category is PRIMARY.
03-NOV-2012 11:39:58 - AAD Package XLA_00222_AAD_C_011136_PKG is valid. Ledger Category is PRIMARY.
03-NOV-2012 11:39:58 - Entering the loop to read document units from the queue ...
03-NOV-2012 11:39:58 - Checking status of the parent Accounting Program
03-NOV-2012 11:39:58 - Dequeuing the unit from the queue
03-NOV-2012 11:39:58 - Fetching event information for the documents in the unit
03-NOV-2012 11:39:58 - executing extract hook
------------- Omit
ARP_XLA_EXTRACT_MAIN_PKG.extract()-
event key = 13481-1027246-CD8F2A623F2E261CE040B90AB3AC2089
03-NOV-2012 11:40:00 - extract hook executed successfully
ERROR : ORA-00001: UNIQUE CONSTRAINT (.) VIOLATED
ERROR : ORA-00001: UNIQUE CONSTRAINT (.) VIOLATED
ERROR : ORA-00001: UNIQUE CONSTRAINT (.) VIOLATED

The following setups have been completed:
Using Subledger Accounting Methods : Standard Accrual.
Set End Date to Application Accounting Definition : Receivables Default Accrual that is seed data of Subledger Accounting Method : Standard Accrual.
Add the customized Application Accounting Definition for Receivables to Subledger Accounting Method : Standard Accrual.

Changes

Applied Patch 13099983

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