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

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

Unknown said...
This comment has been removed by the author.
Unknown 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.

Unknown 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

Unknown 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

Unknown said...
This comment has been removed by the author.
Anonymous said...

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

NareshIT said...

amazing post...thanks for sharing the valuable information. Best software Training institute in Bangalore

Unknown said...

Thank you for providing useful information and this is the best article blog for the students. learn Oracle Fusion Financials Online Training.

Oracle Fusion Financials Online Training

jyothi kits said...

Thank you for sharing such a valuable article with good information containing in this blog.SAP SD Online Training

SAP Security Online Training

SAP XI/PI Online Training


QuickBooks Payroll Support Phone Number said...

QuickBooks Payroll has emerged the best accounting software that has had changed the meaning of payroll. Quickbooks Payroll Support contact number is the team that offer you QuickBooks Payroll Support Phone Number

Jack Dorsey said...

QuickBooks Pro is some type of class accounting software which has benefited its customers with various accounting services. It offers brought ease to you by enabling some extra ordinary features and also at QuickBooks Support Phone Number it is simple to seek optimal solutions if any error hinders your work. With QuickBooks Pro you can easily easily effortlessly create invoices and keep close tabs on every little thing like exacltly what the shoppers bought, just how much they paid etc. In addition it lets you have a crystal-clear insight of your business that can help someone to monitor your cash, taxes as well as sales report, everything at one place.

Jamess said...

You will find so many fields it covers like creating invoices, managing taxes, managing payroll etc. However exceptions are typical over, sometimes it creates the negative aspects and user wants QuickBook Support Service help.

kevin32 said...

QuickBooks has been recognised world wide as the most effective and useful accounting software. Quickbooks Technical support customer care executives that actually work with you on QuickBooks Support contact number are responsible to control every Quickbook technical issue that creates in QuickBooks Support Phone Number software.

rdsraftaar said...

Having a concept about these common problems and their solutions come in handy during some crucial situation what your location is swept up. If these steps do not solve your issue you can promptly contact the QuickBooks Payroll Tech Support to avail expert advice.

rdsraftaar said...

QuickBooks Enterprise offers useful features which makes it more reliable as well as efficient. You can easily run your online business smoothly with great ease and flexibility utilizing this specialized accounting software. This is how you can save your valued time & money using intuit enterprise support. If you're a QuickBooks user and facing any issue regarding this software then call on the QuickBooks Enterprise Support Number USA.

kevin32 said...


QuickBooks Enterprise is a huge accounting software suite offered by QuickBooks Enterprise Support Number. The power-packed tools of this software enable you to handle your different business accounting module with ease.

QuickBooks Payroll Support said...

Comprises of an attractive lot of accounting versions, viz., QuickBooks Pro, QuickBooks Premier, QuickBooks Enterprise, QuickBooks Customer Technical Support Number, QuickBooks Mac, QuickBooks Windows, and QuickBooks Payroll, QuickBooks is becoming a dependable accounting software that one may tailor depending on your industry prerequisite.

Mathew said...


How come QuickBooks Tech Support Number different is quality of the services in the given time interval. The locus of the services will likely be in relation to delivering services in shortest span of that time period, without compromising aided by the quality of the services.

Bryan Willson said...


In the event that QuickBooks Error 6000-301 encounters while wanting to reinstate a backup, the media could be corrupted. Create a brand new backup or make another backup if required and attempt again.

Mathew said...

Our dedicated team is sure with you. These are generally surely working at any hour to assist and show you if you come across any QuickBooks Support Phone Number error/s. Our QuickBooks Support team surely have in-depth knowledge concerning the issues and problems of QuickBooks.

jameswill11 said...

QuickBooks Tech Support Number is an instrument that allows users to adhere to sales, customers, and inventory more proficiently and quickly. It absolutely was designed to offer the customer support of businesses also to meet their needs.

Jamess said...

The process is quite simple to contact them. First, you must sign in to your organization. There clearly was a help button at the very top right corner. You are able to click and inquire any question about QuickBooks accounting software. You may also contact our US customer support team using QuickBooks Tech Support Number

xpert said...

