Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

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

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

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today

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

Related Posts

Posted in Oracle General Ledger | 2 Comments »Email This Post Email This Post |

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today
2 Responses
  1. Huey Min Says:

    Actually, how realistic is this statement : “They Imported and posted 11.42M journals per hour”.
    Is this workable also if budgetary control is turn on ? Dont think so. Current client facing problem in posting where when the batch containing > 200,000 lines, the posting stuck at fund reservation(glfxgb) and couldn’t complete. Metalink has not solve the issue even the SR on sev 1 for 1 month+. Anyone have idea on this ?

  2. goodhawk Says:

    as my experience, I import 1.2 million in 2 hours with the suggestion from Note:198437.1

Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.