Oracle Cloud ERP -Fusion (SaaS) – Profile Creation and Query to extract

Steps to Create – As an administrator, here’s how you can set the profile options: In the Setup and Maintenance work area, go to: Task: Manage Profile Options In the Manage Profile Options page, click the New icon in the Profile Options section. In the Create page, specify the details as listed in the table. Set Current date as […] →Read more

OAF XML Publisher – XDOException in R12.2.*

When integrating OAF with XML Publisher or Migration EBS R12.1.3 code to EBS R12.2.* – always there is a chance of XDOException class not found. Please refer to the below jar file for the purpose of : XDOException class – get the xdo10g.zip — library/jar file From Server to Local Machine →Read more

Oracle Cloud Fusion ERP – Purchase Order – PO Document Creation Methods

Query : select distinct DOCUMENT_CREATION_METHOD from po_headers_all DOCUMENT_CREATION_METHOD ENTER_PO CREATEDOC PDOI PO_WEB_SERVICE AUTOCREATE COPY_DOCUMENT PO_REST_SERVICE →Read more

Sales Order Tables and Other Master Data Tables Used in Sales Order – For Oracle Fusion ERP (Cloud ERP)- SaaS

→Read more

Oracle Cloud ERP – Fusion SaaS – POD Details

Query to get Fusion POD Details →Read more

How to setup user in Read Only Mode in Fusion using : FND_READ_ONLY_MODE

Manage Administrator Profile Values Save the Profile →Read more

Oracle Cloud ERP (Fusion SaaS) – Sales Order – Customer Details

Sales Order with Customer Org Detials →Read more

Oracle Cloud ERP (Fusion SaaS) – Sales Order Queries

Below are the main tables of Distributed Order Orchestration – DOO Sales Order Headers doo_headers_all Sales Order Lines doo_lines_all    Sales Order Fulfillment Lines doo_fulfill_lines_all    Sales Order Header EFF doo_headers_eff_b  Sales Order Line EFF doo_lines_eff_b Sales Order Header Address doo_order_addresses       Sales Order Hold Details doo_hold_instances       →Read more

Oracle Fusion SaaS – Query to get Security context details for a User

→Read more

Oracle Cloud ERP (SaaS) – Enabling DFF in Purchase Order Page – Header DFF

Modifying the DFF Attributes (Option1) Modifying the DFF Attributes (Option2) Query1 Query2 →Read more