Tuesday, November 15, 2011

Migration Business events and subscriptions

Migrating business events and subscriptions

How do migrate business events and subscription..one of them is using java command wfx load or using packages

Business Events
$AFJVAPRG oracle.apps.fnd.wf.WFXLoad -d apps apps_pwd machine_name:port_no:SID thin US Custom_File_Name.wfx EVENTS Business_Event_Name

Subscriptions:

$AFJVAPRG oracle.apps.fnd.wf.WFXLoad -d apps apps_pwd machine_name:port_no:SID thin US Custom_File_Name.wfx SUBSCRIPTIONS Business_Event_Name

$AFJVAPRG oracle.apps.fnd.wf.WFXLoad -u apps apps machine_name:port_no:SID thin US Custom_File_Name.wfx

TO force upload a Subscription:

$AFJVAPRG oracle.apps.fnd.wf.WFXLoad -uf apps apps_pwd machine_name:port_no:SID thin US Custom_File_Name.wfx

use the below package to load business event and subscription information using script


wf_event_pkg
wf_event_subscriptions_pkg

This looks easy way for me..


use wf_event_pkg.generate to generate the xml
use that xml as input data for wf_event_pkg.recieve to create a script and migrate to other instances..

l_GUID is the event unique identifier which is available in wf_events table.


declare
l_GUID raw(32000):='AAD7E8E4319215BFE04025ADD478036C';
l_xml_data varchar2(32000);
begin
l_xml_data:=wf_Events_pkg.generate(l_GUID );
dbms_output.put_line ('xml data'||l_xml_data);
end;

Use the output we got above as the input for wf_even_pkg.receive.By using the below script we can migrate the event data to other environments

The xml generated above will contain xml tags like wf_event,guid,name etc..But the some how while posting the tags are removed..




begin
wf_Events_pkg.receive(l_xml_data );
--dbms_output.put_line ('xml data'||l_xml_data);
end;


select * from wf_events where name like 'xxpor%'


Similarly use the wf_event_subscriptions_pkg.generate to generate susbscription xml and use the same XML as inpu to the recieve function
Always make sure you load the event before subscription.

One other way directly use the package insert_row procedures to load data.That requires data that needs to be derived

9 comments:

facebook developer said...

hey
that is nice information through your blog.
i am new in oracle field that is y i am searching diffferent blogs on the web.

Sridevi Koduru said...
This comment has been removed by the author.
Cub Training said...

Its impressive to know something about your note on Oracle apps Course. Please do share your articles like this your articles for our awareness. Mostly we do also provide Online Training on Cub training oracle apps course.

Jesica Reese said...

For a business event to be a success, you require a well planned, well planned, and a well-executed event.

Corporate Event | Wedding Planners | Event in India

Mindmajix Trainings said...

wonderful blog, seeking instruction on oracle apps complex, Check this site for indepth Oracle Applications Technical Training Go here if you’re looking for information on Oracle Applications Technical Training

vanillajuice said...

I think we should invite Jessica Reed to an Oracle Business Event

Sridevi Koduru said...
This comment has been removed by the author.
Sridevi Koduru said...

Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.

Anonymous said...

Does GUID has any importance while migrating?
Can we migrate the business Event Subscription with GUID of one instance to other?