R12: AP: EMEA VAT Select Process Not Fetching Data Due to Differing GL Dates Between Payables and Accounting (Doc ID 2908179.1)

Last updated on NOVEMBER 22, 2022

Applies to:

Symptoms

On: 12.2.7 version, Accounting Issues in Payables

ACTUAL BEHAVIOR
---------------
GL date not in sync between the Invoice, ZX and accounting tables.

Upon querying the invoice the following error message arises

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

EXPECTED BEHAVIOR
-----------------------
The GL date has to be in sync in all of the tables in-order for the data to be fethced by the report

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to the Payables Manager
2. Invoices -> Entry -> Invoices
3. Actions Tab -> Validate, account the invoice and then re-query the invoice

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot fetch the data into the EMEA VAT Selection Process

Cause

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