How to Call stored procedure from Forms Personalization

Call PLSQL procedure using form Personalization


1. Personalize the form
2. Create an action of type "BuiltIn"
3. BuiltIn Type for Action should be "Execute a Procedure"
4. Argument should be as below 


='declare
   v_field_value VARCHAR2(200) ;
   begin
       plsql_package.procedurenameHere ;
  end'



or alternately

='declare
p_retcode NUMBER;
P_ERRBUF  VARCHAR2(2000);
begin
XXJG_INVOICE_PRINTING(p_retcode, p_errbuf,'''||${item.INV_SUM_FOLDER.INVOICE_ID.value}||''');
end'


Note the syntax, after =, entire declare begin end is within single quote.
Also, there is no semi colon after "end"

You can pass field values as
'''||${item.BLOCKNAME.FIELDNAME.value}||'''


How to Register Oracle XML Reports

Overview
Oracle XML Publisher is a template-based publishing solution delivered with the Oracle E-Business Suite. It provides a new approach to report design and publishing by integrating familiar desktop word processing tools with existing E-Business Suite data reporting. At runtime, XML Publisher merges the custom templates with the concurrent request data extracts to generate output in PDF, HTML, RTF, EXCEL or even TEXT for use with EFT and EDI transmissions.

                                                                           STEP -1
Navigation: Login into Oracle Applications –> Go to System Administrator  Responsibility –> Concurrent –>   
Executable


FIELDS:

  • Executable: This is User Understandable Name
  • Short Name: This is Unique and for system reference
  • Application: Under which application you want to register this CONA_PO Program
  • Description: Description
  • Execution Method: Based on this field, your file has to be placed in respective directory or database.
  • Execution File Name: This is the actual Report file name.
Action: Save






                                                               STEP -2
 Create a new concurrent program Purchase Order Report that will call the CONA_PO executable declared above. Make sure that output format is placed as XML.


Navigation: Go to Application Developer Responsibility -> Concurrent ->Program


Note: Output Format should by  'XML' for registering the report in XML.

                                                                      STEP -3
Make sure that the report parameter name and the token name are same.





 
                                                                      STEP -4

Add this new concurrent  program to the corresponding responsibility.
Navigation: Go to System Administrator Responsibility ->Security ->Responsibility->Request










                                                                      STEP -5

Next process is to attach the designed rtf file with the XML code. 
In order to attach the rtf file the user should have the responsibility XML Publisher Administrator assigned to him.

First provide the concurrent program short name as Data Definition name in the  template manager and register the template using the data definition created.


Navigation: Go to XML Publisher Administrator->Data Definitions->Create Data definition.





Note: Make sure the code of the data definition must be the same as the short name of the Concurrent Program we registered for the procedure. So that the concurrent manager can retrieve the templates associated with the concurrent program

  

Now create the template with the help of template manager


                                                                      STEP -6
Navigation: Go to XML Publisher Administrator->Templates ->Create Templates.