APPS Packages Are Becoming Invalid In Regular Intervals (Doc ID 2106240.1)

Last updated on FEBRUARY 12, 2016

Applies to:

Oracle Inventory Management - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version, Receiving Functions

After applying patch 22493192:R12.PO.D, RCV_ROI_TRANSACTION is invalid, causing issue in PO receiving.

ERROR
------------------------------
RCV_ROI_TRANSACTION RCVPRETS.pls 120.10.12020000.3 SPEC VALID
RCV_ROI_TRANSACTION RCVPRETB.pls 120.83.12020000.25 BODY INVALID
Errors for PACKAGE BODY RCV_ROI_TRANSACTION
PLS-00313: 'VALIDATE_OPM_BATCH_STEP' not declared in this scope
PL/SQL: Statement ignored



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Attempt to receive.
2. RTM or RTP does not process receipts.
3. Find invalids in the instance.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot complete receiving.

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