Oracle Cloud PaaS SaaS Fusion EBS Security

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

READ MORE +

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

READ MORE +

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

READ MORE +

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 VBCS Create a New Application ...

READ MORE +

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

READ MORE +

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 Book Assuming you have a working BIP report you should do the following Add the BIP report to Dashboard Open the Reports and Analytics work area. 2. Open the ...

READ MORE +

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

READ MORE +

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 Subtotals Example of subtotal requirement Sample Xml ...

READ MORE +

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 steps Enable Sandboxgo the the page where you need to add buttonUsing Add content add the button Add html content Configure the button to add the below Java ...

READ MORE +

How to get current logged in user in Oracle Fusion Cloud

There are scenarios when we need to get the current user logged in oracle fusion hcm ERP or SCM applications and we may want to do further processing related to the current user. So there are a few ways , lets discuss Get current logged in user for passing to external url When you are logged in Oracle ...

READ MORE +

IF Condition in RTF template| BI Publisher if xdoxslt:get_variable

When you create a BI Publisher template, you can add conditional statements to determine whether or not a condition is true or false. IF Condition in RTF template allows you to perform actions only when certain conditions are met. For example, you might want to display a message only when the value of a field ...

READ MORE +

Cybersecurity Training for Employees

Attention: Get ready for the next cyber attack - - the one you are going to get if you don't provide Cybersecurity Training for employees to defend themselves against online threats. If you are looking for ways to educate your employees on the importance of security, you might be interested in learning more about ...

$15.00 ~~$19.99~~ Check Details

How to check last dml statement executed on a table in oracle

How to add attachment to a Sales Order in oracle using Rest Api

How to Call BIP SOAP Service in OIC

How to Call Rest Api in VBCS

Dynamic Conditional Logos in BI Publisher RTF template

Adding Dashboards BIP Reports to Briefing Books

Create HCM Journeys Rest API

Adding Grand Total and SubTotal in RTF template BI Publisher

Call Web Service from Page Composer in Oracle Fusion SaaS

How to get current logged in user in Oracle Fusion Cloud

IF Condition in RTF template| BI Publisher if xdoxslt:get_variable

Cybersecurity Training for Employees

Thank you!

Ads Blocker Detected!!!

Compare items

Shopping cart