Oracle Fusion – How to create procurement agent and SQL Query to get the details
by admin
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 = […] →Read more
Oracle Cloud ERP – Replace BI Publisher Dynamic SQL with Explicit SQL PRIOR to Update 20D for Oracle Cloud
by admin
In Fusion Applications Update 20D, BI Publisher data models will NO longer support dynamic SQL as a parameter value in a procedure call. This desupport WILL NOT affect existing BI Publisher data models that use explicit SQL statements in procedure calls or user-defined report filter parameters. Action Required Replace SQL procedures containing dynamic SQL query […] →Read more
PBL – Payroll Batch Loader HDL – HCM Data Loader SDL – Spreadsheet loader ADFDi – ADF Desktop Integration FBDI – File Based Data Import FBL – File Based Loader →Read more
Oracle Cloud ERP – Standard Reports and Analysis
by admin
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 →Read more
TO_CHAR and TO_DATE in Oracle BI Publisher
by admin
TO_CHAR and TO_DATE does not function properly in BI Publisher without using NLS_DATE parameter, check the sample snippet. →Read more
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 →Read more
OAF Migration For R12.1.* and R12.2.*
by admin
OAF Migration Approach For R12.1.3 1 – Place the class files in JAVA_TOP at appropriate folder. 2 – Run oracle.jrad.tools.xml.importer.XMLImporter for the required XML files. Bounce Apache cd $ADMIN_SCRIPTS_HOME adapcctl.sh stop adapcctl.sh start OAF Migration Approach For R12.2.* Steps : 1 – Place the class files in JAVA_TOP at appropriate folder. 2 – Run oracle.jrad.tools.xml.importer.XMLImporter […] →Read more