Fusion Apps Tech Archives | Cloud Technologies Blog

Fusion Apps Tech

Some useful stuff on Oracle SaaS Fusion Cloud HCM ERP SCM CX Application Technology and Cloud Integration

Show all
Hottest
Popular
Random

Create Sales Order Rest Api Sample Payload Oracle Fusion

Below is the Create Sales Order Rest Api Sample Payload to create Sales order in oracle FusionThe Rest API URL isBasic Order Creation Json Payload{ "SourceTransactionNumber": "PS_REST_324", "SourceTransactionSystem": "OPS", "SourceTransactionId": "PS_REST_324", "TransactionalCurrencyName": "US ...

READ MORE +

Create TimeCard Rest Api in Oracle Fusion

If you need to create a timecard in oracle fusion programmatically, you can use the timeRecordEventRequests REST API provided by oracle. You can use this Create TimeCard Rest Api in Oracle Fusion to Create & Update Time Entries as well. Below are sample payloadsCreate Timecard with Projects Rest ...

READ MORE +

Download AP Invoice Attachment to OIC| UCM Attachments

In this post, lets see How to Download AP Invoice Attachment to OIC using the ERP integration service and using the ERP object attachment service. The test cases below is based on hardcoding the document id you can use this as reference to add this logic by dynamic mapping based on your integration scenario....

$10.00 ~~$84.99~~ Learn Fusion

Check it Out

How to Embed External URL Content into Oracle Fusion

In this post we will see How to Embed External URL Content into Oracle Fusion. This is a common requirement when you need to embed content outside of oracle fusion cloud for e.g a PaaS Screen like VBCS application or a Rightnow screen or a PCS screen etc.So lets look at the stepsYou will need to have a ...

READ MORE +

SQL for Item Price List Query in Oracle Fusion Cloud

To create an Item Price List query in oracle fusion Cloud we need to have the important base tables for Pricing. The core table of pricing starts with QPBelow are the important tables that store the Pricing informationImportant Price list tables in Oracle Fusion1. QP_PRICE_LISTS_ALL_B2. ...

READ MORE +

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 +

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 +

BI Publisher 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 formatThe output of the ...

READ MORE +

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 +

Show next