Oracle Cloud ERP -Fusion (SaaS) – Profile Creation and Query to extract
by admin
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.*
by admin
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
by admin
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
Oracle Cloud ERP (Fusion SaaS) – Sales Order Queries
by admin
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