Unit Testing in SOA Suite 12C
In this article, I will show you the steps of preparing test cases for a particular SOA application. For this example, I have created a simple mediator service which will display the output as Hello + input string. Create a …
How to Raise Business Event in SOA Suite 12C
Introduction The introduction of Business Event and Event Delivery Network makes SOA platform stronger. You can publish/subscribe event and consume event also from different programming environment such as java, SOA, ADF-BC. This example will show you how to publish a …
How to Update/Reset Password For a User in Oracle Apps
We know how to update or reset password for a user. This is how it is: Naigation: System Administrator > Security > Users > Define Query for the User for which the password needs to be updated. Enter New Password …
Advanced Queue in Oracle Database
Here we will create advanced queue in Oracle Database and will perform enqueue and dequeue operations also using DBMS_AQADM package. Follow the below steps to achieve this. Add below two roles to user for queuing operation in database. AQ_ADMINISTRATOR_ROLEA�- Allows …
Enqueue in Advanced Queue using AQ Adapter in SOA Suite 12C
In previous example, we have explored enqueuing operation from database, now we will do the same operation using AQ adapter in SOA Suite 12C. First we have to create data source and outbound connection pool in admin server and then …
Dequeue in Advance Queue using AQ Adapter in SOA Suite 12c
Here we will read the data from Advanced Queue and will write it in a file. In this example we will use Asynchronous BPEL process, AQ Adapter and File Adapter to complete this task. Create a new SOA project under …
All About Items in OAF
An item in OAF is a java bean which allows a user to interact with the Oracle Apps Framework page e.g. a text box or a choice box etc. Components or items are always placed inside some region so that …
How to Attach Responsibility To User From Backend
We know how to attach responsibility to a user. This is how it is: Naigation: System Administrator > Security > Users > Define Query for the User for which the responsibility needs to be added. Add Responsibility Now we …
How to Delete Oracle Alert using API
Alert can be enabled or disabled but can not be deleted from Oracle Alert Form. But here is way out to delete from backend using SQL Script: SQL Script to Delete Oracle Alert DECLARE ln_appl_id NUMBER; ln_alert_id NUMBER; BEGIN SELECT …
How to Delete Concurrent Program in Oracle Applications/ EBS
As we know that concurrent programs can not be deleted from the front end i.e. Concurrent Program Definition but we can deactivate the concurrent program by unchecking the Enable Checkbox. Delete Concurrent Program using API DECLARE lc_prog_short_name VARCHAR2(240); lc_exec_short_name VARCHAR2(240); …
Deploying OAF Customization in R12.2.X
In R12.1.3, Custom OAF Module and OAF Customization deployment is pretty simple. Having created the directory structure under $JAVA_TOP/<custom_folder> as recommended by Oracle, the .class and .xml files are moved to the corresponding folders and having imported the Pages and …
HelloWorld Example using BPEL process in SOA Suite 12c
Today I am going to discuss BPEL, Business Process Execution Language. It’s basically a programming language for Oracle SOA. So we will see What BPEL is and How to use different activities in BPEL followed by a HelloWorld Example. BPEL …
Recent Comments