Oracle Cloud ERP – AR to GL Process Flow Techno Functional

Process Flow : Sales Order –> AR Invoice –> SubLedger –> General Ledger (Journal) Tables ra_customer_trx_allra_customer_trx_lines_allra_cust_trx_line_salesreps_allra_cust_trx_line_gl_dist_all →Read more

Oracle Cloud ERP Technical – BIP FAQ’s

OBIEE Oracle Business Intelligence Enterprise Edition BI Server: common enterprise business model and abstraction layer BI Answers: ad-hoc query and reporting BI Interactive Dashboards: highly interactive dashboards BI Delivers: proactive business activity monitoring and alerting BI Publisher: enterprise reporting and distribution of pixel-perfect reports BIP Business Intelligence Publisher Enterprise reporting and distribution of pixel-perfect reports […] →Read more

Oracle Cloud ERP(SaaS) Technical Interview Questions- Extensions (Configuring and Extending)

What are the changes can be done in Cloud ERP? Configuration Application Extension Personalization Are Configurations, Application Extensions , Personalizations Preserved during new release ? Yes, Configurations, application extensions, and Personalizations are preserved when you move on to a newer release update Tools in the Cloud SaaS for Configuring and Extending Page Composer: Configure application […] →Read more

Oracle Cloud ERP(SaaS) Technical Interview Questions- SOAP/REST API

SOAP Simple Object Access Protocol SOAP is a protocol which is used to interchange data between applications which are built on different programming languages. SOAP is built upon the XML specification and works with the HTTP protocol.  REST Representation State Transfer A REST API (also known as RESTful API) is an application programming interface (API or web API) that conforms to the constraints of REST architectural style and allows for […] →Read more

Oracle Cloud ERP(SaaS) Technical Interview Questions- FBDI

FBDI File-Based Data Import (FBDI) File Process of data import (Inbound) using FBDI Download the FBDI Template (Excel Enabled Macro File – XLSM) file Prepare Data File (CSV) gets generated from the template Load the file into UCM Load data into interface table Invoke Import job – which loads data from interface table to base […] →Read more

Oracle Cloud ERP(SaaS) Technical Interview Questions – Foundation

Foundation FAQ What is the frequency of Oracle Cloud ERP releases? Quarterly (4 Quarters in a year) – Current ERP release version is: 21B What is the patching frequency? Monthly What are the major application offerings from Oracle ERP Cloud? Financials Supply Chain Management Human Capital Management Project Portfolio Management High Level Technical Components in […] →Read more

Oracle Cloud ERP(SaaS) Technical Interview Questions

In this post, we will post questions and answers which we come across in interview for all levels for Oracle Cloud ERP (Fusion ERP) (SaaS) Technical. We keep updating this, as always we have new learnings in this Cloud Era. http://oratrainings.com/oracle-cloud-erpsaas-technical-interview-questions-foundation/ http://oratrainings.com/oracle-cloud-erpsaas-technical-interview-questions-fbdi/ http://oratrainings.com/oracle-cloud-erpsaas-technical-interview-questions-soap-rest-api/ http://oratrainings.com/oracle-cloud-erpsaas-technical-interview-questions-extensions/ →Read more

oracle.xdo.XDOException: java.sql.SQLDataException: ORA-01843: not a valid month in BI Publisher

Whenever we use TO_DATE in BIP Data Model (Consider the sample below query) – You will receive an exception. Solution : TO_DATE ( ’18-APR-2021′,’DD-MON-YYYY’ ,’NLS_DATE_LANGUAGE = American’) →Read more

Oracle Cloud ERP (Fusion Apps) Purchase Requisition FBDI Import

ESS Jobs : Load Interface File for ImportImport Requisitions Oracle Doc: https://docs.oracle.com/en/cloud/saas/procurement/21a/oefbp/self-service-procurement.html#importrequisitions-3193 FBDI zip file : https://drive.google.com/file/d/1zhuF0e7rP67KKd3PKH3FhBlyTaq1hoK9/view?usp=sharing →Read more

OAF Different VO Methods for Initiation, Row Operations, Dynamic Query

→Read more