Last updated on FEBRUARY 05, 2016
Applies to:Oracle Purchasing - Version 12.0.0 and later
Information in this document applies to any platform.
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 :
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms