Oracle Apps Fusion Training Home Oracle Apps, Fusion, EBS http://apps2fusion.com/component/content/frontpage Fri, 10 Jul 2009 23:47:37 +0000 Joomla! 1.5 - Open Source Content Management en-gb anilpassihttp://feedburner.google.com Asynchronous BPEL Process Tutorial http://feedproxy.google.com/~r/anilpassi/~3/hJymKkndA5Y/415-asynchronous-bpel-process-tutorial Asynchronous BPEL Process

 

A Asynchronous Process is one which you call and need not wait for the response before proceeding further. You may just initiate the Asynchronous process and receive the response when you require it as a part of your process, hence you are not forced to wait for response.

 

For analogy sake, let me give you an example for better understanding. I have chosen simplicity of the analogy above technical similarity.

 

Real life example of a Synchronous process: You call a friend and ask him to give you some information. While your friend is finding out the information for you, you are on the call waiting for his response. Note that connection is not dropped

 

Real life example of an Asynchronous process: You call a friend and ask him to give you some information. You ask him to call you back when the information is ready and you disconnect the call. When your friend is ready with the information, he calls you and gives you the information. Note that you don’t wait for a response from your friend and connection is lost. When your friend is ready, he has to establish a new connection and then provide you the information

  ]]> frontpage Thu, 09 Jul 2009 20:35:34 +0000 http://apps2fusion.com/apps/soa/bpel/415-asynchronous-bpel-process-tutorial FNDLOAD AME Objects http://feedproxy.google.com/~r/anilpassi/~3/Z61txO-cy-4/414-fndload-ame Normal 0 MicrosoftInternetExplorer4

We have in the past articles seen various examples of FNDLOAD, for both AOL objects and web ADI. In this article, you will see how to move AME Definitions from one instance to another. The confusing thing about AME FNDLOAD is that these scripts are available in two locations, which are
$AME_TOP/patch/115/import
$PER_TOP/patch/115/import
It is recommended to use the LCT files in $AME_TOP where possible.

In this article, you will learn to download and upload the following AME Components
1. AME Conditions
2. AME Groups
3. AME action type usages
4. AME Rules

]]> frontpage Mon, 06 Jul 2009 23:57:11 +0000 http://apps2fusion.com/apps/apps/414-fndload-ame Maintaining authentication between APEX applications http://feedproxy.google.com/~r/anilpassi/~3/7hLpxPItAtU/413-maintaining-authentication-between-apex-applications  

If you have a bunch of APEX applications which are authenticated in similar fashion say using EBS login credentials, this article shows you how to maintain authentication while navigating between those applications without going through login process again. 

For example, I have a central application which has links to HR and Payables apex applications. I login to central application and navigate to HR application without re-login. Also if I logout from HR application, I will redirected to login page of central application.  It is similar to eBusiness Suite security model where upon successful login, I've responsibilities to choose a particular module. This approach makes sense if these apex applications are authenticated  in the same way.
]]> frontpage Mon, 06 Jul 2009 14:47:22 +0000 http://apps2fusion.com/at/kr/413-maintaining-authentication-between-apex-applications How to call Oracle Apps Adapters from BPEL ? http://feedproxy.google.com/~r/anilpassi/~3/pDmvn5vVe7E/412-how-to-call-oracle-apps-adapters-from-bpel- This article would cover setups required to enable BPEL to poll Oracle apps adapter as well as we will also see an example of how all of this fits together

 

]]> frontpage Thu, 02 Jul 2009 00:00:00 +0000 http://apps2fusion.com/at/cp/412-how-to-call-oracle-apps-adapters-from-bpel- Synchronous BPEL Process Tutorial http://feedproxy.google.com/~r/anilpassi/~3/6_WD6fxSvHc/411-synchronous-bpel-process-tutorial Synchronous BPEL Process Tutorial

A Synchronous BPEL Process is one which you call and wait for the reply before proceeding further.

This is used in real time processing of services.

 

Anil has done an excellent job in making us create a HelloWorld.

I have created a similar HelloWorld for our use.

 

We will call the same HelloWorld process created earlier. As this process gives us a reply in real time, this can be used as a synchronous process.

]]> frontpage Tue, 23 Jun 2009 18:14:54 +0000 http://apps2fusion.com/apps/soa/bpel/411-synchronous-bpel-process-tutorial How to get elapsed time for APEX region? http://feedproxy.google.com/~r/anilpassi/~3/Bfv8DX4T-54/410-how-to-get-elapsed-time-for-apex-region  

Oracle APEX application is blazingly fast. Its' performance can be negatively effected by poorly written queries. To optimize application performance, you can use few substitution strings to see elapsed time for rendering each region in a page. This helps in pin pointing long running regions and tuning queries behind them.

]]> frontpage Mon, 22 Jun 2009 15:44:33 +0000 http://apps2fusion.com/at/kr/410-how-to-get-elapsed-time-for-apex-region How to display company logo for APEX application? http://feedproxy.google.com/~r/anilpassi/~3/wRMuq5HkiTQ/409-how-to-display-company-logo-for-apex-application A basic requirement in most implementations is displaying company logo. This article shows how to achieve it in Application Express.

Requirement:
Display Apps2Fusion logo on Person Details application http://apex.oracle.com/pls/otn/f?p=62577. To take step forward, I want to make the image clickable to redirect user to apps2fusion website in separate window.

]]> frontpage Sun, 07 Jun 2009 15:18:50 +0000 http://apps2fusion.com/at/kr/409-how-to-display-company-logo-for-apex-application Application Items in APEX http://feedproxy.google.com/~r/anilpassi/~3/wVPIOaJa-Ak/408-application-items-in-apex I have requirement to capture where if I would be coming from some page say 'page23' then page 2 items should be displayed as uneditable. Can you please mention how I can cater this case in Apex?

