Invalid POXVDCKB.pls Results in Mutlpile Purchase Order Errors Post RUP11 Patch Application
(Doc ID 2379715.1)
Last updated on AUGUST 06, 2020
Applies to:
Oracle Purchasing - Version 12.2.4 and laterInformation in this document applies to any platform.
Symptoms
Multiple PO errors due to invalid POXVDCKB.pls after patch
STEPS TO REPRODUCE
--------------------
Scenario A
1. Purchasing
2. Purchasing summary - Find a PO, open. the page won't show the related PO, but more like a new to create page.
Scenario B
1. Purchasing
2. Create a PR or PO, submit for an approval. Upon click submit button.
Error message: User-defined Exception in Package PO_DOCUMENT_CHECKS_GRP Procedure PO_SUBMISSION_CHECK
While try to manually compile, below errors
+++++++++
Body 4 11 PLS-00323: subprogram or cursor 'GET_PR_LINE_ATTR_GROUP_IDS' is declared in a package specification and must be defined in the package body
++++++++
17:01:00 Info: 1 package had errors on compile. Last error message: Success with compilation error,
17:01:23 Info: 1 package had errors on compile. Last error message: Success with compilation error,
11:00:03 Info: 1 package successfully compiled. 1 package had errors on compile. Last error message: Success with compilation error
+++++++++
SQL> @POXVDCKB.pls
Warning: Package Body created with compilation errors.
++++++++++
SQL> @POR_UDA_PKG.plb
CREATE OR REPLACE PACKAGE BODY por_uda_pkg
Warning: Package Body created with compilation errors.
++++++++++
Changes
RUP11 Patch
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 |