Oracle Cloud Reports

How 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
Oracle Cloud Reports

How to find the IP address of the users logged in to Oracle fusion cloud?

We require the need to track the security of a financial system such as oracle cloud with a close look. Thus, tracking of the user location and activity becomes critical to the well being of the ERP system like Oracle ERP cloud.  We can use the below query to extract the IP address of a […]

Read More
Oracle Cloud General Ledger Oracle Cloud Payables

How to mark an AP invoice failing in accounting as Accounted without actually posting the accounting enteries in Oracle cloud?

Please follow the following steps to account a problematic invoice: Please make sure invoice is cancelled before following this steps: Step 1 – create/enable the following profile options at site level: AP_SHBYIV_ENABLEAP_SHBYIV_MARK_UNACCT_INVOICE_EVENTS2_NU Setup and Maintenance -> Manage Profile Options -> New -> Create Profile Option as : – Profile Option Code: AP_SHBYIV_ENABLE– Profile Display Name: […]

Read More
Oracle Cloud HCM

How to terminate employee from HDL in Oracle cloud HCM?

HDL is HCM Data loader tool to create and Integrate the Employee Information in Oracle cloud. With the Help to HDL tool we can create and update Employee Information from External system. In the Same way if we want to Terminate the Employee from Back end or form External System then we can also do the same through HDL tool. HDL tool helps to allow the Employee Termination […]

Read More
Oracle Cloud Receivables

Common Tables and their Purpose for Oracle Cloud Receivables

This post will list the tables needed to verify data and building reports for Oracle cloud Receivables. Table Name Purpose Primary Key Important columns Important Joins RA_CUSTOMER_TRX_ALL This table consists of header information for receivable invoices, debit memo and credit memo CUSTOMER_TRX_ID TRX_NUMBERTRX_DATECOMPLETE_FLAG RA_CUSTOMER_TRX_LINES_ALL This table consists of line information for receivable invoices, debit memo […]

Read More
Oracle Cloud Cash Management

Import Electronic Bank Statements Automatically into Oracle cloud Cash management

Use the payment transmission configuration feature to automate the bank statement file import process. The process uses the payments transmission feature to connect to bank and download the bank statement file for subsequent processing and loading into the application. Perform the following steps to set up automatic bank statement file import: Set up Payment System: […]

Read More
Oracle Cloud Payables

Oracle Fusion Cloud Technical Interview Questions and Answers

1. What are the types of data that you can use in the Cloud Fusion Application including cloud? Which one is more critical among them? With respect to the rise in cloud technology in the last few years, a significant change has been seen in the data types. Presently, three types of data are common […]

Read More