What is the maximum number of lines in a GL journal?

Posted on January 11th, 2008 by Sanjit Anand | Print This Post | Email This Post

It was one of the requirements of my current client, who has replaced SAP to Oracle.In migration there are journals from SAP systems are over 45,000+ lines long, so client are bit concern . I took lot of research over internet and metalink,and refer Oracle benchmark data sheet, it was no help, but still manage those activity.Finally , thought to share...

What we can assume we have to reach the maximum as the journal line ID allows 15 characters so 999,999,999,999,999 is theoretical maximum .

UBS have benchmarked the GL system and upload over 1 million lines per hour.

There is a case mention in document , and a benchmark test was conducted to validate overall performance.

• Data Load: Import and post at least 10M postings in less than 1 hour
• Month End: Perform a "period open" in less than 12 hours (transfer 500M balances into the next month)
• Daily Extract: Extract 500M balances in less than 60 minutes and calculate the daily balance sheet of the bank by cost center in less than 30 minutes

And these are the outcome of benchmark set of the EBS tool

• They Imported and posted 11.42M journals per hour
• Period Open on 500M balances in 11 hours and 8 minutes
• Extracted 500M balances (including the merge of 26 dimension values) in 48 minutes
• Generated the daily balance sheet on the base of 500M balances in 23 minutes

Sound great ! what you say.

Suggested Reading

• Oracle Applications Standard Benchmark
• Oracle Applications Standard Benchmark White Papers
  

1. Order Management – Split Lines