Double Values For Sales Sent In GL_EXTRACT File For A Store (Doc ID 3006715.1)

Last updated on FEBRUARY 26, 2024

Applies to:

Symptoms

Double values for sales sent in GL_EXTRACT file for a store. This affected only some previous days.

After loading the POSU files to RMS, when the fifgldn2 is executed the below error occurs:
"fifgldn2_5~XXXXXXXXXXXX~get_gl_mapping~fif_gl_cross_ref~1403~ORA-01403: no data found~ No ccid exist for dept XXXX class -1 subclass -1 location XXXXX tran_code 1 cost_retail_flag C for gl upload".

The error occurs because the GL mapping for that combination is not present in the FIF_GL_CROSS_REF table. Later on, the mapping for that combination is added on the sa_fif_gl_cross_ref table but after that the data in the GL_EXTRACT file for that store are sent as doubles (the data from the stg_fif_gl_data table).

For reference the below queries:

select sum(total_cost),sum(total_retail) from rms01.tran_data_history where location=XXXXX and tran_code=1 and dept=XXXX and tran_date='21-DEC-23';
--the Y value

select * from rms01.stg_fif_gl_data where USER_JE_CATEGORY_NAME='RMS' and ATTRIBUTE4='XXXXX' and ATTRIBUTE5='1' and ATTRIBUTE1='XXXX' and ACCOUNTING_DATE='21-DEC-23';
--the Y value is double

The steps to reproduce the issue:
1. Load sales data to ReSA.
2. Run salesprocess to load the POSU files to RMS.
3. See the GL mappings are not present for that store in the FIF_GL_CROSS_REF table.
4. Run FIFGL* batches (fifgldn2 and fifgldn3). Data is present in tran_data_errors.
5. Create sa_fif_gl_cross_ref mappings for that store.
6. Data in the GL_EXTRACT file for that store are sent as doubles.

Cause

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