PSA_AP_BC_PVT is invalid - Unaccounted Transactions Report Fails with ORA-06508 (Doc ID 1533239.1)

Last updated on DECEMBER 08, 2014

Applies to:

Oracle Payables - Version 12.1.2 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.2 version,


When trying to close the period,
Unaccounted Transactions Report (XML) fails with the following errors:

get_unposted_transaction: return value=
EXCEPTION: process_period:
ORA-06508: PL/SQL: could not find program unit being called
end before_report_apxuatr

A trace file shows that AP_PERIOD_CLOSE_PKG package is
calling package body PSA_AP_BC_PVT,
but PSA_AP_BC_PVT is invalid.

PSA_AP_BC_PVT fails to compile due to the following errors:

COMPILATION ERRORS
--------------------
PSA_AP_BC_PVT PACKAGE BODY

291 26 PLS-00302: component 'PSA_XLA_ERROR' must be declared
346 28 PLS-00302: component 'PSA_XLA_ERROR' must be declared
1158 24 PLS-00302: component 'PSA_XLA_ERROR' must be declared




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