Need to RELOAD External File Interface Data
search cancel

Need to RELOAD External File Interface Data

book

Article ID: 38679

calendar_today

Updated On: 11-04-2024

Products

MICS Resource Management

Issue/Introduction

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

Release: 12.9   
Component: MICS-Resource Management-Accounting and Chargeback

Cause

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

Resolution

  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.