RFI Sent Duplicate Sales To Fusion (Doc ID 3065392.1)

Last updated on JANUARY 03, 2025

Applies to:

Goal

RFI sends the duplicate sales information from the EXT_FIN_SYSTEM_FILES_CONTENT table to FUSION.

The process is as follows:

1. Searches for information that is pending to be sent every 10 minutes, Using the following query:

SELECT * FROM (SELECT SYSTEM, DATA_TYPE, FILE_ID, FILE_CONTENT, STATUS, CREATION_DATE, LAST_UPDATE_DATE, ERROR_MSG, FILE_TIMESTAMP
from EXT_FIN_SYSTEM_FILES_CONTENT WHERE EXT_FIN_SYSTEM_FILES_CONTENT.SYSTEM = ?
AND ( EXT_FIN_SYSTEM_FILES_CONTENT.DATA_TYPE = ? ) AND EXT_FIN_SYSTEM_FILES_CONTENT.STATUS = ?
ORDER BY EXT_FIN_SYSTEM_FILES_CONTENT.FILE_TIMESTAMP, EXT_FIN_SYSTEM_FILES_CONTENT.FILE_ID) WHERE ROWNUM < 2[CFIN][RMS_ACCOUNT_ENTRY][N]

2. Put the CLOB information into a CSV

3. ZIP the information from the CSV to a file RMS_ACCOUNT_ENTRY.zip

4. Call WERSERVICE and send the file

5. Marks the record in RFI EXT_FIN_SYSTEM_FILES_CONTENT as processed and updates the LAST_UPDATE_DATE date.

UPDATE EXT_FIN_SYSTEM_FILES_CONTENT
  SET STATUS = ?,
  LAST_UPDATE_DATE = sysdate,
  ERROR_MSG = ?
 WHERE EXT_FIN_SYSTEM_FILES_CONTENT.FILE_ID IN (?)[S][NULL][80653]

When the process takes more than 10 minutes without finishing, another execution starts and as the record of the first execution is still 'N' (because the execution only changes the status to 'S' at the end) the next execution will process the same record.
This means that when the process takes more than 10 minutes to run, it sends the same duplicate file.

Is there supposed to be another run while the first one hasn't finished?
In this case, shouldn't there be an intermediate status to ensure that more than one run doesn't process the same record?

Is it possible to increase the process frequency time so that instead of every 10 minutes, it's every 1 hour, for example?
 

Solution

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