Thanks but it did not work for me, tried all different possibility..we are on 12c.

Mayur, We are trying to achieve same thinng, can you please provide exact format of Catalog Path. Thanks Viresh

Actually, I am looking for more info on calling a stored proc created in Oracle DB from OBIEE physical layer Select The third link has that info but its specific to SQL Server, not oracle. Checking with experts if anybody implemented for Oracle DB…

Thanks, I have gone through these links before posting it in Oracle community. If anybody has successful in calling stored proc from OBIEE physical layer Select, please provide me the steps. SP is in Oracle DB

The OOTB Aging design in ODI is implemented such that monthly snapshot is stored based on current date. So, in my case if the invoices are created on Jan 7th with GL Date as 31st Dec then how to customize the OOTB logic so that it works on GL Date. Kindly share if you have any tech note on this implementation,