AP_AWT_RELATED_ID_SEL.sql fails with ERROR at line 1 ORA-20001 ORA-06512 (Doc ID 1981020.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms


While running AP_AWT_RELATED_ID_SEL.sql ( from patch 20407187, as indicated in Doc ID 1061563.1 )
the following error shows up:

ERROR
-----------------------
Enter value for start_date: 01/01/2012
Enter value for end_date: 31/12/2014
Enter value for email_id: user1.temporal@mycompany.com Enter value for org_id: 127 DECLARE
*
ERROR at line 1:
ORA-20001:
ORA-06512: at "APPS.APP_EXCEPTION", line 72
ORA-06512: at line 675

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply patch 20407187
2. Run AP_AWT_RELATED_ID_SEL.sql

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot complete the action plan for the parent service request 3-10180216511

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