Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

EDMCS TO Oracle fusion

Rejo ChackoJul 6 2026

####[2026-07-06T09:17:03.089+00:00] [INFO] Load ERP Interface Import Job Request ID: 575114
Load ERP Interface Import Job Output Work Directory:/u01/APPLTOP/instance/ess/rfd/575114/out
------------------------------------------
------------------------------------------
Checking if Maintenance job is scheduled
Maintenance job is already scheduled
File Successfully Transferred from UCM
Submitted Sub Request For: /oracle/apps/ess/financials/commonModules/shared/common/interfaceLoader;InterfaceLoaderAsyncJob with request ID: 575117

------ Waiting on Child Process with request ID: 575117-------

Initiated Asynchronous Job to transfer file.

####[2026-07-06T09:17:07.606+00:00] [INFO] Load ERP Interface Import Job Request ID: 575114
Load ERP Interface Import Job Output Work Directory:/u01/APPLTOP/instance/ess/rfd/575114/out
------------------------------------------
Request Resumed after child process completion (File Transfer Job) at: Mon Jul 06 09:17:07 UTC 2026
------------------------------------------
------------------------------------------
Reading properties from Scheduler environment properties file.
Reading environment properties file: /u01/APPLTOP/instance/ess/config/environment.properties
------------------------------------------
------------------------------------------
Processing Data File: GlSegmentHierInterface.csv
------------------------------------------
Processing Data File: GlSegmentHierInterface.csv
**********Data file name :::GlSegmentHierInterface.csv
Identified Control File: GlSegmentHierInterface.ctl
Identified Product Top: GL_TOP
Copying Control File: GlSegmentHierInterface.ctl from:/u01/APPLTOP/fusionapps/applications/fin/gl/bin
Replacing occurrences of request identifier with: 575114
Writing Control File: GlSegmentHierInterface.ctl to: /u01/APPLTOP/instance/ess/rfd/575114
Submitting loader job to process flat file to interface tables.
Submitted Sub Request For: /oracle/apps/ess/financials/commonModules/shared/common/interfaceLoader;InterfaceLoaderSqlldrImport with request ID: 575133

------ Waiting on Child Process with request ID: 575133-------

------------------------------------------
Processing Data File: GlSegmentValuesInterface.csv
**********Data file name :::GlSegmentValuesInterface.csv
Identified Control File: GlSegmentValuesInterface.ctl
Identified Product Top: GL_TOP
Copying Control File: GlSegmentValuesInterface.ctl from:/u01/APPLTOP/fusionapps/applications/fin/gl/bin
Replacing occurrences of request identifier with: 575114
Writing Control File: GlSegmentValuesInterface.ctl to: /u01/APPLTOP/instance/ess/rfd/575114
Submitting loader job to process flat file to interface tables.
Submitted Sub Request For: /oracle/apps/ess/financials/commonModules/shared/common/interfaceLoader;InterfaceLoaderSqlldrImport with request ID: 575134

------ Waiting on Child Process with request ID: 575134-------

####[2026-07-06T09:17:13.535+00:00] [INFO] Load ERP Interface Import Job Request ID: 575114
Load ERP Interface Import Job Output Work Directory:/u01/APPLTOP/instance/ess/rfd/575114/out
------------------------------------------
File Stamped as Processed
Note: If the Load Interface File for Import process is executed using the Import Bulk Data with Purge Option of the ERP Integration Service (i.e. the Web Service Operation = importBulkData), then the data that will be purged from the product interface and error tables will first be extracted and uploaded to the particular Universal Content Management (UCM) server account for the individual product import process that is used.
If you need to reference the purged interface and error data, then you will need to access the UCM File with the following naming convention: ImportBulkData__.zip
Original POST LOAD JOB NAME :- /oracle/apps/ess/financials/generalLedger/programs/masterData;ProcessInterfaceData
TOKENIZED POST LOAD JOB NAME :- /oracle/apps/ess/financials/generalLedger/programs/masterData;ProcessInterfaceData
Submitting post load job /oracle/apps/ess/financials/generalLedger/programs/masterData;ProcessInterfaceData
Could not retrieve metadata for jobDef: /oracle/apps/ess/financials/generalLedger/programs/masterData;ProcessInterfaceData
Error in obtaining metadata handleERROR
Error while submitting subrequest for request 575114
InterfcaeLoaderController : System Error occured while submitting post load job . Error Occured - Error while submitting subrequest for request 575114

