My Oracle Support Banner

Brazil Localizations: WHO columns are not getting updated in table JL_BR_AR_COLLECTION_DOCS_ALL when Boleto is received in confirmed status. (Doc ID 2658344.1)

Last updated on AUGUST 13, 2021

Applies to:

Oracle Financials for the Americas - Version 12.1.1 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
---------------
WHO columns (e.g. LAST_UPDATE_DATE) are not getting updated in table JL_BR_AR_COLLECTION_DOCS_ALL when Boleto is received in confirmed status.

EXPECTED BEHAVIOR
-----------------------
WHO columns (e.g. LAST_UPDATE_DATE) should get updated in table JL_BR_AR_COLLECTION_DOCS_ALL when Boleto is received in confirmed status.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Occurrence window.
  N--> Brazilian Localization > Transactions > Bank Collections > Occurrences
2. Receive the Trade note.
3. Check the Last_update_date in the table 'JL_BR_AR_COLLECTION_DOCS_ALL'
4. Observe the late_update_date column is not getting updated.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot maintain statutory compliance with Audit trails.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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