My Oracle Support Banner

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.


On : 12.2.7 version, Australian Payroll

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

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(

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




To view full details, 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 a vibrant support community of peers and Oracle experts.