OAF – Profile Values to Personalize Page – To Enable Personalize Page Link
by admin
These four profile options can be enabled while working on OAF personalization in apps. To Assign these Profile Options, we need to go to System Administrator or Functional Administrator Responsibility. Navigation: System Administrator -> Profile -> System Functional Administrator -> Core Services -> Profiles Profile Name Profile Value FND: Diagnostics Yes Personalize Self-Service Defn Yes FND: Personalization Region Link […] →Read more
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