Hrglobal Run Fails Loading pyusupdbalfeed.sql with Error ORA-20001: HR_6109_BAL_UNI_FEED (Doc ID 2034399.1)

Last updated on JANUARY 31, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Patch Application Issues

When attempting to run hrglobal after applying HRMS Rup 8 20000288, the following error occurs in payusbalfeeds.ldt.

Last week I applied also Q2 2015 Patch 21142484 and the same FNDLOAD fails on hrglobal run. I skipped this time too.

Error loading seed data for PAY_BALANCE_FEEDS_F: BALANCE_NAME = Head Tax Withheld In State, ELEMENT_NAME = CITY_HT_WK_ARR, INPUT_VALUE_NAME = Pay Value, BUSINESS_GROUP_NAME = , LEGISLATION_CODE = US, EFFECTIVE_START_DATE = 0001/01/01, EFFECTIVE_END_DATE = 4712/12/31, ORA-20001: HR_6109_BAL_UNI_FEED:



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

1. Run hrglobal
2. Error occurs when loading payusbalfeeds.ldt.


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