My Oracle Support Banner

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

Last updated on JULY 01, 2022

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: DD/MM/YYYY
Enter value for end_date: DD/MM/YYYY
Enter value for email_id: user1.temporal@myxyz.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 DF: TO POPULATE AWT_RELATED_ID FOR AWT DISTRIBUTIONS WHICH DON'T HAVE AWT_RELATED_ID
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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.