####[2026-07-06T09:25:04.491+00:00] [INFO] Load ERP Interface Import Job Request ID: 575114
Load ERP Interface Import Job Output Work Directory:/u01/APPLTOP/instance/ess/rfd/575114/out
------------------------------------------
ESS Resiliency: FBDI Job current execution is due to resiliency with retryCount = 1
ESS Resiliency: Post load job is registered: /oracle/apps/ess/financials/generalLedger/programs/masterData/ProcessInterfaceData
ESS Resiliency: Post Load job was not executed in the previous FBDI Job execution
ESS Resiliency: Interface tables clean is needed
ESS Resiliency: Performing a clean up on Interface tables
Building Delete Statetements to execute...
------------------------------
InterfaceTableNames= GL_SEGMENT_VALUES_INTERFACE
DeleteOnLoadFailure= Y
------------------------------
Adding Statement : DELETE FROM GL_SEGMENT_VALUES_INTERFACE WHERE LOAD_REQUEST_ID=575114
------------------------------
InterfaceTableNames= GL_SEGMENT_HIER_INTERFACE
DeleteOnLoadFailure= Y
------------------------------
Adding Statement : DELETE FROM GL_SEGMENT_HIER_INTERFACE WHERE LOAD_REQUEST_ID=575114
--------------Number of records deleted from GL_SEGMENT_VALUES_INTERFACE is - 126
--------------Number of records deleted from GL_SEGMENT_HIER_INTERFACE is - 126
Deletion Done.
DB cleanup performed successfully
------------------------------------------
Checking if Maintenance job is scheduled
Maintenance job is already scheduled
File Successfully Transferred from UCM
Submitted Sub Request For: /oracle/apps/ess/financials/commonModules/shared/common/interfaceLoader;InterfaceLoaderAsyncJob with request ID: 575171

------ Waiting on Child Process with request ID: 575171-------

Initiated Asynchronous Job to transfer file.

####[2026-07-06T09:25:08.640+00:00] [INFO] Load ERP Interface Import Job Request ID: 575114
Load ERP Interface Import Job Output Work Directory:/u01/APPLTOP/instance/ess/rfd/575114/out
------------------------------------------
Request Resumed after child process completion (File Transfer Job) at: Mon Jul 06 09:25:07 UTC 2026
------------------------------------------
------------------------------------------
Reading properties from Scheduler environment properties file.
Reading environment properties file: /u01/APPLTOP/instance/ess/config/environment.properties
------------------------------------------
------------------------------------------
Processing Data File: GlSegmentHierInterface.csv
------------------------------------------
Processing Data File: GlSegmentHierInterface.csv
**********Data file name :::GlSegmentHierInterface.csv
Identified Control File: GlSegmentHierInterface.ctl
Identified Product Top: GL_TOP
Copying Control File: GlSegmentHierInterface.ctl from:/u01/APPLTOP/fusionapps/applications/fin/gl/bin
Replacing occurrences of request identifier with: 575114
Writing Control File: GlSegmentHierInterface.ctl to: /u01/APPLTOP/instance/ess/rfd/575114
Submitting loader job to process flat file to interface tables.
Submitted Sub Request For: /oracle/apps/ess/financials/commonModules/shared/common/interfaceLoader;InterfaceLoaderSqlldrImport with request ID: 575175

------ Waiting on Child Process with request ID: 575175-------

------ Waiting on Child Process with request ID: 575176-------

####[2026-07-06T09:25:14.710+00:00] [INFO] Load ERP Interface Import Job Request ID: 575114
Load ERP Interface Import Job Output Work Directory:/u01/APPLTOP/instance/ess/rfd/575114/out
------------------------------------------
File Stamped as Processed
Note: If the Load Interface File for Import process is executed using the Import Bulk Data with Purge Option of the ERP Integration Service (i.e. the Web Service Operation = importBulkData), then the data that will be purged from the product interface and error tables will first be extracted and uploaded to the particular Universal Content Management (UCM) server account for the individual product import process that is used.
If you need to reference the purged interface and error data, then you will need to access the UCM File with the following naming convention: ImportBulkData__.zip
Original POST LOAD JOB NAME :- /oracle/apps/ess/financials/generalLedger/programs/masterData;ProcessInterfaceData
TOKENIZED POST LOAD JOB NAME :- /oracle/apps/ess/financials/generalLedger/programs/masterData;ProcessInterfaceData
Submitting post load job /oracle/apps/ess/financials/generalLedger/programs/masterData;ProcessInterfaceData
Could not retrieve metadata for jobDef: /oracle/apps/ess/financials/generalLedger/programs/masterData;ProcessInterfaceData
Error in obtaining metadata handleERROR
Error while submitting subrequest for request 575114
InterfcaeLoaderController : System Error occured while submitting post load job . Error Occured - Error while submitting subrequest for request 575114

