Oracle Cloud PaaS SaaS Fusion EBS Security

Oracle Fusion Cloud Branding (HCM ERP SCM)

30

In this post we will see how to do Oracle Fusion Cloud Branding in HCM ERP or SCM applications. Branding is necessary to match the look and feel of the organizations web presence theme. like the logo , fonts and backgrounds. So Lets go in How to do branding in Oracle Fusion Cloud Launch a SandboxLogin ...

READ MORE +

Update EFF DFF on Sales Order using Rest Api Oracle Fusion

00

We can update and Order EFF or DFF using the provided Rest Apis. The order should be in a state of update. Also with this API an Order can be revised. How to Create an Order with Fulfillment Line and Header EFF information Using the - salesOrdersForOrderHub - REST API The Rest API URL is Query an ...

READ MORE +

Data Stitch and set global variable in Oracle OIC

00

During the course of your OIC orchestration process builds many times you may need to set global variable in Oracle OIC to design the logic and implement the business case. It is not uncommon in processes. Local and global variables are quite an important feature in any programming language Oracle ...

READ MORE +

[Resolved] ORA-06550 PL SQL Error in Oracle

00

ORA-06550 PL SQL Error in Oracle: While working on Oracle technologies, especially PL SQL or any tool or programming language interacting with the Oracle database, you might encounter ORA 06550 error. What is this and how do we resolve it, We will look at it in this post. A Successful call to an existing ...

READ MORE +

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 Fusion The Rest API URL is Basic 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

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 payloads Create Timecard with Projects Rest ...

READ MORE +

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 +

Explained: CASE in Oracle SQL PL SQL

00

In this post, we see how to use CASE in Oracle with examples expressions. USE CASE statement is an example of IF then ELSE condition in SQL programming Syntax CASE [ 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

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. ...

$15.00 ~~$84.99~~ Learn Fusion

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 steps You will need to have a ...

READ MORE +

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 QP Below are the important tables that store the Pricing information Important Price list tables in Oracle Fusion 1. QP_PRICE_LISTS_ALL_B2. ...

READ MORE +

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

00

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 +

Oracle Fusion Cloud Branding (HCM ERP SCM)

Update EFF DFF on Sales Order using Rest Api Oracle Fusion

Data Stitch and set global variable in Oracle OIC

[Resolved] ORA-06550 PL SQL Error in Oracle

Create Sales Order Rest Api Sample Payload Oracle Fusion

Create TimeCard Rest Api in Oracle Fusion

SQL WHERE CONTAINS statement

Explained: CASE in Oracle SQL PL SQL

Download AP Invoice Attachment to OIC| UCM Attachments

How to Embed External URL Content into Oracle Fusion

SQL for Item Price List Query in Oracle Fusion Cloud

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

Thank you!

Compare items

Shopping cart