My Oracle Support Banner

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

Last updated on JANUARY 16, 2018

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

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.