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

Checks to see that all SOBs have successfully transferred to consol.

Posted on January 27th, 2011 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

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

If your company is doing Consol and you have to see results across all SOB's for timely investigation and resolution during close, use this query .(11.5.10.2)

  1.  
  2.  
  3. <p>select sob.name from_sob,<br />
  4. sob1.name to_sob,<br />
  5. gc.name,<br />
  6. gc.description,<br />
  7. gc.from_currency_code,<br />
  8. gch.from_period_name,<br />
  9. gch.to_period_name,<br />
  10. gch.to_currency_code,<br />
  11. gch.STATUS,<br />
  12. gjb.name batch_name<br />
  13. FROM apps.gl_consolidation gc,<br />
  14. apps.gl_consolidation_history gch,<br />
  15. apps.gl_sets_of_books sob,<br />
  16. apps.gl_sets_of_books sob1,<br />
  17. apps.gl_je_batches gjb<br />
  18. WHERE gc.consolidation_id = gch.consolidation_id (+)<br />
  19. AND gc.from_set_of_books_id = sob.set_of_books_id<br />
  20. AND gc.to_set_of_books_id = sob1.set_of_books_id<br />
  21. AND gch.je_batch_id = gjb.je_batch_id (+)</p>
  22.  

Related Posts

Posted in Oracle General Ledger | No Comments »Email This Post Email This Post | Print This Post Print This Post

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

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