ITD Dimension Issue: Years Of Service Balance Invalid When Creating Balance Adjustment (Doc ID 2001319.1)

Last updated on JANUARY 03, 2017

Applies to:

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

Symptoms

Oracle EBS Applications release 12.1, running Canadian Payroll, when you do a balance adjustment you see data populated in the pay_latest_balances table with incorrect expiry date.

The Vacation setup:

Vacation plan has both hour accrual and dollar accrual. i.e. Along with hours, employees also accrue some part of their pay check in the Dollar
bucket. Whenever they take vacation, amount will be released from it.

Hour Accrual is handled by PTO. We see no issues in that.

For Dollar accrual, they have payroll elements and payroll balances setup.
One of the balance is "Vacation years of Service".
This balance has incorrect values. To correct it, you tried balance adjustments and discovered this issue.

Balance adjustment to a payroll balance: Balance Name - "Vacation Years of Service"

Issue : When you do the balance adjustment, you see the expiry date of the balance adjustment set to 1-Jan-00 (Table name: Pay_Latest_balances). Due to
this, whenever you query the balance it returns the value as 0.

You are trying to update Years of Service on the Vacation Accrual Plan. A balance adjustment was done before go live in 2013 to update the balance.
You are trying to make adjustments to this balance using the balance adjustment form. When you run payroll for the following period, Years of Service becomes 0. The older balance adjustments has an expiry date of 31-DEC-4712 but the current balance adjustments are expiring as of 01-JAN-00

Then added the dimension ASG_ITD to the balance and checked the balance value. Its returning the value as expected. But when using the dimension ASG_GRE_ITD, it returns 0.

Given:

BALANCE_DIMENSION_ID DIMENSION_NAME DIMENSION_TYPE EXPIRY_CHECKING_CODE EXPIRY_CHECKING_LEVEL
194 Assignment within Government Reporting Entity Inception To Date A N
195 Government Reporting Entity Inception To Date N
213 Assignment Inception To Date A N
275 US Element Entry Inception to Date A N
288 Assignment Inception To Date A N
307 Assignment within Government Reporting Entity Inception To Date A N
321 Assignment within Tax Group Inception to date A N
333 Government Reporting Entity Inception To Date N
91 Assignment Inception To Date A N
100 Person Inception To Date P N
109 Element Entry Inception To Date A N
114 Assignment Within Tax Unit Inception To Date A
pay_ip_expiry_support.date_ec N
123 Person Within Tax Unit Inception To Date P N

Added the dimension ASG_ITD to the balance and checked the balance value. It is returning the value as expected. But the dimension ASG_GRE_ITD returns 0.

Options Attempted:

A:
update pay_balance_dimensions
set expiry_checking_code = NULL
where balance_dimension_id = 114;

That did not  work.


B:
Tried to update Years of Service on the Canada Vacation Accrual Plan.  

1. A balance adjustment was done before go live in 2013 to update the balance.  

2. Make adjustments to this balance using the balance adjustment form.  

3. Run payroll for the following period

4. Note that Years of Service becomes 0.  
   The older balance adjustment has an expiry date of 31-DEC-4712
   The current balance adjustments are expiring as of 01-JAN-00.

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