My Oracle Support Banner

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 and later
Information in this document applies to any platform.


On : version, GL Reports & Inquire Screens

The latest Extract Data Stores for Financials for Financials documentation 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

The documentation and Extract Data Stores should match in order to avoid issues and confusion.

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


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

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