- OracleApps Epicenter - http://www.oracleappshub.com -

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

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.