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 laterOracle 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 <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
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 |
References |