My Oracle Support Banner

Invalid Objects (PAY_SID_RKU, PAY_CPT_RKU, PAY_IE_PRSI_BK1, PAY_CA_EMP_PRVTAX_INF_BK2) with PLS-00323 Error After Upgrading from R12.1 to R12.2 (Doc ID 2393549.1)

Last updated on MAY 01, 2018

Applies to:

Oracle Payroll - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

Problem Statement:

Following Payroll packages are invalid after upgrading the system from R12.1 to R12.2.

PAY_CPT_RKU
PAY_CPT_RKI
PAY_CPT_RKD
PAY_CA_EMP_PRVTAX_INF_BK2
PAY_CA_EMP_PRVTAX_INF_BK1
PAY_SID_RKU
PAY_SID_RKI
PAY_SID_RKD
PAY_IE_PRSI_BK2
PAY_IE_PRSI_BK1
PAY_IE_PAYE_BK2
PAY_IE_PAYE_BK1

Errors:

PAY_CA_EMP_PRVTAX_INF_BK1 Package Body pycprapi.pkb - 120.2.12000000.1 PLS-00323: subprogram or cursor 'CREATE_CA_EMP_PRVTAX_INF_B' is declared in a package specification and must be defined in the package body
PAY_CA_EMP_PRVTAX_INF_BK1 Package Body pycprapi.pkb - 120.2.12000000.1 PLS-00323: subprogram or cursor 'CREATE_CA_EMP_PRVTAX_INF_A' is declared in a package specification and must be defined in the package body
PAY_CA_EMP_PRVTAX_INF_BK2 Package Body pycprapi.pkb - 120.2.12000000.1 PLS-00323: subprogram or cursor 'UPDATE_CA_EMP_PRVTAX_INF_B' is declared in a package specification and must be defined in the package body
PAY_CA_EMP_PRVTAX_INF_BK2 Package Body pycprapi.pkb - 120.2.12000000.1 PLS-00323: subprogram or cursor 'UPDATE_CA_EMP_PRVTAX_INF_A' is declared in a package specification and must be defined in the package body
PAY_CPT_RKD Package Body pycprrhi.pkb - 120.1.12010000.3 PLS-00323: subprogram or cursor 'AFTER_DELETE' is declared in a package specification and must be defined in the package body
PAY_CPT_RKI Package Body pycprrhi.pkb - 120.1.12010000.3 PLS-00323: subprogram or cursor 'AFTER_INSERT' is declared in a package specification and must be defined in the package body
PAY_CPT_RKU Package Body pycprrhi.pkb - 120.1.12010000.3 PLS-00323: subprogram or cursor 'AFTER_UPDATE' is declared in a package specification and must be defined in the package body
PAY_IE_PAYE_BK1 Package Body pyipdapi.pkb - 120.7 PLS-00323: subprogram or cursor 'CREATE_IE_PAYE_DETAILS_A' is declared in a package specification and must be defined in the package body
PAY_IE_PAYE_BK1 Package Body pyipdapi.pkb - 120.7 PLS-00323: subprogram or cursor 'CREATE_IE_PAYE_DETAILS_B' is declared in a package specification and must be defined in the package body
PAY_IE_PAYE_BK2 Package Body pyipdapi.pkb - 120.7 PLS-00323: subprogram or cursor 'UPDATE_IE_PAYE_DETAILS_A' is declared in a package specification and must be defined in the package body
PAY_IE_PAYE_BK2 Package Body pyipdapi.pkb - 120.7 PLS-00323: subprogram or cursor 'UPDATE_IE_PAYE_DETAILS_B' is declared in a package specification and must be defined in the package body
PAY_IE_PRSI_BK1 Package Body pysidapi.pkb - 115.2 PLS-00323: subprogram or cursor 'CREATE_IE_PRSI_DETAILS_B' is declared in a package specification and must be defined in the package body
PAY_IE_PRSI_BK1 Package Body pysidapi.pkb - 115.2 PLS-00323: subprogram or cursor 'CREATE_IE_PRSI_DETAILS_A' is declared in a package specification and must be defined in the package body
PAY_IE_PRSI_BK2 Package Body pysidapi.pkb - 115.2 PLS-00323: subprogram or cursor 'UPDATE_IE_PRSI_DETAILS_A' is declared in a package specification and must be defined in the package body
PAY_IE_PRSI_BK2 Package Body pysidapi.pkb - 115.2 PLS-00323: subprogram or cursor 'UPDATE_IE_PRSI_DETAILS_B' is declared in a package specification and must be defined in the package body
PAY_SID_RKD Package Body pysidrhi.pkb - 120.1 PLS-00323: subprogram or cursor 'AFTER_DELETE' is declared in a package specification and must be defined in the package body
PAY_SID_RKI Package Body pysidrhi.pkb - 120.1 PLS-00323: subprogram or cursor 'AFTER_INSERT' is declared in a package specification and must be defined in the package body
PAY_SID_RKU Package Body pysidrhi.pkb - 120.1 PLS-00323: subprogram or cursor 'AFTER_UPDATE' is declared in a package specification and must be defined in the package body

 

 

Steps to Reproduce:

The issue can be reproduced at will with the following steps:

  1.  Upgrade from R12.1 to R12.2.
  2.  Some Payroll objects become invalid.

 

Cause

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.