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 laterInformation in this document applies to any platform.
Symptoms
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.
STEPS
-----------------------
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
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 |
| References |