Bursting Process Oracle Fusion

Following are the Methods(DELIVERY CHANNEL) to send invoice using bursting program: EMAIL, FAX, FTP, SFTP, FILE, PRINT & WEBDEV.

This is brief explanaition for more detailed blog :
1. Create Data Model Exmple Query: select b.trx_number, a.customer_trx_id, b.term_id, b.org_id, b.batch_id, b.status_trx, b.application_id FROM ra_customer_trx_lines_all a, ra_customer_trx_all b WHERE a.customer_trx_id= b.customer_trx_id AND a.customer_trx_id in (1002,1) 2. Create Layout and Template. 3. Run The Report and check it is generating output properly or not. 4. Go to Bursting in left corner of data model screen, add new & give required details.


5. In Split by field & Delivered by field select the value(Column) on which you have to split the PDF to send the output (like customer_name, transaction_id or Invoice_no). E.g: split by customer_name Split by Transaction no. Invoice 5 Customer1 -- 1 file, 5 Invoice 5 files 3 Customer2 -- 3 file, 3 Invoice 3 files 1 Customer3 -- 1 file, 1 Invoice 1 files 6. In SQL Query section make the query as bellow sample query. SELECT trx_number KEY, -- Split by 'Bursting_Layout' TEMPLATE, -- Catalog :xdo_user_report_locale LOCALE, -- English (es) 'PDF' OUTPUT_FORMAT, -- PDF,HTML,CSV,RTF,EXCEL 'EMAIL' DEL_CHANNEL, -- EMAIL/FAX/FTP/FILE/SFTP/PRINT/WEBDAV 'AR INVOICE_'||trx_number OUTPUT_NAME, -- Output Name ’nareshtech21@gmail.com’ parameter1, -- To 'nareshtech21@gmail.com' parameter2, -- cc ‘nareshtech21@gmail.com’ parameter3, -- From ‘Bursting Program testing’ parameter4, -- Subject ‘Dear Customer PFA Attachment’ parameter5, -- Body ‘true’ parameter6, -- Attachment ‘Reply-To’ parameter7, -- Reply to ‘nareshtech21@gmail.com’ parameter8 -- Bcc FROM ( select distinct b.trx_number from ra_customer_trx_lines_all a, ra_customer_trx_all b where a.customer_trx_id= b.customer_trx_id and a.customer_trx_id in (1002,1)) 7. Create the Layout for the Data Model. 8. In Layout properties Check the check box Enable Bursting.



9. Run the report by using the scheduler or ESS job & get the output. Notes: 1. General Split by field is equal to Deliver by field. 2. In schedule report -- diagnostic check all check boxes to get the log & the SQL plan etc according to requirement. 3. According to the DELIVERY_CHANNEL(EMAIL,FTP,SFTP,etc) we have to change the Parameters (parameter1,....).
/
to know the default email (from email) or add ftp server name etc follow these steps.
step 1 :


step 2 :

step 3 :

step 4 :

step 5 :


here is your default email use this in from column username@host



-------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------
For FTP bursting follow these Steps.


and use this Server name in parameter1 if you are usign FTP bursting





Comments

Post a Comment

Popular posts from this blog

opaque schema xsd (standard file used in OIC)

 opaque schema xsd (standard file used in OIC) You can use an opaque schema in a stage file action Read File or Write File operation without concern for a schema for the file.   The only condition is that whatever is sent to the opaque element in the opaque schema must be base64-encoded data.  or in other words  it is used to decode base64 files Save the below xml as  opaqueschema.xsd  file and then you can use it in the integration. <?xml version = '1.0' encoding = 'UTF-8'?> <schema targetNamespace="http://xmlns.oracle.com/pcbpel/adapter/opaque/" xmlns="http://www.w3.org/2001/XMLSchema" > <element name="opaqueElement" type="base64Binary" /> </schema>
Read more

DOCUMENTATION ON SANDBOX and PERSONALIZATION

Image
DOCUMENTATION ON SANDBOX PERSONALIZATION Prepared by VAMSI GOVATHOTI ROLE: ORACLE APPS TECHNICAL CONSULTANT Contents A) What is a Sandbox? 2 B) Purpose of Sandboxes 2 C) Key Features 2 D) Why Use Sandboxes? 2 1. How to Customize (Enable or Disable) the Fields/Components in the Sandbox 6 2. How to Enable Direct Access from User Interface (UI) to the Desired Destination using an URL 9 3. How to Create “Role Based Access control” to particular Fields / Components 13 4. ‘More Tasks’ Tab to be renamed to 'Create' on Purchase Requisitions page. 18 5. By using Application Composer making field required in sand box 23 6. Personalization by using application composer 27 A) By using Application Composer creating new field in sand box 27 B) Creating of currency field with fixed choice list 32 C) Creating of currency field with dynamic choice list. 36 7. Creating a button in sand box 40 8. Creating a global function for runtime mess...
Read more

SQL,PLSQL interview practice and DSA patterns

 --=============sql=========================== --How to find duplicate records with the number they are duplicated? select job,count(*) from emp group by job; --Write a Query to select to the Nth highest salary from a table? select min(sal) from (select  sal from emp order by sal desc) where rownum < 3;   --Can Dual table be deleted or dropped or altered or inserted? select round(123.45) from dual; --it cant be deleted or dropped or altered or inserted --List the emps in dept 20 whose sal is > the avg sal of deptno 10 emps? select * from emp where deptno = 20  and sal>(select avg(sal)from emp where deptno = 10); --List the empno, ename, sal, dname of all the 'Mgrs' and 'Analyst' working in NEWYORK, --DALLAS with an exp more than 7 years without receiving the Comma Asc order of Loc? select empno,ename,sal,dname from emp,dept where emp.deptno= dept.deptno and  loc in('NEWYORK', 'DALLAS') and job in ('manager','analyst')and trunc(mo...
Read more