Procurement - EBS (MOSC)

MOSC Banner

How to reduce the average time for X records for PO Import Program

edited Jul 18, 2014 5:00AM in Procurement - EBS (MOSC) 4 commentsAnswered

Hi All

We are building a new interface for inbound Purchase Orders with Oracle EBS R12. We are using standard interface route for the data load from a staging table. We are using atleast 7 DFF in header table and 12+ DFF in line tables. Currently, for 20K PO Headers and corresponding 240K PO lines, it is taking 15+ hours for the standard import program.

Our data volume on a daily basis is quite high as we are a big manufacturing company. Is the above timing is average or there is a benchmark timing available for X number of records processed through standard PO import program? How can we reduce the import program processing timing? Any pointers will be appreciated.

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