Archive


Category: OracleSaaS

  • Oracle Fusion – How to create procurement agent and SQL Query to get the details

    N : Setup and Maintenance — Search for Task — Manage Procurement Agents —————————————————– SQL Query to get the procurement agent details —————————————————– SELECT ppf.display_name, pu.username, hou.name BU_NAME, paa.access_action_code, paa.active_flag, paa.access_others_level_code FROM po_agent_accesses paa, per_person_names_f_v ppf, per_users pu, hr_organization_units hou WHERE 1 = 1 AND paa.agent_id = ppf.person_id AND pu.person_id = ppf.person_id AND hou.organization_id = […]

  • Oracle Cloud ERP – Standard Reports and Analysis

    FIN: https://docs.oracle.com/en/cloud/saas/financials/20b/analyze-and-report.html SCM: https://docs.oracle.com/en/cloud/saas/procurement/20b/analyze-and-report.html HCM: https://docs.oracle.com/en/cloud/saas/human-resources/20b/analyze-and-report.html Click on : Analyze and Report –> Check the details in : Review Prebuilt Analytics and Reports

  • Oracle Fusion Roles

    Below are the basic roles required to have all the access to configure the instance Application Administrator Application Developer Application Implementation Administrator Application Implementation Consultant Application Implementation Manager IT Security Manager

  • Oracle Fusion BI Publisher – SFTP and PGP Configuration

    Fusion Applications BI Publisher : How to request configuration of Public/Private key encryption for delivery from BI Publisher to external FTP Servers ( Doc ID 1987283.1 ) GOAL  This document details how to setup the Public/Private key encryption for an external (to the Oracle Cloud) FTP Server in a Fusion Applications BI Publisher installation. SOLUTION […]

  • Oracle Fusion FBDI for Item Import

    URL : https://docs.oracle.com/en/cloud/saas/supply-chain-and-manufacturing/19d/oefsc/product-master-data-management.html#product-master-data-management Item FBDI template has 13 sheets, but we will enter details for the below  mentioned sheet, to just populate highlevel item details ESS Job to load zip file into Interface Tables Select the zip file, which got generated from FBDI template Click Submit, which generates the request id Import Process To Load […]