- Show all
- Popular
A Quick Guide to Delete Column in SQL: Oracle Database
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. ...
How to Edit a Scheduled Report job in Oracle Fusion
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 ...
What is Oracle ERP Cloud and Its Benefits?
In today's fast-paced business environment, organizations require an efficient and reliable solution to manage their operations. Oracle ERP Cloud is a cloud-based suite of enterprise resource planning (ERP) software that streamlines business processes and enables companies to manage their finances, supply chain, ...
How to check last dml statement executed on a table in oracle
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 ...
How to add attachment to a Sales Order in oracle using Rest Api
To add an attachment to a sales order in Oracle Order Management Cloud, you can follow these steps:Adding attachment to Sales order from UINavigate to the Sales Order page for the order you want to attach a file to.Edit the Sales Order and click on Actions > Manage AttachmentsThe Attachments ...
How to Call BIP SOAP Service in OIC
This is a frequent requirement in OIC , sometime you need to call BIP SOAP service in OIC to do integrations.The reasons can beThe Rest service of the business object is not availableYou have a custom Requirement based on a custom data setSo here are the steps to call a BI publisher SOAP ...
How to Call Rest Api in VBCS
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 VBCSCreate a New Application ...
Dynamic Conditional Logos in BI Publisher RTF template
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 ...
Adding Dashboards BIP Reports to Briefing Books
Briefing Books in Oracle Fusion Reports and Analytics is a way to add your dashboard reports in form of Briefing.To add BIP Report to Briefing BookAssuming you have a working BIP report you should do the followingAdd the BIP report to Dashboard Open the Reports and Analytics work area.2. Open the ...
Create HCM Journeys Rest API
Oracle HCM Journeys are set of tasks grouped and assigned to employees by managers or HR administrators . These Journeys can be then monitored to check employee's progress.Employees will be automatically presented with their tasks, sequentially, as per the order set by the manager or HR while creation of the ...
Adding Grand Total and SubTotal in RTF template BI Publisher
Sometime there is a need to add subtotals in BIP RTF template. Though we know that this can be handled in SQL query data model but still there are times especially to modify some existing reports. So lets see with an example.Oracle support note on SubtotalsExample of subtotal requirementSample Xml ...
Call Web Service from Page Composer in Oracle Fusion SaaS
Sometimes we need to call web service from page composer in oracle fusion on click on a button.We can do this by following the below stepsEnable Sandboxgo the the page where you need to add buttonUsing Add content add the buttonAdd html contentConfigure the button to add the below Java ...
