PLS-00302

Error For Package Body APPS.OE_HEADER_PAYMENT_UTIL Error PLS-00302: component 'PAYMENT_PERCENTAGE' must be declared [ID 1059708.1]

Applies to:

Oracle Order Management - Version 12.0 to 12.1.1 [Release 12.0 to 12.1]
Information in this document applies to any platform.

Symptoms

On : 12.1.1 version, Transaction Entry

When trying to enter credit card Sales orders it fails due to error 'Could not find program unit called in package OE_Order_PVT Procedure Header_Payments. This is caused due to Invalid Object OE_HEADER_PAYMENT_UTIL.

When attempting to compile OE_HEADER_PAYMENT_UTIL package body the following error occurs.

ERROR
-----------------------
3494/13 PL/SQL: Statement ignored
3494/73 PLS-00302: component 'PAYMENT_PERCENTAGE' must be declared

Changes

Issue has been  reported when upgrading from 11.5.x to R12 and subsequent application of some more patches.
Issue has been reported after applying Patch 8937577.

Cause

As part of fix for Bug  8478559 , OE_Value_To_Id package was modified to include the function Payment_Percentage in file OEXSVIDS.pls-120.3.12010000.2.  Lower version of file OEXSVIDS.pls does not have the function Payment_Percentage for Value to ID conversion
hence all the calls to this function OE_Value_To_Id.Payment_Percentage would fail.

Problem while compiling OEXSVIDB.pls after applying Patch 8937577.

Error message:
3494/73 PLS-00302: component 'PAYMENT_PERCENTAGE' must be declared
This issue was reported on Bug 7608581, fix created on OEXSVIDB.pls version 120.9.12010000.2
This version is included on Patch 7608581:R12.ONT.B .

Solution

To implement the solution, please execute the following steps:

1. Download and review the readme and pre-requisites for Patch 7608581.

2. Ensure that you have taken a backup of your system before applying
the recommended patch.

3. Apply the patch in a test environment.

R12.0, apply Patch 7608581:R12.ONT.A
Upgrade to files and version
OEXSVIDB.pls   120.8.12000000.3
OEXSVIDS.pls   120.3.12000000.2

R12.1.1, apply Patch 7608581:R12.ONT.B
Upgrade to files and version
OEXSVIDB.pls   120.9.12010000.2
OEXSVIDS.pls   120.3.12010000.2

4. Confirm the file versions.

You can use the commands like the following:
strings -a $ONT_TOP/filename |grep '$Header'

5. Retest the issue.

6. Migrate the solution as appropriate to other environments.