Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Large volume file processing OIC

Summary:

OIC Integration takes very long time to process (> 8 hours for 50k records in the input source file). Looking forward for suggestions or corrections to improvise the performance. Here is the flow of the process:

  1. Scheduled Orchestration - Download file from SFTP and kick off another integration for each file (Expected multiple input files per pay period)
  2. App Driven Orchestration - Received input from #1 above. Flow as follows:
    1. Receive the input file reference and write to Stage
    2. Read 3 reports and store it in local variable as single call (Assignment number, Element mapping from UDT, Costing information for costing report)
    3. Read file in segments - Loop each record

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!