• Latest
  • Hottest
  • Popular
  • Lowest price
  • Highest Price
  • Random
Create Sales Order Rest Api Sample Payload Oracle Fusion
SaveSavedRemoved 0

Create Sales Order Rest Api Sample Payload Oracle Fusion

00

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
SaveSavedRemoved 0

Create TimeCard Rest Api in Oracle Fusion

00

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 +
SQL WHERE CONTAINS statement
SaveSavedRemoved 0

SQL WHERE CONTAINS statement

00

SQL where contains is used to check the value if present in a column. Mostly used in Unstructured data testing on text based fields.In oracle, the column where we need to apply contains needs to be indexed.In SQL Server CONTAINS is a predicate used in the WHERE clause of a Transact-SQL SELECT statement to do ...

READ MORE +

Check it Out

Explained: CASE in Oracle SQL PL SQL
SaveSavedRemoved 0

Explained: CASE in Oracle SQL PL SQL

00

In this post, we see how to use CASE in Oracle with examples expressions.USECASE statement is an example of IF then ELSE condition in SQL programmingSyntaxCASE [ expression ]WHEN condition_1 THEN result_1 WHEN condition_2 THEN result_2 ... WHEN condition_n THEN result_n...

READ MORE +
Download AP Invoice Attachment to OIC| UCM Attachments
SaveSavedRemoved 0

Download AP Invoice Attachment to OIC| UCM Attachments

00

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
How to Embed External URL Content into Oracle Fusion
SaveSavedRemoved 0

How to Embed External URL Content into Oracle Fusion

00

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
SaveSavedRemoved 0

SQL for Item Price List Query in Oracle Fusion Cloud

00

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 +
Projects Contracts Expenditure query for invoice in Oracle Fusion
SaveSavedRemoved 0

Projects Contracts Expenditure query for invoice in Oracle Fusion

00

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 +
Show next
Cloud Technologies Blog
Logo
Compare items
  • Total (0)
Compare
0
Shopping cart