Query to Extract Oracle Payments Formatted Xml file from Oracle Cloud ERP Database
The below query can help extract the Oracle Payments xml file which is processed by Oracle cloud ERP Payments module. This query extracts the formatted xml which is sent to the bank. This can greatly help in Debugging Payment issues: SELECT * FROM iby_trxn_documents itd WHERE itd.payment_instruction_id IN (SELECT payment_instruction_id […]
Read MoreQuery to Extract Oracle Payments Source Xml file from Oracle Cloud ERP Database
The below query can help extract the Oracle Payments xml file which is processed by Oracle cloud ERP Payments module. This query extracts the source xml. This can greatly help in Debugging Payment issues: SELECT * FROM iby_trxn_documents itd WHERE itd.payment_instruction_id IN (SELECT payment_instruction_id […]
Read MoreQuery to extract Basic Invoice details from Oracle ERP Cloud
This Query helps extract invoice data from Oracle cloud ERP. This query can be pasted in Oracle BI catalog Data model. SELECT aia.source INVOICE_SOURCE, xep.name […]
Read MoreQuery to find Basic Supplier Details in Oracle Fusion Cloud
This Oracle query can be used to extract the details of all the Supplier data including Supplier Address and Supplier Sites in Oracle ERP Cloud. This can be pasted directly to the Oracle cloud BI catalog Data Model. Have added sample commented filters that can be enabled to narrow down the search for the relavent suppliers. […]
Read MoreQuery to get the Business unit and Legal Entity in Oracle Cloud ERP
This query Gets all the active Business units and associated Legal entities in Oracle Cloud ERP. The query is shared below: SELECT ffbuv.bu_name BU_NAME ,xep.name LEGAL_ENTITY_NAME FROM fun_fin_business_units_v ffbuv ,xle_entity_profiles xep WHERE ffbuv.legal_entity_id=xep.legal_entity_id The Query can be directly pasted in Oracle cloud Report Data model to get the output.
Read MoreCreating xsl Payment File formats for sending Payments in xml ISO20022 format to Bank servers in Oracle Cloud ERP
ISO20022 is Open standard for Financial messaging and is now widely used across enterprises to communicate to Financial institutions like banks. The most common usage of ISO20022 is to send payment instructions in xml format to the Bank server. Banks can then process these payments quickly and easily considering the common structure and formatting. Though, […]
Read MoreHow to create Employee from HDL in Oracle cloud HCM?
HDL is known as HCM Data Loader which is used to Create and Update HCM data.
The data Received from external sources can be created or updated through HDL data format.
For creating an employee in oracle, Following are the mandatory Data needed to be given in the HDL file
Read MoreOracle Integration Cloud Gen 3 Interview Questions (Beginner)
1.) What is Oracle Integration Cloud (OIC)? Oracle Integration Cloud is a PaaS provided by Oracle under the purview of Its OCI (Oracle cloud infrastructure). It allows integrating multiple systems like SaaS, Cloud or On-premise systems. It can support integrating Oracle or Non Oracle systems. It is a up to date product that supports Adapter […]
Read MoreHow to add BI Report to Oracle cloud homepage and Restrict it by Role?
Go to BI reports and analytics>Browse Catalog Open the BI Report that you want to add to the Oracle cloud homepage: Copy the Link for the report which will look something like below: https://xxxx-dev1.fa.xx.oraclecloud.com:443/analytics/saw.dll?bipublisherEntry&Action=open&itemType=.xdo&bipPath=<Path> Now, go to Navigator> configuration> Sandboxes Create a Sandbox. Give sandbox name and structure access. Then, click on […]
Read MoreHow to Access/Modify/Pause Existing BI reporting schedules in Oracle Cloud Fusion?
After Creating BI report schedules, it is sometimes difficult to navigate to the existing schedule and modify it. The navigation for this is not always self explanatory. For achieving this, the following navigation can be used. 1.) Navigate to BI catalog. https://XXXX.fa.em5.oraclecloud.com/analytics/saw.dll?catalog 2.) Click on “Home” button on the right Navigation Bar. 3.) Click on […]
Read More