After Edit Requisition Error During Checkout: REBUILD_APPROVAL_LIST-006: ORA-1403: No Data Found (Doc ID 1340035.1)

Last updated on AUGUST 21, 2016

Applies to:

Oracle iProcurement - Version: 12.1 and later   [Release: 12.1 and later ]
Information in this document applies to any platform.

Symptoms

After editing a requisition, created in Core PO, when checking out in iProcurement, the following error occurs:

REBUILD_APPROVAL_LIST-006: ORA-1403: no data found Cause: A SQL error has occurred in REBUILD_APPROVAL_LIST. The SQL error is &LSQL_ERR. Action: Take note of both this error number and the actions you were trying to perform. Contact your system administrator for further assistance.

The issue can be reproduced as followed:
1. Create a requisition using forms and submit it for approval.
2. As approver open the notification.
3. Click on Edit Requisition and click on Checkout.
4. Choose Submit. At this moment the above mentioned error occurs.

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