####[2026-07-06T09:35:20.448+00:00] [INFO] Load ERP Interface Import Job Request ID: 575114
Load ERP Interface Import Job Output Work Directory:/u01/APPLTOP/instance/ess/rfd/575114/out
------------------------------------------
ESS Resiliency: FBDI Job current execution is due to resiliency with retryCount = 2
ESS Resiliency: Post load job is registered: /oracle/apps/ess/financials/generalLedger/programs/masterData/ProcessInterfaceData
ESS Resiliency: Post Load job was not executed in the previous FBDI Job execution
ESS Resiliency: Interface tables clean is needed
ESS Resiliency: Performing a clean up on Interface tables
Building Delete Statetements to execute...
------------------------------
InterfaceTableNames= GL_SEGMENT_VALUES_INTERFACE
DeleteOnLoadFailure= Y
------------------------------
Adding Statement : DELETE FROM GL_SEGMENT_VALUES_INTERFACE WHERE LOAD_REQUEST_ID=575114
------------------------------
InterfaceTableNames= GL_SEGMENT_HIER_INTERFACE
DeleteOnLoadFailure= Y
------------------------------
Adding Statement : DELETE FROM GL_SEGMENT_HIER_INTERFACE WHERE LOAD_REQUEST_ID=575114
--------------Number of records deleted from GL_SEGMENT_VALUES_INTERFACE is - 126
--------------Number of records deleted from GL_SEGMENT_HIER_INTERFACE is - 126
Deletion Done.
DB cleanup performed successfully
------------------------------------------
Checking if Maintenance job is scheduled
Maintenance job is already scheduled
File Successfully Transferred from UCM
Submitted Sub Request For: /oracle/apps/ess/financials/commonModules/shared/common/interfaceLoader;InterfaceLoaderAsyncJob with request ID: 575253

------ Waiting on Child Process with request ID: 575253-------

Initiated Asynchronous Job to transfer file.

####[2026-07-06T09:35:24.142+00:00] [INFO] Load ERP Interface Import Job Request ID: 575114
Load ERP Interface Import Job Output Work Directory:/u01/APPLTOP/instance/ess/rfd/575114/out
------------------------------------------
Request Resumed after child process completion (File Transfer Job) at: Mon Jul 06 09:35:23 UTC 2026
------------------------------------------
------------------------------------------
Reading properties from Scheduler environment properties file.
Reading environment properties file: /u01/APPLTOP/instance/ess/config/environment.properties
------------------------------------------
------------------------------------------
Processing Data File: GlSegmentHierInterface.csv
------------------------------------------
Processing Data File: GlSegmentHierInterface.csv
**********Data file name :::GlSegmentHierInterface.csv
Identified Control File: GlSegmentHierInterface.ctl
Identified Product Top: GL_TOP
Copying Control File: GlSegmentHierInterface.ctl from:/u01/APPLTOP/fusionapps/applications/fin/gl/bin
Replacing occurrences of request identifier with: 575114
Writing Control File: GlSegmentHierInterface.ctl to: /u01/APPLTOP/instance/ess/rfd/575114
Submitting loader job to process flat file to interface tables.
Submitted Sub Request For: /oracle/apps/ess/financials/commonModules/shared/common/interfaceLoader;InterfaceLoaderSqlldrImport with request ID: 575254

------ Waiting on Child Process with request ID: 575254-------

------ Waiting on Child Process with request ID: 575255-------

####[2026-07-06T09:35:30.076+00:00] [INFO] Load ERP Interface Import Job Request ID: 575114
Load ERP Interface Import Job Output Work Directory:/u01/APPLTOP/instance/ess/rfd/575114/out
------------------------------------------
File Stamped as Processed
Note: If the Load Interface File for Import process is executed using the Import Bulk Data with Purge Option of the ERP Integration Service (i.e. the Web Service Operation = importBulkData), then the data that will be purged from the product interface and error tables will first be extracted and uploaded to the particular Universal Content Management (UCM) server account for the individual product import process that is used.
If you need to reference the purged interface and error data, then you will need to access the UCM File with the following naming convention: ImportBulkData__.zip
Original POST LOAD JOB NAME :- /oracle/apps/ess/financials/generalLedger/programs/masterData;ProcessInterfaceData
TOKENIZED POST LOAD JOB NAME :- /oracle/apps/ess/financials/generalLedger/programs/masterData;ProcessInterfaceData
Submitting post load job /oracle/apps/ess/financials/generalLedger/programs/masterData;ProcessInterfaceData
Could not retrieve metadata for jobDef: /oracle/apps/ess/financials/generalLedger/programs/masterData;ProcessInterfaceData
Error in obtaining metadata handleERROR
Error while submitting subrequest for request 575114
InterfcaeLoaderController : System Error occured while submitting post load job . Error Occured - Error while submitting subrequest for request 575114

