AU End Of Year Reconciliation Detail Report XML Fails with PLS-00302: component 'CS_PS_OI' must be declared

(Doc ID 2406507.1)

Last updated on JUNE 01, 2018

Applies to:

Oracle HRMS (Australia) - Version 12.2.7 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.7 version, Australian Payroll

When attempting to Run End of Year Reconciliation Detail (XML),
the following error occurs.

ERROR
-----------------------
Data Template Code: PYAUREPSR_XML
Data Template Application Short Name: PAY
Debug Flag: N
{}
Calling XDO Data Engine...
[041818_103748977][][ERROR] Variable 'CS_PS_OI' is missing....
[041818_103748977][][EXCEPTION] java.sql.SQLException: ORA-06550: line 2, column 40:
PLS-00302: component 'CS_PS_OI' must be declared
ORA-06550: line 2, column 7:
PL/SQL: Statement ignored

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run End of Year Reconciliation Detail (XML)
2. Error



Changes

 

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