Popular Posts

Monday, April 5, 2021

Query to find the Operating Unit Name for the Journal Ledger created in Oracle Apps General Ledger



 Below is the query which gives details about legal entity name, ledger name and operating unit name 


SELECT * FROM XLE_LE_OU_LEDGER_V where ledger_id in (select ledger_id from gl_je_headers where name ='Journal Name' and description like 'Journal%Import%230808858%')

No comments:

 How to direct the outputfile of the concurrent request to unix server path using XMLP Bursting  ORACLE APPS. Step 1: In the DATA XML defini...