Unable To put End Date on Define Third Party Registration Form. (Doc ID 2349565.1)

Last updated on JANUARY 30, 2018

Applies to:

Symptoms

On : 12.1.3 version, GST

When attempting to enter end date on Third Party Registration Form,
the following error occurs in the form.

ERROR
-----------------------
 "FRM-40654: Record has been updated. Requery block to see change"

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to Oracle Financials for India Responsibility
2. Party Registration > Third Party Registration

Perform the following action plan, still issue remains same:

1.
update jai_reporting_associations 
set EFFECTIVE_FROM=trunc(effective_from), 
EFFECTIVE_TO=trunc(effective_to); 
2.
update jai_party_reg_lines 
set EFFECTIVE_FROM=trunc(effective_from), 
EFFECTIVE_TO=trunc(effective_to); 
3. Below query returns 0:
select count(*) from JAI_REPORTING_ASSOCIATIONS 
where REPORTING_USAGE is not null; 
4. jain89.odf latest version 
5. 'afchrchk.sql' script was run on 
1) SELECT * FROM jai_party_reg_lines; 
2) SELECT * FROM jai_reporting_associations;

Cause