Payroll Error After 2012 End Of Year 2012 Statutory Update II Patch

A number of customers are experiencing the following error after applying the US & CANADA END OF YEAR 2012 STATUTORY UPDATE II patch, and while running HRglobal.drv:

"ORA-20001: You cannot set the SAVE_RUN_BALANCE flag to 'N' or Null whilst valid run balances exist for the defined balance."

The US & CANADA END OF YEAR 2012 STATUTORY UPDATE II patches are:

In the readme for these patches, in the post install steps, the following is noted:

This patch delivers change to disable the Run Balances for Defined Balance "Gross Earnings Assignment Quarter to Date". During HRGlobal Installation, if Valid Run Balances are found for this Defined Balance, then the process will fail with below error:                                                          
                                                                                   
ERROR at line 1; ORA-20001: You cannot set the SAVE_RUN_BALANCE flag to 'N' or Null whilst valid run balances exist for the defined balance.
                                                                                 
In order to prevent this error during HRGlobal Installation, it is necessary to execute below mentioned SQL Update Statement before HRGlobal Installation to invalidate the Run Balances present for this Defined Balance.
                                                                  
UPDATE pay_balance_validation pbv 
SET run_balance_status = 'I' 
WHERE pbv.run_balance_status <> 'I'     
   AND pbv.defined_balance_id IN   
    (SELECT defined_balance_id   
       FROM pay_defined_balances pdb,  
            pay_balance_types pbt,      
            pay_balance_dimensions pbd  
      WHERE pdb.legislation_code = 'US'
        AND pdb.balance_type_id = pbt.balance_type_id 
        AND pbt.balance_name = 'Gross Earnings'  
        AND pbt.legislation_code = 'US'
        AND pdb.balance_dimension_id = pbd.balance_dimension_id   
        AND pbd.database_item_suffix = '_ASG_QTD' 
        AND pbd.legislation_code = 'US');
                                                                           
 
Please follow the steps as given in the patch readme to resolve this issue.

Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
About

Welcome to the EBS Support Blog where Oracle insiders share news and information about EBS products including new releases, tips and tricks, troubleshooting guides, upcoming webcasts and links to EBS Communities.

Stay Connected

Twitter

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
5
6
12
13
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today