Need to RELOAD External File Interface Data

Document ID : KB000038679
Last Modified Date : 14/02/2018
Show Technical Document Details

Problem: 

External File Interface data has been loaded. Debits and credits have been posted. CLOSETBL and FINRECAP jobs have been executed. Is there a way to correct the data from the External File Interface (EFI) update without restoring and rerunning the entire process?

 

Environment:  

All supported maintenance levels of CA MICS.

Cause: 

The problem occurred because the input file for the External File Interface job was invalid.

Resolution/Workaround:

1. Create a SAS job to read the TABLES.ACTSDT01 file and delete records that contain the comp code (SDTCPC) for the External File Interface data.

2. Submit sharedprefix.CNTL(ACTADJLD) to load the corrected data into sp.MICS.ISPTLIB.  Specify 01 for the cycle.

3. Submit the External File Interface job with the corrected data and set the CYCLE=nn to 01 on the SYSPARM statement in the JCL.

4. Submit sharedprefix.CNTL(FINRECAP).

Additional Information:

 

A backup of sharedprefix.MICS.ISPTLIB and sharedprefix.MICS.TABLES is recommended before starting the process.  Contact CA MICS Support if you have any questions on the above procedure or whether your situation matches this problem.