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); …
How to Delete RTF and Data Template in XML Publisher
Today, I will show you how we can delete RTF and Data Template rather the entire definition using SQL Script. SET SERVEROUTPUT ON DECLARE — Change the following two parameters var_templateCode VARCHAR2 (100) := ‘XXSAMPLERPT’; — Template Code boo_deleteDataDef BOOLEAN …
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 …
Create SOAP based Web Service from PLSQL Package
We have seen how to create SOAP based web service from java class. Here we will create web service from PL/SQL package. Description of operations while creating web service In this example, web service will be created based on calculator …
Deploy SOAP based Web Service in Weblogic using WAR File
In my previous blog,A�I have discussed how to createA�web service from java class. To make this web service available over the network, we need to deploy the web service in the web logic server. Here we will learn how to …
Recent Comments