My Oracle Support Banner

Sales Audit GL Cross Reference Not Populating CCID Columns (Doc ID 2871902.1)

Last updated on DECEMBER 12, 2023

Applies to:

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


The DR_CCID and CR_CCID of SA_FIF_GL_CROSS_REF are not populated even if CFIN returns CCID values in RFI GLAccount service.

The issue can be reproduced at will with the following steps:
1) System option FINANCIAL_AP is set to 'A' (RFI integrated with CFIN)
2) Ensure that RFI is integrated with CFIN
3) Login to Sales Audit
4) Download template for "GL Cross Reference"
5) Populate *.ods according to the segments defined in FIF_GL_SETUP
- leave the "Debit Ccid" and "Credit Ccid" empty (i.e., not populated)
- ensure that the DR combined segments is valid in CFIN
- ensure that the CR combined segments is valid in CFIN
6) Upload Data
7) Look at RFI GLAccount.log to confirm that CCID values are provided by CFIN
8) Query SA_FIF_GL_CROSS_REF table
- it will show the values from *.ods file
- however, DR_CCID and CR_CCID are empty, expecting these columns to be populated with the values coming from CFIN


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.