Wednesday, July 6, 2016

How to Find the Table name on OAF Page

How to Find the Table name on OAF Page


Step 1) Set the profile option "FND: Diagnostics" at User Level to "Yes"

set FND : Diagnostics








Step 2) Navigate to respective OAF page and Click "About this Page" link at the bottom as shown in below screenshot

Click About this Page













Step 3) Navigate to Page > View Object and click on this. You can see the table name from there.














1 comment:

  1. This is really a fantastic post. Thank you for sharing!

    ReplyDelete

Oracle Fusion - Cost Lines and Expenditure Item link in Projects

SELECT   ccd.transaction_id,ex.expenditure_item_id,cacat.serial_number FROM fusion.CST_INV_TRANSACTIONS cit,   fusion.cst_cost_distribution_...