General Ledger - EBS (MOSC)

MOSC Banner

Best integration approach for importing volume GL enteries from another ERP system

edited Dec 6, 2017 4:02AM in General Ledger - EBS (MOSC) 1 commentAnswered

We are building an integration to bring into Oracle E-Business volume GL interface enteries from another ERP system. The issue is designing with performance utilizing best approach and standards that work best with both 12.1 and 12.2.

It is known that using SQL*LOADER direct load and building internal validation before moving the data into the GL interface table(s) could be the fastest approach, however, using a middleware tool to transform and validate the data and pass it as web service enteries directly into the EBS GL Interface is tempting for better management. Is there a recommended approach for integration when volume GL enteries? Also, do you recommend using multipl interface tables? how about grouping the enteries into batches?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center