How to design XSL Stylesheet& XSL-FO Template in Oracle Fusion BI Publisher
by admin
Data Model –Query XSL Stylesheet XSL-FO •XML-based markup language for formatting XML data. •XSL FO Supports many formats : XSLFO, Excel, PDF, RTF etc RTF, XSL, XSL-FO Template Formats →Read more
LISTAGG – Display rows in Columns in CSV Format – Oracle Database
by admin
•As a single-set aggregate function, LISTAGG operates on all rows and returns a single output row. •As a group-set aggregate, the function operates on and returns an output row for each group defined by the GROUP BY clause. •As an analytic function, LISTAGG partitions the query result set into groups based on one or more […] →Read more
Identify table details of Custom Object In – Application Composer – Oracle Fusion
by admin
•Using : adf_extensible_table Table Approach * SNO Table Detail Column Description 1 ADF_EXTENSIBLE_TABLE_USAGE ENTITYDEF_FULLNAME Custom Object Name 2 ADF_EXTENSIBLE_TABLE TABLE_ID Join with TABLE_ID of Table Mentioned in SNO 1 3 ADF_EXTENSION_COLUMN_USAGE TABLE_USAGE_ID Join with TABLE_USAGE_ID of Table Mentioned in SNO 2 4 ADF_EXTENSION_COLUMN COLUMN_ID Join with COLUMN_ID of Table Mentioned in SNO 3 →Read more
Submit Concurrent Program (XML Report) Using PLSQL in Oracle E-Business Suite