Query to fetch the value set details such as Value Set Name, Value, Description and associated tables in Oracle.
Blog
DOO_FULFILL_LINES_ALL: Columns, Indexes & Imp Points
doo_fulfill_lines_all: column, index and constraint details : the table which holds the fulfilment details of Sales Order Line
Work Order Details Query in Oracle Fusion
Query to fetch the work order details such as WO Number, Completion Date, WO Type, Subtype, Status, Planned Start Date, Actual Start Date etc
Journal Reconciliation Query in Oracle Fusion
Query to reconcile the journals in Oracle Fusion to match the books against certain GL accounts.
OTBI vs BI Reporting in Oracle Fusion
OTBI Vs BI Report in Oracle Fusion: Difference between the two and how to decide which one to choose for development.