Category: OracleSaaS
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 […]
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 […]
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 […]
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 […]
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 […]
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/
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’)
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
Following are the 3 text files designed: manifest.txt messages.txt messagetokens.txt Zip the 3 files : manifest.txt , messages.txt, messagetokens.txt and name it as : DataLoader7.zip Upload the file to UCM account : fin/payables/import Invoke the POST method of REST API : https://ucf5-zvcz-fa-ext.oracledemos.com/fscmRestApi/resources/11.13.18.05/erpintegrations Oracle Documentation : Docs : https://docs.oracle.com/en/cloud/saas/financials/21a/farfa/op-erpintegrations-post.html