XML Bursting R12

Enable Notification mail server
Navigate system administrator -> Oracle Applications manager -> workflow




Click view details to refer email server inbound/outbound details
Port: 25



Click test mailer and select recipient role to send test message



Pre-requisites
  •          Create data definitions
  •         Create template
  •          Create concurrent program
  •          Assign it to request group

XML BURSTING Control File elements

xapi:request: Give details of how you want to split the XML File
xapi:email: Give details of the Email
·         id: This is a unique value that identifies each group. In our case it is the Supplier Number.
·         reply-to: This is the reply to email address
·         from: This is the from email address that will be used while sending the email
·         port: The port number of the email server. Check with your DBA / System Administrator for this value.
·         server: The details of the email server
xapi:message: Give details of the Email Message
·         subject: Subject of the Email
·         attachment: We are attaching the report output with the email. So the value should be “true”.
·         to: The email id of the Supplier, which is the recipient’s email address.
·         id: This is a unique value that identifies each group. In our case it is the Supplier Number.
xapi:document: Here we define the output document details
·         output-type: The output type of the report output.
·         output: The folder in which the output file will be saved.
xapi:template: Give details of the RTF Template
·         type: Give the details of the Template Type. In our case it is RTF
·         location: Location of the RTF Template.

XML Bursting Control File Definition



To get path of XML template location

select   'xdo://'||
         xtb.application_short_name||'.'||
         xtb.template_code ||'.'||
         xtb.default_language ||'.'||
         xtb.default_territory||
         '/?getSource=true'
  from   apps.xdo_templates_b xtb
 where   xtb.template_code ='DCFAPDN'



Add “afterReport” definition in package specification

 function afterReport (p_conc_request_id in number) return boolean;

Implement “afterReport” function in package body

function afterReport (p_conc_request_id in number) return boolean is
     l_conc_id     NUMBER;
   g_request_id  NUMBER;
  begin

     l_conc_id :=
   fnd_request.submit_request
           (
             application   => 'XDO'
            ,program       => 'XDOBURSTREP'
            ,description   => NULL
            ,start_time    => SYSDATE
            ,sub_request   => FALSE
            ,argument1     => NULL         
            ,argument2     => p_conc_request_id  --Request ID of XML Publisher Report
            ,argument3     => 'Y'           -- debug Flag
           );
           
           dbms_output.put_line (l_conc_id);
   COMMIT;
  
   RETURN (TRUE);
  end afterReport;

Define Default package in data template

<dataTemplate name="DCFAPDN" defaultPackage="DCF_AP_DEBIT_NOTE_REP_PKG" version="1.0">  

Define data trigger

<dataTrigger name="afterReport" source="DCF_AP_DEBIT_NOTE_REP_PKG.afterReport(fnd_global.conc_request_id)"/>

Run concurrent program
It will internally call “Bursting program”

Output of Burst Program

Electronic mail notification

Check electronic notifications are triggered to respective users as per XML Bursting definitions


Comments

Post a Comment

Popular posts from this blog

Query to get FSG report details with row/column set

Below query is to fetch FSG report titles, names, and description along with will give a view to list of row sets and column sets associated with the report. -- FSG REPORTS -- SELECT fst.id_flex_structure_name , R.NAME , R.report_title , R.DESCRIPTION , R.column_set "COLUMN SET" , rw2.structure_id , rw2.DESCRIPTION "COL DESC" , R.row_set "ROW SET" , rw.DESCRIPTION "ROW DESC" , R.report_display_set "DISPLAY SET" , R.content_set "CONTENT SET" , R.row_order "ROW ORDER" , R.rounding_option "RND" , u.user_name , u.DESCRIPTION , R.creation_date FROM rg_reports_v R    , fnd_id_flex_structures_v fst    , fnd_user u    , rg_report_axis_sets_v rw    , rg_report_axis_sets_v rw2 WHERE r.structure_id = fst.id_flex_num AND R.row_set_id     = rw.axis_set_id AND r.column_set_id  = rw2.axis_set_id AND SUBSTR(fst.id_flex_structure_name,1,2) IN ('DC') AND R.created_by     = u.user_id OR...
Read more

Sub Inventory Transfer API.

Image
Sub Inventory transfer is used to move materials from one sub-inventory to another within same organization. This is especially used to 1. Adjust on-hand quantities between sub-inventories 2. Transfer to another sub-inventories for specific business need like additional sales 3. Damages/expiry products can be moved to non-asset sub-inventories to discard it from inventory valuation report and so on., Key elements 1. From sub inventory 2. To sub inventory 3. Organization 4. Inventory item 5. Transact quantity 6. Transact unit of measure 7. Transaction type 8. Transaction action 9. Transact Reference 10. Transact date 11. Lot Number Open Interfaces mtl_transactions_interface - is used to populate sub inventory transfer details mtl_transaction_lots_interface - is used to populate lot details for particular sub inventory transfer Base Tables mtl_material_transactions - is used to get all type of material transactions like sub-inventory transfer, inter-org tra...
Read more

How to use lexical parameters in Data template (XML document) R12

Lexical parameters can be added in data definition using &variable name This is flexible variable string where you can execute runtime conditions based on user-inputs Example 1. Append &gc_journal_filter at the end of sql statement 2. Define beforereport function in package signature FUNCTION beforereport RETURN BOOLEAN; 3. Define all the report parameters as a package variable in package signature including lexical parameters 4. Implement beforereport function by building your runtime conditions to be added to SQL statements  FUNCTION beforereport RETURN BOOLEAN IS  BEGIN          IF p_journal_source IS NULL THEN       gc_journal_filter := ' AND jh.je_source IN (''AutoCopy'',''Manual'')';     END IF;          IF p_journal_category IS NULL THEN       gc_journal_filter := 'AND jh.je_category IN (''Other'') ';     E...
Read more