Initial Balance Upload Giving Error 'Adjustment Is Not Valid' (Doc ID 2075811.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Symptoms

When attempting to run Initial Balance Upload program for initializing the balance "Income Tax Deduction" or "Professional Tax" ,
the following error occurs.

ERROR
-----------------------
Assignment No XXXX error for balance INCOME TAX DEDUCTION__ASG_YTD

message :-
The adjustment is not valid (ADJ_DATE=31-DEC-12)
begin
*
ERROR at line 1:
ORA-20001:
ORA-06512: at line 3



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

1. Insert records in pay_balance_batch_headers and pay_balance_batch_lines

2. Run "India Initial Balance Structure Creation" program

3. Run "Initial balance upload" program for the created batch

   Program errored with  message :-
   The adjustment is not valid (ADJ_DATE=31-DEC-12)

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.