It is quite common for developers working on BIP reports that their changes sometimes do not reflect when trying to preview the reports. The issue is sometimes due to incorrect caching.
The caching issue does not pick up the lastest changes and thus you see that your changes are not showing up.
The solution is ...
Oracle Fusion ERP Cloud business events helps us to know what transaction has happened in Oracle Fusion. During integration, you can subscribe to a business event to trigger a downstream application from Oracle Fusion.
Let's look at an example with OIC.
suppose in a use case you have to create an order in ...
Date comparison is a common requirement when working with Oracle Integration Cloud (OIC). However, users often encounter challenges and errors while attempting to compare date values within OIC. I
The Problem:
Developers face issues when comparing two date values within a conditional statement in OIC.
...
In Oracle Fusion, the DOO_HEADERS_ALL table plays a significant role in managing and tracking order headers within the Order Orchestration (DOO) module. This table acts as a central repository for storing essential information related to order processing and management. In this blog post, we will delve into the ...
The "PER_ALL_ASSIGNMENTS_M" table in Oracle Fusion HCM is a key table that stores information about assignments in the system. It is part of the Oracle Fusion Human Capital Management (HCM) application and plays a crucial role in managing employee assignments and their associated details.
Functionally, the ...
Introduction: Overview of Deleting Columns in SQL: Syntax for Deleting Columns in Oracle Database: Considerations before Deleting Columns: a. Data Preservation:b. Dependencies:c. Constraints:Examples of Deleting Columns in Oracle SQL:a. Deleting a Single Column: Result b. Deleting Multiple Columns: Resultc. ...
Sometimes you have sumbitted a BIP report as scheduled process and want to edit the frequency later. So to edit a scheduled report job in Oracle Fusion, you can follow these steps:
Log in to your Oracle Fusion application with the appropriate credentials.
Navigate to Report and analytics. Click on ...
In Oracle, you can check the last DML (Data Manipulation Language) statement executed on a table by querying the data dictionary view called DBA_HIST_SQLTEXT. This view contains the history of all SQL statements executed in the database.
Here's a sample query to retrieve the last DML statement executed on a ...
To add an attachment to a sales order in Oracle Order Management Cloud, you can follow these steps:
Adding attachment to Sales order from UI
Navigate to the Sales Order page for the order you want to attach a file to.
Edit the Sales Order and click on Actions > Manage Attachments
The Attachments ...
This is a frequent requirement in OIC , sometime you need to call BIP SOAP service in OIC to do integrations.
The reasons can be
The Rest service of the business object is not available
You have a custom Requirement based on a custom data set
So here are the steps to call a BI publisher SOAP ...
In this post we will see how to call rest api in vbcs. This is particularly useful in when interacting with fusion applications, though its not limited there. You may need to use rest api call to do CRUD operation in Business objects as well.
Steps to call a Rest Api in Oracle VBCS
Create a New Application ...
Sometimes you need to add logos conditionally in a BIP report. The reason for adding dynamic conditional logos in BI Publisher can be for example :
A Company has different child companies and each of them has a different brand and logo, and based on the organization selected you may need to change the logo at ...