Generative AI – Uses Cases In Oracle Fusion ERP
ERP Module Use Case Description Financials Invoice Processing Auto-extracts and classifies invoice data from files/emails. Narrative Reporting Generates insights for financial reports (e.g., variance analysis). Journal Entry Suggestions Recommends recurring/corrective journal entries using historical data. Procurement Smart Supplier Recommendations Suggests best-fit suppliers using AI algorithms. Contract Drafting Drafts contract templates/clauses using procurement details. RFQ/Email Response […] →Read more
OAF – Profile Values to Personalize Page – To Enable Personalize Page Link
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
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
•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
Blanket Purchase Agreement (BPA) – Approval – Configuration-Validation-BPM- Oracle Fusion ERP
Requisition Approval Workfow – Customization – Status History- Table Details – Oracle Fusion ERP
Purchase Order Approval – Oracle Fusion ERP
Identify table details of Custom Object In – Application Composer – Oracle Fusion
•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