ETL Customization Error Using JournalLineExtractPVO Caused By New Attribute Added JournalSourceUserLanguage
(Doc ID 2847030.1)
Last updated on FEBRUARY 11, 2022
Applies to:
Oracle Fusion General Ledger Cloud Service - Version 11.13.21.10.0 and laterInformation in this document applies to any platform.
Symptoms
On : 11.13.21.10.0 version, GL Reports & Inquire Screens
ACTUAL BEHAVIOR
---------------
The latest Extract Data Stores for Financials for Financials documentation https://docs.oracle.com/en/cloud/saas/financials/21c/oadsr/general-ledger.html#JournalLineExtractPVO documentation does not show new attributes added after the 21D update and this is making an ETL customization fail (JournalSourceUserLanguage attribute) .
Also a few attributes are present in latest Oracle documentation as well, but the extract is not pulling them.
For example, in Journal Line (FscmTopModelAM.FinExtractAM.GlBiccExtractAM.JournalLineExtractPVO) below attributes are showing in Oracle documentation but not showing in data store.
a) GlJeLinesIgnoreRateFlag
b) GlJeLinesLineTypeCode
EXPECTED BEHAVIOR
-----------------------
The documentation and Extract Data Stores should match in order to avoid issues and confusion.
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Have an ETL customization using JournalLineExtractPVO
2. Update to 21D release.
3. Now the extract shows JournalSourceUserLanguage and the documentation for JournalLineExtractPVO does not have it
4. The attributes GlJeLinesIgnoreRateFlag and GlJeLinesLineTypeCode are in the documentation and not in the extract
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 |
Cause |
Solution |