Query to fetch the price, price list and charges of an item and the tables behind it in Oracle Fusion. Also the usage of various tables.
Tag: Oracle Fusion Training
RTF Date Formatting With Example
How to insert the date in various formats in RTF template for XML or BI Publisher Report along with Syntax and Corresponding output.
Custom PL- SQL Function Invocation in a Fusion Report
How to call a custom PL- SQL function in a BI Report in Oracle Fusion
POR_REQUISITION_HEADERS_ALL: Columns & Indexes
POR_REQUISITION_HEADERS_ALL: Column Details, index and constraints.
POR_REQUISITION_LINES_ALL: Columns & Index
POR_REQUISITION_LINES_ALL Holds the Requisition line details. This post talks about Table structure, index and constraint details.