My Oracle Support Banner

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 NOVEMBER 05, 2019

Applies to:

Oracle Purchasing - Version 12.1.3 and later
Oracle General Ledger - Version 12.1.3 and later
Information in this document applies to any platform.

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 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)

 

Changes

 

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
Changes
Cause
Solution
References


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