FND FND_AS_UNEXPECTED_ERROR N PKG_NAME RCV_AccEvents_PVT N PROCEDURE_NAME While applying Data Fix 'DF_MISSING_RRSL_R12' (Doc ID 2104160.1)

Last updated on FEBRUARY 05, 2016

Applies to:

Oracle Purchasing - Version 12.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.1 version, Accounting related 

While applying the generic data fix 'df_missing_rrsl_r12.sql' to recreate the missing accounting in receiving sub ledger, the following error occurs :

ERROR
Data fix Error for Accounting for TXN: 630523
PO Header ID : 270086
Error ocurred while creating Accounting for TXN: 630523
l_msg_count : 1
l_msg_data : FND FND_AS_UNEXPECTED_ERROR N PKG_NAME RCV_AccEvents_PVT N PROCEDURE_NAME Create_ReceivingEventStatement -60 N ERROR_TEXT ORA-01403: no data found


STEPS TO REPRODUCE

The issue cannot be reproduced at will with the following steps: 

1. Login to SQL Developer /Toad
2. Run the data fix 'df_missing_rrsl_r12.sql' 
3. The data fix completes with the above 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