QuickBooks has been recognised around the globe as the most effective and useful accounting software. Quickbooks Technical support customer service executives that really work with you on QuickBooks Tech Support are responsible to manage every Quickbook technical issue that creates in QuickBooks software.

jameswill11 said...

The reason us different is quality of the services inside the given time interval. The locus of one's services is supposed to be based upon delivering services in shortest span of that time, without compromising aided by the quality of the services. Our Support For QuickBooks team is engaged in pre-research to make themselves prepared in advance when it comes to possible errors of QuickBooks.

QuickBooks Support Phone Number said...

Without doubt, this software uses the latest technology and approach to accounting which can be highly reliable and dependable. Have you been looking for QuickBooks Tech Support Number assistance?

steffan said...

We have been surely here for you personally. In closing, any error, any difficulty, any bug or whatever else related to QuickBooks related problem, just call our QuickBooks Tech Support Number. Surely, call our Quickbooks Tech Support.

Bryan Willson said...

QuickBooks Enterprise Technical Support Phone Number assists anyone to overcome all bugs through the enterprise kinds of the applying form. Enterprise support team members remain available 24×7 your should buy facility of best services.

QuickBooks Payroll Support said...

Intuit has developed these products by keeping contractor’s needs in mind; also, looked after the application solution in line with the company size. At the moment, QuickBooks Support Phone Number software covers significantly more than 80% associated with small-business share of the market.

Jamess said...

One will manage the Payroll, produce Reports and Invoices, Track sales, file W2’s, maintain Inventories by victimization https://www.enterprisesupportnumber.com/quickbooks-support/ detain mind that QuickBooks is not solely restricted into the options that we have a tendency to simply told you, it will probably do a lot more and it’ll all feel as simple as pie.

rdsraftaar said...

You might be always able to relate with us at our 247 Tech Support Number to extract the very best support services from our highly dedicated and supportive QuickBooks Support executives at any point of time as all of us is oftentimes prepared to work with you. Most of us is responsible and makes sure to deliver hundred percent assistance by working 24*7 to suit your needs. Go ahead and mail us at our quickbooks support email id whenever you are in need. You could reach us via call at our toll-free number.

tom wick said...

To know more info on QuickBooks Payroll Tech Support Number provided by us, it is possible to reach to your certified QuickBooks Support Phone Number. We offer every assistance on QuickBooks Payroll Support. Our team is there round the clock for you to solve your queries.

kevin32 said...

For several for the business organizations, QuickBooks Enterprise Support Phone Number really is and contains always been a challenging task to handle the business accounts in a proper way by finding the appropriate solutions. The best solutions are imperative for the growth of the company.

kevin32 said...


In order that’s why our technical support experts are yield to offer you every possible solution for all you associated issue at our QuickBooks Payroll Support Number Our experts’ team at QuickBooks Payroll Tech Support Number will likely make you gather its advanced functions and assists you to definitely increase your business growth.

kevin32 said...

QuickBooks Support Number knows there are always two sides to a coin and QuickBooks is not any different. This software also throws some errors in the end. Sometimes it becomes rather difficult to know this will be with this specific error code or message. In that case you ought to call our QuickBooks Support phone number to own in contact with our technical experts in order to search for the fix of error instantly.

kevin32 said...

Any QuickBooks Customer Service Number user faces any sort of identified errors in their daily accounting routine; these errors may differ from 1 another to a large degree, so our dedicated QuickBooks Payroll Pro-Advisers are very well loaded with their tools and expertise to give most effective resolutions very quickly to the customers.

quickbboks tech support phone number +1(855)-236-7529 said...

QuickBooks Tech Support Phone Number +1-855-236-7529. In order to experience maximum benefits from the software, give a ring to us on our QuickBooks Tech Support Phone Number +1-855-236-7529. Are you here for some help with your QuickBooks software? Probably well, you are in the right place! The Team QuickBooks Tech Support Phone Number +1-855-236-7529 deals with all the issues of QuickBooks software. QuickBooks is a reliable accounting software that has attracted millions of customers in the world. Or contact at QuickBooks POS Support Phone Number
Read more: https://tinyurl.com/y3kahnzm

QuickBooks Support Phone Number said...

