Users Are Getting ORA-6512 at APPS.PO_DRILLDOWN_PUB_PKG Error When Drilling Down To A PO Transaction on the GL Journal Entry Inquiry Form (Doc ID 2605652.1)

Last updated on JUNE 22, 2023

Applies to:

Symptoms

Using Purchasing, Version 12X users are getting an error in GL Journal Entry form when drilling down into a Purchase Order Transaction which has been deleted

Error

---------

There is a technical error. Please inform your system administrator or support representative that: The drilldown procedure

PO_DRILLDOWN_PUB_PKG.DRILLDOWN is returning the following error: java.sql.SQLException: ORA-6510: PL/SQL: unhandled user-defined exception

ORA-6512: at "APPS.PO_DRILLDOWN_PUB_PKG", line 307 ORA-1403: no data found ORA-6512: at line 1

---------------------------------------------------------------------------------------------------------------------------------------

Steps to Reproduce the Issue

-----------------------------------

1. Login to a GL Responsibility 

2. Navigate to Inquiry-Journals

3. Query the journal and attempt to view the transaction that came from the deleted PO

Pre-requisite- there will need to be a PO which was encumbered and then the Transfer to GL concurrent program is run in PO and then PO is deleted - this would re-create the issue

======================================================================================================

In Purchasing, a Purchase Order can be encumbered and then deleted and this is standard functionality 

See ER <Bug <span>25781127> for more on this 

Users should get better/more informative message so that they know there is no actual error 

(Reminder: This is not a fix for not being able to delete the PO - this is a fix on the Journal Inquiry-transaction drilldown to avoid the error)

Cause

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