ReSA/SACS - Require Details On GL Data Process From SACS To CFIN In V24 (Doc ID 3059813.1)

Last updated on FEBRUARY 04, 2025

Applies to:

Goal

ReSA/SACS - Require details on GL data process from SACS to CFIN in V24

You need to understand the following points related to the GL data process (STG_FIF_GL_DATA table) in V24 -

1. How the PROCESSED_FLAG column of table STG_FIF_GL_DATA is used? Does it gets populated with any flag when data is exported to CFIN system?
  E.g. - When you run the process (BDI_RFI_FinGenLdgr_Tx_PF_From_RMS_JOB) to export the data to CFIN, the PROCESSED_FLAG column did not get updated with any value. How do you know in the system if the data is successfully exported to CFIN?
  
2. What is purging logic and name of the process/job that purges the data of STG_FIF_GL_DATA table?

3. How to re-export the data from STG_FIF_GL_DATA table when data is already populated in this table -
  (without re-exporting store_day_seq from the begining by saexpgl)?
  E.g. - If the data is exported but due to some reason it is missed to reach at the destination, can you re-export from this table at a later point of time? What is the process to do that?

4. As per Doc ID 2905046.1 - BDI_RFI_FinGenLdgr_Tx_PF_From_RMS_JOB exports DATE_CREATED=VDATE records from STG_FIF_GL_DATA table.
  Is there a way you can export the yesterday's DATE_CREATED(28 Oct) records (which were not exported), today (29 Oct) (current date/VDATE = 29 oct) to CFIN?

5. Can you check and tell if the job logic works to lookup the already exported data and to not reexport the duplicate data? OR It exports the same data again and merge it over the same data present in the FIF_GL_DATA_OUT table.

6. Also, how can you configure retention days of 14 of stg_fif_gl_purge_job? Is it present in any table or do you need to pass it as a parameter to the job?
(stg_fif_gl_purge_job URL: https://docs.oracle.com/en/industries/retail/retail-merchandising-foundation-cloud/latest/rmsoa/administration-batch.htm#index-18B9EC52)
 

Solution

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