####[2026-07-06T09:55:36.836+00:00] [INFO] Load ERP Interface Import Job Request ID: 575114
Load ERP Interface Import Job Output Work Directory:/u01/APPLTOP/instance/ess/rfd/575114/out
------------------------------------------
ESS Resiliency: FBDI Job current execution is due to resiliency with retryCount = 3
ESS Resiliency: Post load job is registered: /oracle/apps/ess/financials/generalLedger/programs/masterData/ProcessInterfaceData
ESS Resiliency: Post Load job was not executed in the previous FBDI Job execution
ESS Resiliency: Interface tables clean is needed
ESS Resiliency: Performing a clean up on Interface tables
Building Delete Statetements to execute...
------------------------------
InterfaceTableNames= GL_SEGMENT_VALUES_INTERFACE
DeleteOnLoadFailure= Y
------------------------------
Adding Statement : DELETE FROM GL_SEGMENT_VALUES_INTERFACE WHERE LOAD_REQUEST_ID=575114
------------------------------
InterfaceTableNames= GL_SEGMENT_HIER_INTERFACE
DeleteOnLoadFailure= Y
------------------------------
Adding Statement : DELETE FROM GL_SEGMENT_HIER_INTERFACE WHERE LOAD_REQUEST_ID=575114
--------------Number of records deleted from GL_SEGMENT_VALUES_INTERFACE is - 126
--------------Number of records deleted from GL_SEGMENT_HIER_INTERFACE is - 126
Deletion Done.
DB cleanup performed successfully
------------------------------------------
Checking if Maintenance job is scheduled
Maintenance job is already scheduled
File Successfully Transferred from UCM
Submitted Sub Request For: /oracle/apps/ess/financials/commonModules/shared/common/interfaceLoader;InterfaceLoaderAsyncJob with request ID: 575387

------ Waiting on Child Process with request ID: 575387-------

Initiated Asynchronous Job to transfer file.

####[2026-07-06T09:55:43.427+00:00] [INFO] Load ERP Interface Import Job Request ID: 575114
Load ERP Interface Import Job Output Work Directory:/u01/APPLTOP/instance/ess/rfd/575114/out
------------------------------------------
Request Resumed after child process completion (File Transfer Job) at: Mon Jul 06 09:55:42 UTC 2026
------------------------------------------
------------------------------------------
Reading properties from Scheduler environment properties file.
Reading environment properties file: /u01/APPLTOP/instance/ess/config/environment.properties
------------------------------------------
------------------------------------------
Processing Data File: GlSegmentHierInterface.csv
------------------------------------------
Processing Data File: GlSegmentHierInterface.csv
**********Data file name :::GlSegmentHierInterface.csv
Identified Control File: GlSegmentHierInterface.ctl
Identified Product Top: GL_TOP
Copying Control File: GlSegmentHierInterface.ctl from:/u01/APPLTOP/fusionapps/applications/fin/gl/bin
Replacing occurrences of request identifier with: 575114
Writing Control File: GlSegmentHierInterface.ctl to: /u01/APPLTOP/instance/ess/rfd/575114
Submitting loader job to process flat file to interface tables.
Submitted Sub Request For: /oracle/apps/ess/financials/commonModules/shared/common/interfaceLoader;InterfaceLoaderSqlldrImport with request ID: 575388

------ Waiting on Child Process with request ID: 575388-------

------ Waiting on Child Process with request ID: 575389-------

####[2026-07-06T09:55:49.835+00:00] [INFO] Load ERP Interface Import Job Request ID: 575114
Load ERP Interface Import Job Output Work Directory:/u01/APPLTOP/instance/ess/rfd/575114/out
------------------------------------------
File Stamped as Processed
Note: If the Load Interface File for Import process is executed using the Import Bulk Data with Purge Option of the ERP Integration Service (i.e. the Web Service Operation = importBulkData), then the data that will be purged from the product interface and error tables will first be extracted and uploaded to the particular Universal Content Management (UCM) server account for the individual product import process that is used.
If you need to reference the purged interface and error data, then you will need to access the UCM File with the following naming convention: ImportBulkData__.zip
Original POST LOAD JOB NAME :- /oracle/apps/ess/financials/generalLedger/programs/masterData;ProcessInterfaceData
TOKENIZED POST LOAD JOB NAME :- /oracle/apps/ess/financials/generalLedger/programs/masterData;ProcessInterfaceData
Submitting post load job /oracle/apps/ess/financials/generalLedger/programs/masterData;ProcessInterfaceData
Could not retrieve metadata for jobDef: /oracle/apps/ess/financials/generalLedger/programs/masterData;ProcessInterfaceData
Error in obtaining metadata handleERROR
Error while submitting subrequest for request 575114
InterfcaeLoaderController : System Error occured while submitting post load job . Error Occured - Error while submitting subrequest for request 575114

all the child process are succeeded but parent fails

Added on Jul 6 2026

0 comments

23 views