Hassan's requirement is, suppose you have two pages Manager and User from where you can navigate to Order page. Items in Order page say Order Number, Order date are editable only when you come from Manager page. Otherwise they are read only or display only fields. This is a perfect example to show use of Application Items.
]]> frontpage Fri, 22 May 2009 02:33:06 +0000 http://apps2fusion.com/at/kr/408-application-items-in-apex How to extend root application module using nested application module http://feedproxy.google.com/~r/anilpassi/~3/QGQGpo92tZA/407-how-to-extend-root-application-module-using-nested-application-module My previous article on Nested application module showed extending root AM by attaching nested AM programmatically. In this article I'll show another approach to achieve same objective. My objective is to add custom logic to print "Requisition Header Id" in console when "Add to Cart" button is pressed during requisition creation in iProcurement. Some details of 'About this Page' for Non-Catalog Request page.

Page Name: NonCatalogRequestPG
Controller: NonCatalogRequestCO
AM: RequisitionAM

]]> frontpage Fri, 15 May 2009 18:37:22 +0000 http://apps2fusion.com/at/kr/407-how-to-extend-root-application-module-using-nested-application-module Save State before branching - New Security feature in APEX 3.2 http://feedproxy.google.com/~r/anilpassi/~3/tcmfEhr64AM/405-save-state-new-security-feature-in-apex-32 You have seen how APEX URL carries parameters when branched from one page to another. Session State Protection can prevent users from tampering URL, but it doesn't help much in not showing parameters in URL. Imagine how it could be a security vulnerability when you pass sensitive information like passwords, ssn etc.

]]> frontpage Thu, 14 May 2009 17:53:00 +0000 http://apps2fusion.com/at/kr/405-save-state-new-security-feature-in-apex-32 Nested Application Modules in OA Framework http://feedproxy.google.com/~r/anilpassi/~3/G4xm3Dvr4pw/404-nested-application-modules-in-oa-framework In one of my old articles on OA Framework extension, I briefly mentioned about Nested Application modules. Today I will explain how Nested Application module can be used. Nested AM is an application module which is under the scope of root application module. Root application module is the AM attached to top region of the page during design time. It maintains the session state and retention level for requests between client and server.

Root AM can contain one or more nested AMs which can themselves nest children to any arbitrary level. In this scenario, the root AM has access to all the data/objects held by its children, and all children participate in the same transaction established by the root.

]]> frontpage Thu, 14 May 2009 03:59:48 +0000 http://apps2fusion.com/at/kr/404-nested-application-modules-in-oa-framework Raising Business Event from PL/SQL or Java Layer http://feedproxy.google.com/~r/anilpassi/~3/QPkYDh62-hg/403-raise-business-event-from-java-pl-sql Following are the questions can often come to mind when dealing with Business Event Subscriptions
1. What is the difference between raising a business event from PL/SQL or from Java
2. Why you should not raise a Business Event from OA Framework using a JDBC call to "wf_event.raise"
3. The subscription does not fire in real time, even though business subscription phase is less than 99

Let us deal with these questions one by one.

]]> frontpage Wed, 13 May 2009 21:25:51 +0000 http://apps2fusion.com/apps/workflows/403-raise-business-event-from-java-pl-sql Invoke Web Service via Business Event http://feedproxy.google.com/~r/anilpassi/~3/U9H9yVmUruY/402-business-event-wsdl-web-service ]]> frontpage Tue, 12 May 2009 22:29:34 +0000 http://apps2fusion.com/apps/workflows/402-business-event-wsdl-web-service Oracle AIM Project Management Methodology http://feedproxy.google.com/~r/anilpassi/~3/bHpZzUPtgFk/401-aim-project-management-methodology Oracle AIM Project Management Methodology provides the basic framework in the Implementation of Oracle E-Business Suite to Clients by the Implementers. I have prepared this document based on my Project Management experiences and this may not be a 100% fool proof method. But I tried to give importance to the basics of AIM Methodology which will help the freshers, Intermediate and average consultants to gain the basic understanding and knowledge of Oracle AIM Methodology and grow up in their career.

Click here to access this document

]]> frontpage Sun, 10 May 2009 07:53:33 +0000 http://apps2fusion.com/at/sk/401-aim-project-management-methodology Prevent URL tampering using APEX Session State Protection http://feedproxy.google.com/~r/anilpassi/~3/mytCMXOobDY/400-preventing-url-tampering-using-apex-session-state-protection By now you should be having a fair idea of high usability of Oracle Application Express a.k.a APEX with its easy navigation between pages using column links, branches, breadcrumbs, navigation tabs, etc. For example, in Person Details application you can click on edit icon on a person row which takes you to Edit page for editing and saving that person details. The navigation here is done through column link by setting P4_PERSON_ID page item on Edit page (4) with Person_Id column value. If you observe closely parameters appear on URL string, it looks similar to

http://apex.oracle.com/pls/otn/f?p=62577:4:7632245014057279::NO::P4_PERSON_ID:241

where 7632245014057279 is my session id, P4_PERSON_ID is page item and 241 is page item value.

 

]]> frontpage Thu, 07 May 2009 22:41:49 +0000 http://apps2fusion.com/at/kr/400-preventing-url-tampering-using-apex-session-state-protection