Thursday, 25 April 2013

Query for link between ap_checks_all and ce_payment_documents

This following query written for R12 migration. Hope it will be useful. 

SELECT cpd.payment_document_name
  FROM ap_checks_all ac,
       iby_docs_payable_all idpa,
       iby_payments_all ip,
       iby_used_payment_docs iupd,
       ce_payment_documents cpd
WHERE idpa.payment_id = ip.payment_id
   AND ip.paper_document_number = iupd.used_document_number
   AND iupd.payment_document_id = cpd.payment_document_id
   AND ac.checkrun_name = ip.payment_process_request_name
   AND ac.check_number = :p_check_number

Thursday, 2 August 2012

Oracle OAF - Welcome Page Creation


Oracles OAF welcome page creation steps using Jdeveloper(10.1.3.3.0):
The following steps for creating simple OAF page using Jdeveloper and register the OAF Page with Oracle Application Release 12.

Step 1:
Right Click on Application in application navigator and click “New OA Workspace” to create workspace for project. Dialog box will be open in the window, Type filename and browse directory to create application in local drive. Press OK to continue.


Step 2:
Oracle applications project wizard dialog box will be open, and then type your project name, directory path no need to entered(its default) and default package to be your oracle application folder path (for example: oracle.apps.per.emp.projects.welcomepn.webui).



Step3:
In the next step, Press Next button. Press Browse button and select .dbc  file from local drive.
Enter your Oracle application username and password in respective fields in dialog box.
In responsibility tab, enter your Oracle application short name and Responsibility key.

You may export dbc file from oracle folder path as follows: /d02/oracle/VIS/inst/apps/VIS_vision/appl/fnd/12.0.0/secure



Then click next button and click finsh.

Step 4:

Right Click on Project (welcomePN) in Application Navigator. Then you will be getting popup menus in window. Click on New then you will be getting New Gallery Dialog box.
Choose ADF Business components categories and Application module in items. Then press OK Button. In next step type your AM name in Name field. Then Finish button.






Click ‘Next button for remaining 3 steps in dialog box’.

STEP 6:

Right click on project in navigator > NEW > OA Components >  Page.

Press OK, then you will get Dialog box for Page.






In Structure Navigator :

Click “region1” and go to property and change name as “LayoutRN” then give title for the window and title for the region in same property window.  Choose AM Definition in the property from dialog box.


Right Click on LayoutRN region and click 'New' and click on region. you will get new region in structure and edit the name of the region as HeaderRN.

Then Right click on headerRN and click the item on popup menu. Change item style in property window as "Submit button". Then change item name as WelcomeBtn and enter prompt as Submit in property.

Then Right Click on HeaderRN, and click "set new contoller" from popup menu and give name for contoller. Then you will get Contoller in window.

Enter following code in processFormRequest method:

   public void processFormRequest(OAPageContext pageContext, OAWebBean webBean)
   {
     super.processFormRequest(pageContext, webBean);
     
     if(pageContext.getParameter("WelcomeBtn")!=null){
         throw new OAException("Welcome", OAException.INFORMATION);
     }
   }


Save project and then right click on page and run. 

Following ouput will be generated when you click the submit button. Message will show as information.