Receipt Accrual Period End Process Completes in Error Ora-6502 and Ora-01403 (Doc ID 2250577.1)

Last updated on APRIL 04, 2017

Applies to:

Oracle Purchasing - Version 12.1 to 12.2.5 [Release 12.1 to 12.2]
EMEA Add-on Localizations - Version 12.1.3 to 12.2.5 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

When Running the Program "CSTPEACR: Receipt Accruals - Period-End " It is Completed with an Error :

ERROR:
-------
1-(20) : ORA-01403: no data found
ORA-01403: no data found
ORA-01403: no data found
ORA-06512: at "APPS.CLEF113_RCV_REC_SUB_LEDGER_BIR", line 21
ORA-04088: error during execution of trigger 'APPS.CLEF113_RCV_REC_SUB_LEDGER_BIR' in Package CST_ReceiptAccrualPerEnd_PVT Procedure Insert_AccrualSubLedger
2-(160) : ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "APPS.FND_MSG_PUB", line 279
ORA-06512: at "APPS.CST_RECEIPTACCRUALPEREND_PVT", line 1719
ORA-01403: no data found
ORA-01403: no data found in Package CST_ReceiptAccrualPerEnd_PVT Procedure Create_AccrualAccount

Steps to Reproduce:

------------------------

1. Navigate to Purchasing Responsibility .
2. Run Receipt Accruals - Period End Program.
3. The program is completed with Error.

 

 

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