Hey! Incredible post. Thank you so much for writing this post. I'll go ahead and bookmark your website for future updates. Just curious to know if you have heard QuickBooks accounting software. It is a well-known accounting software. You can easily use this software. You can even get immediate help and support at Contact Number for QuickBooks Support 1-833-441-8848.

Tech Customer Support Number said...

With an engaged mind and satisfied mindset, I just loved your content. Pure content and relevance with excellent presentation. Your blog will soon have number of visitors if you keep sharing more. Hey, I have been using QuickBooks for so long now. In case you need QuickBooks assistance, you can contact the best customer care executives at QuickBooks Support Phone Number +1 833-228-2822.

Read More: QuickBooks Error 3371

shalini said...

good....nice
category/advocate-resume
category/agriculture-forestry-fishing
category/android-developer-resume
category/assistant-professor-resume
category/chartered-accountant-resume
category/database-resume
category/design-engineer-resume
category/developer-resume
category/engineer-resume
category/entrepreneur-and-financial-services-resume

Blogsilly said...

Just simply clearing the “Cache” resolves many issues, this can work for QuickBooks Error Code 9999 as well. You can try this solution for other bank feed or crashed feed issues. Try on this solution and see if this works well. This itself might clear the issue without performing any other significant modifications to QuickBooks system. If you would like to learn How To Troubleshoot Quickbooks Error 9999, you can continue reading this blog.

Donald Trump said...

Wonderful post. quickbooks support number for quickbooks errors. good work.

QuickBooks Support Phone Number said...

https://buzzmytech.com/read-blog/1976
https://qbsupportphonenumber.site123.me/blogs/the-exceptional-team-at-quickbooks-support-phone-number-1-844-232-o2o2-helps-in-eradicating-every-query-of-quickbooks
https://buzzmytech.com/read-blog/1887
https://buzzmytech.com/read-blog/1886
https://qbsupportphonenumber.site123

QuickBooksSoftwareSolution said...

Dial QuickBooks Payroll Support Phone Number +1-844-232-O2O2 for quick and easy assistance to resolve your QB Payroll related issues. At this number, you will experience world-class support from the hands of the finest ProAdvisors.
Visit us: - https://blogcoli.com/quickbooks-payroll-support-phone-number/

QuickBooksSoftwareSolution said...

https://blogcoli.com/quickbooks-enterprise-support-number-2/
https://blogcoli.com/quickbooks-phone-number/
https://blogcoli.com/quickbooks-desktop-support-phone-number-2/

QuickBooksSoftwareSolution said...

https://blogcoli.com/quickbooks-helpline-number/
https://blogcoli.com/quickbooks-payroll-support-phone-number-3/
https://blogcoli.com/quickbooks-payroll-support-phone-number-3/

QuickBooksSoftwareSolution said...

https://blogcoli.com/quickbooks-payroll-support-phone-number-800-2/
https://blogcoli.com/quickbooks-support-phone-number-800/
https://blogcoli.com/quickbooks-tech-support-phone-number-usa/

vijay said...

Keep up the good work; I read few posts on this website, including I consider that your blog is fascinating and has sets of the fantastic piece of information.
Salesforce Training in Chennai

Salesforce Online Training in Chennai

Salesforce Training in Bangalore

Salesforce Training in Hyderabad

Salesforce training in ameerpet

Salesforce Training in Pune

Salesforce Online Training

Salesforce Training

Realtime Experts said...

This Post is really supportive to all of us. Eager that these kind of information you post in future also. Thanks for Sharing Otherwise if anyone want To Learn SAS Training
Best Oracle Workflow Course in Bangalore

Jon Hendo said...

Virtual events are naturally more inclusive than in-person events in many respects but there are still a lot of things that planners can do to make them more accessible to people with disabilities. event marketing and thank you email after successful event

Vaibhav Raut said...

Appreciate you for sharing power bi training

Sarika said...

It is amazing and wonderful to visit your site. Thanks for sharing this information. We are also providing the best services click on below links to visit our website.
Oracle Fusion HCM Training
Workday Training
Okta Training
Palo Alto Training
Adobe Analytics Training

Anonymous said...

Your integrity is unwavering. You always do what is right, even when it's not the easiest path to take. Buy google standard from google standard