My Oracle Support Banner

Business Date In STG_FIF_GL_DATA Table Is Wrongly Mapped to REFERENCE 9 Field (Doc ID 2778256.1)

Last updated on AUGUST 16, 2022

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 19.2 and later
Information in this document applies to any platform.


Business date In STG_FIF_GL_DATA table is available in REFERENCE 9 field instead of REFERENCE 6. 

Reference: Mapping Business Date to GL Reference Field – (As per Advance Release Notification Release 19.2 )

“Mapping Business Date to GL Reference Field Currently for Sales Audit, if a total posts to the General Ledger late, even considering the new system option noted above, the accounting date sent to the General Ledger uses the first day of the open month and visibility to the business date when it should have posted is lost. To allow for the business date visibility in the GL for such cases, an enhancement in this release will post the business date in a reference field (reference field 6) in the General Ledger for all totals, even those that do not post late.”




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.