SaveSavedRemoved 0

EGP_SYSTEM_ITEMS_B Tables SQL Query in Oracle Fusion

Using EGP_SYSTEM_ITEMS_B AND QP_PRICE_LISTS Tables we can create an Item Price List query in oracle fusion Cloud joining some othere important base tables for Pricing. The core table of pricing starts with QP Below are the important tables that store the Pricing information Important Price list tables in ...

READ MORE +

SaveSavedRemoved 0

BI Publisher Drill Down Report| How to create a hyperlink in BIP Report

BI Publisher Drill Down Report: Sometimes you may need to create a hyperlink from one Oracle BIP report to another. This feature is also called as Drill down reports in BI Publisher. For example you have a report which list out all the vendors and other details , and you have another report which shows the ...

READ MORE +

SaveSavedRemoved 0

Projects Contracts Expenditure query for invoice in Oracle Fusion

While building reports for Projects Contracts Expenditure and related invoice you would need to know the tables and joins. here is a basic query for fetching Contract Invoice projects distributions. Below is the screen with Contract Receivables invoice lines . The lines have project expenditures in ...

READ MORE +

Check it Out

SaveSavedRemoved 0

BI Publisher SOAP ExternalReportWSSService web service run report example

In this post, let's see a BI Publisher web service run report example using the web service called ExternalReportWSSService. The Oracle Fusion Cloud OTBI reports data can be fetched using web service calls using the ERP integration service. The service WSDL is of the format The output of the ...

READ MORE +

SaveSavedRemoved 0

6 Core AR Invoice Tables in Oracle Fusion Cloud

While developing BIP reports or querying invoice data we need to be aware of the common AR invoice tables in oracle fusion cloud applications. many of these tables are in sync with AR invoice tables of oracle apps r12 EBS. The above table describes what kind of receivables transactions are stored and in which ...

READ MORE +

SaveSavedRemoved 0

Parallel Approvals in BPM Workflow Oracle Fusion

There are times we need to implement Parallel Approvals in BPM Workflow in Oraclce Fusion. Let's see how to implement it. First, we need to figure out which are the parallel participants in the BPM workflow in oracle fusion cloud. We will take the example of the Oracle Payables approval workflow. ...

READ MORE +

SaveSavedRemoved 0

Create AP Invoice rest api in Oracle Fusion ERP

You can easily create AP invoices using Create AP Invoice rest API in Oracle fusion The rest APIs are /fscmRestApi/resources/11.13.18.05/invoices to query an invoice you can use the query parameter in postman ...

READ MORE +

SaveSavedRemoved 0

Create Customer Rest API in Oracle Fusion

With Release 20D we can use rest api to create Customers in Oracle Fusion SaaS. Use the followig payloads to create customers into fusion when we are integrating application or loading data in fusion. In fact you need to use it in combination of SOAP service to make the customer transactable. Outline ...

READ MORE +

SaveSavedRemoved 0

How to download ADFdi in Oracle Fusion Cloud| Install ADFdi Plugin for Excel

Here we will see how to download ADFdi in Oracle Fusion Cloud. With the newer versions of Oracle cloud the ADFDi add-in for Excel to upload data into oracle fusion applications requires some roles to be configured. Be aware that the ADFdi desktop helps in fetching the interface records directly from the ...

$10.00 $64.99 Learn Oracle Fusion