Oracle Cloud ERP – AR to GL Process Flow Techno Functional
by admin
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
by admin
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)
by admin
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
by admin
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
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
by admin
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
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
by admin
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
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