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:

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

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