When Trying to Enable Australian Legislation, Hrglobal Fails On pyaubalfeed.ldt - "Error Loading Seed Data For PAY_BALANCE_FEEDS_F: BALANCE_NAME = Leave Hourly Rate" (Doc ID 1994365.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Australian Payroll

hrglobal.drv 120.156.12010000.158

Trying to enable Australia legislation.

Applied R121.AU.22 then ran DataInstaller to enable Australia (AU HR + AU PAY). Then ran hrglobal.

pyaubalfeed.ldt failed to complete. The error from adpatch log:

ATTENTION: All workers either have failed or are waiting:

  FAILED: file pyaubalfeed.ldt on worker 1.

ATTENTION: Please fix the above failed worker(s) so the manager can continue.

adworker001.log shows:

Dumped the batch (PAY_BALANCE_FEEDS_F Additional_Deduction_Processed
Additional Deduction Processed AU 2011/07/01 , PAY_BALANCE_FEEDS_F Workplace
Giving Deductions Balance Initialization 6 ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
 Error loading seed data for PAY_BALANCE_FEEDS_F: BALANCE_NAME = Leave
Hourly Rate, ELEMENT_NAME = Leave Hourly Rate, INPUT_VALUE_NAME = Pay Value,
BUSINESS_GROUP_NAME = , LEGISLATION_CODE = AU, EFFECTIVE_START_DATE =
1900/01/01, EFFECTIVE_END_DATE = 4712/12/31, ORA-20001:
HR_6553_BAL_WRONG_UOM:

STEPS
The issue can be reproduced at will with the following steps:
1. Apply R121.AU.22
2. Run DataInstall and select to install for Australia HR and Australia PAY
3. Run hrglobal.drv

BUSINESS IMPACT
The issue has the following business impact:
Due to this patching issue, users cannot release a successfully patched test system to users for Australian localization testing.

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