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 JUNE 22, 2023

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.


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




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)



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

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