Invalid Object PO_REQAPPROVAL_ACTION After Patch 24377088:R12.PO.D

(Doc ID 2216583.1)

Last updated on DECEMBER 21, 2016

Applies to:

Oracle Purchasing - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

Invalid object PO_REQAPPROVAL_ACTION has appeared post Patch.24377088:R12.PO.D.



Error
SQL> select name, text from dba_errors
 2 where upper(name)=upper('PO_REQAPPROVAL_ACTION');

NAME
--------------------------------------------------------------------------------
TEXT
--------------------------------------------------------------------------------
PO_REQAPPROVAL_ACTION
PLS-00302: component 'UPDATE_SPOTBUY_FLAG' must be declared

PO_REQAPPROVAL_ACTION
PL/SQL: Statement ignored

Line 822: por_util_pkg.update_spotbuy_flag(l_document_id,l_org_id);


STEPS
The issue can be reproduced at will with the following steps:
1. Apply the Patch.24377088:R12.PO.D.
2. Find the object is invalid.




Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms