{"id":353,"date":"2011-03-25T12:47:34","date_gmt":"2011-03-25T07:17:34","guid":{"rendered":"http:\/\/sendyoursmiles.com\/articles\/delimited-report-output-using-report-builder"},"modified":"2011-03-25T12:47:34","modified_gmt":"2011-03-25T07:17:34","slug":"delimited-report-output-using-report-builder","status":"publish","type":"post","link":"https:\/\/erpschools.com\/erps\/articles\/delimited-report-output-using-report-builder","title":{"rendered":"Delimited Report Output using Report Builder"},"content":{"rendered":"<p><strong>Overview:<br \/>\n<\/strong><\/p>\n<p>In this tutorial, we will see how to customize the existing standard Oracle report to get a delimited output file instead of the regular layout. Most business users prefer delimited report output as it can easily be imported into Excel where they can manipulate and perform calculations on the data easily.<\/p>\n<p>Report Builder is the tool used to develop\/customize Oracle reports. Before getting into the details, I would like to give an overview about Report Builder.<\/p>\n<p><strong>Main Components of a Report Builder<\/strong>:<\/p>\n<p>Below is the snapshot of the Object navigator when you open a report in Report Builder. Some important components are Data Model, Layout Model, Parameter form, Triggers. Let&#8217;s discuss about each one of them in detail.<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/032511_1246_DelimitedRe1.png\" alt=\"\" \/><\/p>\n<ul>\n<li>\n<div><span style=\"text-decoration: underline;\">Data Model:<br \/>\n<\/span><\/div>\n<p>The Data Model is a work area in which you define what data to retrieve when the report is submitted.  You create and define queries, groups, columns, parameters, and links which are called data model objects to determine what data needs to be extracted from the database as part of a report.<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/032511_1246_DelimitedRe2.png\" alt=\"\" \/><\/p>\n<p><span style=\"text-decoration: underline;\">Tool Palette in Data Model view<\/span>:<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/032511_1246_DelimitedRe3.png\" alt=\"\" \/><\/p>\n<p>&nbsp;<\/p>\n<div>\n<table style=\"border-collapse: collapse;\" border=\"0\">\n<colgroup>\n<col style=\"width: 37px;\"><\/col>\n<col style=\"width: 54px;\"><\/col>\n<col style=\"width: 132px;\"><\/col>\n<col style=\"width: 415px;\"><\/col>\n<\/colgroup>\n<tbody>\n<tr style=\"height: 23px; background: #d9d9d9;\">\n<td style=\"padding-left: 7px; padding-right: 7px; border: solid black 0.5pt;\">#<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: solid black 0.5pt; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">Object<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: solid black 0.5pt; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">Object Name<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: solid black 0.5pt; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">Description<\/td>\n<\/tr>\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: solid black 0.5pt; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">1<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\"><img decoding=\"async\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/032511_1246_DelimitedRe4.png\" alt=\"\" \/><\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">Select<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">To Select objects for an operation<\/td>\n<\/tr>\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: solid black 0.5pt; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">2<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\"><img decoding=\"async\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/032511_1246_DelimitedRe5.png\" alt=\"\" \/><\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">Magnify<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">To Magnify an area<\/td>\n<\/tr>\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: solid black 0.5pt; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">3<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\"><img decoding=\"async\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/032511_1246_DelimitedRe6.png\" alt=\"\" \/><\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">SQL Query<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">To create a new query in the data Model<\/td>\n<\/tr>\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: solid black 0.5pt; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">4<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\"><img decoding=\"async\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/032511_1246_DelimitedRe7.png\" alt=\"\" \/><\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">RefCursor Query<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">To Create a new Ref Cursor query<\/td>\n<\/tr>\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: solid black 0.5pt; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">5<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\"><img decoding=\"async\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/032511_1246_DelimitedRe8.png\" alt=\"\" \/><\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">Summary Column<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">To create a summary column. A summary column performs a computation like sum, average, count, minimum, maximum, % total on another column&#8217;s data.<\/td>\n<\/tr>\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: solid black 0.5pt; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">6<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\"><img decoding=\"async\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/032511_1246_DelimitedRe9.png\" alt=\"\" \/><\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">Formula Column<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">To create a Formula column. A formula column performs a user-defined computation on another column&#8217;s  data<\/td>\n<\/tr>\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: solid black 0.5pt; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">7<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\"><img decoding=\"async\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/032511_1246_DelimitedRe10.png\" alt=\"\" \/><\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">Cross Product<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">To create a Cross Product group<\/td>\n<\/tr>\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: solid black 0.5pt; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">8<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\"><img decoding=\"async\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/032511_1246_DelimitedRe11.png\" alt=\"\" \/><\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">Data Link<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">To create relationship between two queries in the data model<\/td>\n<\/tr>\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: solid black 0.5pt; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">9<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\"><img decoding=\"async\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/032511_1246_DelimitedRe12.png\" alt=\"\" \/><\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">Placeholder Column<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">To Create a Placeholder column. A placeholder is a column for which you set the datatype and value in PL\/SQL that you define.  You can set the value of a placeholder column in the following places:<\/p>\n<p>&#8212; Before Report Trigger, if the placeholder is a report-level column<\/p>\n<p>&#8212; report-level formula column, if the placeholder is a report-level column<\/p>\n<p>&#8211;a formula in the placeholder&#8217;s group or a group below it (the value is set once for each record of the group)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p>&nbsp;<\/p>\n<ul>\n<li>\n<div><span style=\"text-decoration: underline;\">Layout Model:<br \/>\n<\/span><\/div>\n<p>Layout Model is a work area in which you can define the format (using objects like frames, repeating frames, fields, boilerplate, anchors, and Graphics objects) of your report output.  When you run a report, Report Builder uses the Layout Model as a default template for the report output.<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/032511_1246_DelimitedRe13.png\" alt=\"\" \/><\/p>\n<p><span style=\"text-decoration: underline;\">Layout Tool Palette<\/span>:<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/032511_1246_DelimitedRe14.png\" alt=\"\" \/><\/p>\n<div>\n<table style=\"border-collapse: collapse;\" border=\"0\">\n<colgroup>\n<col style=\"width: 43px;\"><\/col>\n<col style=\"width: 54px;\"><\/col>\n<col style=\"width: 96px;\"><\/col>\n<col style=\"width: 480px;\"><\/col>\n<\/colgroup>\n<tbody>\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border: solid black 0.5pt;\">#<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: solid black 0.5pt; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">Object<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: solid black 0.5pt; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">Object Name<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: solid black 0.5pt; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">Description<\/td>\n<\/tr>\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: solid black 0.5pt; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">1<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\"><img decoding=\"async\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/032511_1246_DelimitedRe15.png\" alt=\"\" \/><\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">Select Tool<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">To select one or more objects<\/td>\n<\/tr>\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: solid black 0.5pt; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">2<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\"><img decoding=\"async\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/032511_1246_DelimitedRe16.png\" alt=\"\" \/><\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">Frame Select<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">To select frame or repeating frame and all the objects  within them.<\/td>\n<\/tr>\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: solid black 0.5pt; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">3<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\"><img decoding=\"async\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/032511_1246_DelimitedRe17.png\" alt=\"\" \/><\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">Rotate<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">To rotate Objects<\/td>\n<\/tr>\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: solid black 0.5pt; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">4<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\"><img decoding=\"async\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/032511_1246_DelimitedRe18.png\" alt=\"\" \/><\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">Reshape<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">To change the shape of the objects<\/td>\n<\/tr>\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: solid black 0.5pt; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">5<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\"><img decoding=\"async\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/032511_1246_DelimitedRe19.png\" alt=\"\" \/><\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">Magnify<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">To magnify the area<\/td>\n<\/tr>\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: solid black 0.5pt; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">6<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\"><img decoding=\"async\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/032511_1246_DelimitedRe20.png\" alt=\"\" \/><\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">Line<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">To draw a line<\/td>\n<\/tr>\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: solid black 0.5pt; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">7<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\"><img decoding=\"async\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/032511_1246_DelimitedRe21.png\" alt=\"\" \/><\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">Rectangle<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">To draw a rectangular object<\/td>\n<\/tr>\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: solid black 0.5pt; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">8<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\"><img decoding=\"async\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/032511_1246_DelimitedRe22.png\" alt=\"\" \/><\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">Rounded Rectangle<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">To draw a rounded rectangular object<\/td>\n<\/tr>\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: solid black 0.5pt; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">9<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\"><img decoding=\"async\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/032511_1246_DelimitedRe23.png\" alt=\"\" \/><\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">Ellipse<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">To draw a elliptic object<\/td>\n<\/tr>\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: solid black 0.5pt; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">10<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\"><img decoding=\"async\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/032511_1246_DelimitedRe24.png\" alt=\"\" \/><\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">Arc<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">To draw arc<\/td>\n<\/tr>\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: solid black 0.5pt; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">11<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\"><img decoding=\"async\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/032511_1246_DelimitedRe25.png\" alt=\"\" \/><\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">Polyline<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">To create a Polyline object<\/td>\n<\/tr>\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: solid black 0.5pt; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">12<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\"><img decoding=\"async\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/032511_1246_DelimitedRe26.png\" alt=\"\" \/><\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">Polygon<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">To draw a polygon object<\/td>\n<\/tr>\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: solid black 0.5pt; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">13<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\"><img decoding=\"async\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/032511_1246_DelimitedRe27.png\" alt=\"\" \/><\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">Text<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">To create a Text object<\/td>\n<\/tr>\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: solid black 0.5pt; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">14<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\"><img decoding=\"async\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/032511_1246_DelimitedRe28.png\" alt=\"\" \/><\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">Freehand<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">To create a free form obk=ject<\/td>\n<\/tr>\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: solid black 0.5pt; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">15<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\"><img decoding=\"async\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/032511_1246_DelimitedRe29.png\" alt=\"\" \/><\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">Frame<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">To create a frame. Frames are used to surround other objects and protect them from being overwritten or pushed by other objects<\/td>\n<\/tr>\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: solid black 0.5pt; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">16<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\"><img decoding=\"async\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/032511_1246_DelimitedRe30.png\" alt=\"\" \/><\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">Repeating Frame<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">To create a repeating frame. Repeating frames surround all of the fields that are created for a group&#8217;s columns meaning each repeating frame must be associated with a group created in the Data model.  The repeating frame prints (is fired) once for each record of the group.<\/td>\n<\/tr>\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: solid black 0.5pt; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">17<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\"><img decoding=\"async\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/032511_1246_DelimitedRe31.png\" alt=\"\" \/><\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">Link file<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">To create an object that is read in from file<\/td>\n<\/tr>\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: solid black 0.5pt; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">18<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\"><img decoding=\"async\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/032511_1246_DelimitedRe32.png\" alt=\"\" \/><\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">Field<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">To create a field<\/td>\n<\/tr>\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: solid black 0.5pt; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">19<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\"><img decoding=\"async\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/032511_1246_DelimitedRe33.png\" alt=\"\" \/><\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">Chart<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">To create a Chart<\/td>\n<\/tr>\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: solid black 0.5pt; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">20<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\"><img decoding=\"async\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/032511_1246_DelimitedRe34.png\" alt=\"\" \/><\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">Button<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">To create a button<\/td>\n<\/tr>\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: solid black 0.5pt; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">21<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\"><img decoding=\"async\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/032511_1246_DelimitedRe35.png\" alt=\"\" \/><\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">Anchor<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">To create an anchor between two objects. Since the size of some layout objects may change when the report runs, you need anchors to define where you want objects to appear relative to one another.<\/td>\n<\/tr>\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: solid black 0.5pt; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">22<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\"><img decoding=\"async\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/032511_1246_DelimitedRe36.png\" alt=\"\" \/><\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">OLE2<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top: none; border-left: none; border-bottom: solid black 0.5pt; border-right: solid black 0.5pt;\">To create OLE2 object<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p>&nbsp;<\/p>\n<ul>\n<li><span style=\"text-decoration: underline;\">Parameter Form:<br \/>\n<\/span><\/li>\n<\/ul>\n<p>Parameter Form enables you to define the parameters for your report.<\/p>\n<p><span style=\"text-decoration: underline;\">Tool Palette<\/span>:<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/032511_1246_DelimitedRe37.png\" alt=\"\" \/><\/p>\n<ul>\n<li>\n<div><span style=\"text-decoration: underline;\">Report Triggers:<br \/>\n<\/span><\/div>\n<p>Report triggers execute PL\/SQL functions at specific times during the execution and formatting of your report.  Report Builder has five global report triggers:<\/p>\n<ul>\n<li>\n<div>After Parameter Form trigger:<\/div>\n<p>This trigger fires after the Parameter form is displayed.<\/li>\n<li>\n<div>After Report trigger:<\/div>\n<p>This trigger fires after the report output is displayed. You can use this trigger to delete any temporary values or tables created during the process.<\/li>\n<li>\n<div>Before Parameter Form trigger:<\/div>\n<p>This trigger fires before the Parameter form is displayed.<\/li>\n<li>\n<div>Before Report trigger:<\/div>\n<p>This trigger fires before the reports is executed but after queries are parsed and data is fetched.<\/li>\n<li>\n<div>Between Pages trigger:<\/div>\n<p>This fires before each page of the report is formatted, except the very first page. This can be used to display page totals etc.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><strong>Report Customization steps:<br \/>\n<\/strong><\/p>\n<p>When you have to customize a standard report, it is always advisable not to make changes to the standard report itself, instead rename it to another report and make the changes to it.<\/p>\n<p><span style=\"text-decoration: underline;\">Steps<\/span>:<\/p>\n<ul>\n<li>Download the original rdf from the file system.<\/li>\n<li>Open it in Report builder.<\/li>\n<li>Save it with a different name that meets the client&#8217;s naming conventions.<\/li>\n<li> Make the necessary changes to it.<\/li>\n<li>Save and compile the report.<\/li>\n<li>Move it to the custom top\/reports\/US<\/li>\n<li>Register it as a concurrent program in Oracle Applications under custom application.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><strong>Steps to change the report output to a Pipe delimited output<\/strong>:<\/p>\n<p>The requirement here is to customize the standard &#8220;Receipt Adjustment report&#8221; to get a delimited output file instead of the regular layout. The output file should have header information like shown below on the top of the output page followed by the receipt adjustment data whose fields are separated by &#8216;~&#8217;.<\/p>\n<p><span style=\"font-family: Courier New; font-size: 10pt;\">Vendor Name~PO Number~PO Line~Po Line Description~Item Number~Category~Organization~Ship To Location~Qty Ordered~Net Qty Received~Qty Billed~Qty Accepted~Qty Rejected~Qty Cancelled~Received Qty Corrected~Net Qty RTV~Qty RTV Corrected~Receipt Num~Transaction Date~Transaction Type~Parent Transaction~Transaction amount~Unit<br \/>\n<\/span><\/p>\n<p>&nbsp;<\/p>\n<p>Regular Layout generated by the standard report:<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/032511_1246_DelimitedRe38.png\" alt=\"\" \/><\/p>\n<p>We need Pipe delimited Output file like the below:<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/032511_1246_DelimitedRe39.png\" alt=\"\" \/><\/p>\n<p><span style=\"text-decoration: underline;\">To achieve this:<br \/>\n<\/span><\/p>\n<ul>\n<li>\n<div>We have to get rid of the current layout and create a new layout with 2 objects:<\/div>\n<p style=\"margin-left: 36pt;\">Frame to print the header information.<\/p>\n<p style=\"margin-left: 36pt;\">Repeating Frame to print the data.<\/p>\n<p style=\"margin-left: 36pt;\">&nbsp;<\/p>\n<\/li>\n<li>We need to create a Formula column in the Data model that will get the concurrent program&#8217;s output filename. We will use this file to write our pipe delimited report output to.<\/li>\n<\/ul>\n<p><span style=\"text-decoration: underline;\">Steps<\/span>:<\/p>\n<ol>\n<li>Download the original report POXRVRTN.rdf<\/li>\n<li>Open the report in the Report Builder. File&gt;Open<\/li>\n<li>\n<div>Rename it according Custom naming conventions followed by the client. Here we will rename it to XXERP_POXRVRTN<\/div>\n<p style=\"margin-left: 36pt;\">Tools&gt; Property Palette<\/p>\n<p style=\"margin-left: 36pt;\">Give the name as: XXERP_POXRVRTN<\/p>\n<p style=\"margin-left: 36pt;\">&nbsp;<\/p>\n<\/li>\n<\/ol>\n<p><img decoding=\"async\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/032511_1246_DelimitedRe40.png\" alt=\"\" \/><\/p>\n<ol>\n<li>To Create a Formula column to derive the output file name:<\/li>\n<\/ol>\n<ul style=\"margin-left: 72pt;\">\n<li>Double click on the Data model in the Object Navigator.<\/li>\n<li>Click <img decoding=\"async\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/032511_1246_DelimitedRe41.png\" alt=\"\" \/> in the tool palette<\/li>\n<li>Click and drag a rectangle.<\/li>\n<li>\n<div>Double-click the formula column created in the data model to open up its property palette where you can set its properties.<\/div>\n<p>Name: Give the name as C_OUTPUT_FILE<\/p>\n<p>Data Type: Choose Character<\/p>\n<p>Width:  300<\/p>\n<p>PL\/SQL Formula: Insert the below code which gets the Concurrent program&#8217;s output filename from the database.<\/p>\n<p>function C_OUTPUT_FILEFormula return Char is<\/p>\n<p>v_filename fnd_concurrent_requests.outfile_name%type;<\/p>\n<p>&nbsp;<\/p>\n<p>begin<\/p>\n<p>SELECT outfile_name<\/p>\n<p>INTO   v_filename<\/p>\n<p>FROM   fnd_concurrent_requests<\/p>\n<p>WHERE  request_id = :P_CONC_REQUEST_ID;<\/p>\n<p>RETURN(v_filename);<\/p>\n<p>exception<\/p>\n<p>when others then<\/p>\n<p>RETURN(null);<\/p>\n<p>end;<\/p>\n<p>&nbsp;<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/032511_1246_DelimitedRe42.png\" alt=\"\" \/><\/p>\n<p><img decoding=\"async\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/032511_1246_DelimitedRe43.png\" alt=\"\" \/><img decoding=\"async\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/032511_1246_DelimitedRe44.png\" alt=\"\" \/><\/p>\n<ol>\n<li>Double click on the Layout model in the Object Navigator.<\/li>\n<li>Remove all the objects placed in the layout model except &#8220;No Data Found&#8221; Object.<\/li>\n<li>\n<div>Place a Frame and a repeating frame one below the other as shown below.<\/div>\n<p>&nbsp;<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/032511_1246_DelimitedRe45.png\" alt=\"\" \/><\/li>\n<\/ol>\n<ul>\n<li>\n<div>To place a frame in the Layout:<\/div>\n<p style=\"margin-left: 36pt;\">Click <img decoding=\"async\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/032511_1246_DelimitedRe46.png\" alt=\"\" \/> in the tool palette.<\/p>\n<p style=\"margin-left: 36pt;\">Click and drag a rectangle.<\/p>\n<p style=\"margin-left: 36pt;\">Double-click the frame object in the layout to open up its property palette where you can set its properties.<\/p>\n<p style=\"margin-left: 36pt;\">&nbsp;<\/p>\n<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/032511_1246_DelimitedRe47.png\" alt=\"\" \/><\/p>\n<p style=\"margin-left: 36pt;\">Some important properties are discussed here.<\/p>\n<ul style=\"margin-left: 90pt;\">\n<li>Name: Rename it to whatever you want.<\/li>\n<li>\n<div>Vertical and Horizontal Elasticity: For frames and repeating frames, elasticity defines whether the size of the frame or repeating frame should vary with the objects inside of it.<\/div>\n<p>&nbsp;<\/li>\n<\/ul>\n<p>Possible Values that you can enter are Contract, Expand, Fixed, and Variable.<\/p>\n<ul style=\"margin-left: 108pt;\">\n<li>Contract means the vertical (for vertical elasticity) or horizontal (for horizontal elasticity) size of the object decreases, if the formatted objects or data within it are short (for vertical elasticity) or less wide (for horizontal elasticity) enough, but it cannot increase to a height (for vertical elasticity) or width (for horizontal elasticity) greater than that shown in the Report Editor.<\/li>\n<li>Expand Means the vertical (for vertical elasticity) or horizontal (for horizontal elasticity) size of the object increases, if the formatted objects or data within it are tall or more wide enough, but it cannot decrease to a height or width less than that shown in the Report Editor.<\/li>\n<li>Fixed Means the height or width of the object is the same on each logical page, regardless of the size of the objects or data within it. Truncation of data may occur.<\/li>\n<li>\n<div>Variable Means the object may expand or contract vertically to accommodate the objects or data within it (with no extra space), which means the height or width shown in the Report Editor has no effect on the object&#8217;s height or width at runtime.<\/div>\n<p>&nbsp;<\/li>\n<\/ul>\n<ul>\n<li>\n<div>To place a repeating frame in the Layout:<\/div>\n<p style=\"margin-left: 36pt;\">Click  <img decoding=\"async\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/032511_1246_DelimitedRe48.png\" alt=\"\" \/> in the tool palette.<\/p>\n<p style=\"margin-left: 36pt;\">Click and drag a rectangle.<\/p>\n<p style=\"margin-left: 36pt;\">Double Click on Repeating Frame to open up the property palette and rename it. Every repeating frame must be associated with a group defined in the Data model.<\/p>\n<p style=\"margin-left: 36pt;\">Here give the Source as &#8220;G_shipment_lines&#8221;.<\/p>\n<p style=\"margin-left: 36pt;\">Set the Vertical and horizontal elasticity to the required.<\/p>\n<p style=\"margin-left: 36pt;\">&nbsp;<\/p>\n<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/032511_1246_DelimitedRe49.png\" alt=\"\" \/><\/p>\n<ol>\n<li>\n<div>To print a pipe delimited text in the output file, we will use a format trigger on the frame and repeating frame.<\/div>\n<p>A <strong>format trigger<\/strong> is a PL\/SQL function executed before an object is formatted.  This function must return a Boolean value (TRUE or FALSE).  Depending on whether the function returns TRUE or FALSE, the current instance of the object is included or excluded from the report output. Format trigger can be used to highlight a value, for suppressing values and labels.<\/li>\n<\/ol>\n<p>In the property palette of the Frame, under Advanced Layout section:<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/032511_1246_DelimitedRe50.png\" alt=\"\" \/><br \/>\n<img decoding=\"async\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/032511_1246_DelimitedRe51.png\" alt=\"\" \/><\/p>\n<p style=\"margin-left: 36pt;\">Double Click on the Format Trigger. This opens up a SQL Editor, where you can place the below code to print the header information to the output file.<\/p>\n<p style=\"margin-left: 36pt;\">function  M_SHIPMENT_LINE_HDRFormatTrigg return boolean is<\/p>\n<p style=\"margin-left: 36pt;\"><span style=\"color: #00b0f0;\"><em>&#8211;Variable declaration<br \/>\n<\/em><\/span><\/p>\n<p style=\"margin-left: 36pt;\">cmd_line VARCHAR2(3000);<\/p>\n<p style=\"margin-left: 36pt;\">v_file_name text_io.file_type;<\/p>\n<p style=\"margin-left: 36pt;\">begin<\/p>\n<p style=\"margin-left: 36pt;\"><span style=\"color: #00b0f0;\"><em>&#8211;Setting cmd_line variable to the header info<br \/>\n<\/em><\/span><\/p>\n<p style=\"margin-left: 72pt;\">cmd_line := &#8216;Vendor Name&#8217;||&#8217;~&#8217;||&#8217;PO Number&#8217;||&#8217;~&#8217;||&#8217;PO Line&#8217;||&#8217;~&#8217;||&#8217;Po Line Description&#8217;||&#8217;~&#8217;||&#8217;Item Number&#8217;||&#8217;~&#8217;||&#8217;Category&#8217;||&#8217;~&#8217;||&#8217;Organization&#8217;||&#8217;~&#8217;||&#8217;Ship To Location&#8217;||&#8217;~&#8217;||&#8217;Qty Ordered&#8217;||&#8217;~&#8217;||&#8217;Net Qty Received&#8217;||&#8217;~&#8217;||&#8217;Qty Billed&#8217;||&#8217;~&#8217;||&#8217;Qty Accepted&#8217;||&#8217;~&#8217;||&#8217;Qty Rejected&#8217;||&#8217;~&#8217;||&#8217;Qty Cancelled&#8217;||&#8217;~&#8217;||&#8217;Received Qty Corrected&#8217;||&#8217;~&#8217;||&#8217;Net Qty RTV&#8217;||&#8217;~&#8217;||&#8217;Qty RTV Corrected&#8217;||&#8217;~&#8217;||&#8217;Receipt Num&#8217;||&#8217;~&#8217;||&#8217;Transaction Date&#8217;||&#8217;~&#8217;||&#8217;Transaction Type&#8217;||&#8217;~&#8217;||&#8217;Parent Transaction&#8217;||&#8217;~&#8217;||&#8217;Transaction amount&#8217;||&#8217;~&#8217;||&#8217;Unit&#8217;;<\/p>\n<p style=\"margin-left: 36pt;\"><span style=\"color: #00b0f0;\"><em>&#8211;Opening the concurrent request&#8217;s output file to write the data into it<br \/>\n<\/em><\/span><\/p>\n<p style=\"margin-left: 72pt;\"><span style=\"color: #0070c0;\"><em>&#8211;Always prefix &#8220;:&#8221; with the field,when you refer to a field in the data model like<span style=\"color: #00b0f0;\"><br \/>\n<span style=\"color: #0070c0;\"><strong>:C_OUTPUT_FILE<\/strong><span style=\"color: #00b0f0;\"><br \/>\n<\/span><\/span><\/span><\/em><br \/>\n<\/span><\/p>\n<p style=\"margin-left: 36pt;\">v_file_name := TEXT_IO.FOPEN(:C_OUTPUT_FILE, &#8216;A&#8217;);<\/p>\n<p style=\"margin-left: 36pt;\">IF TEXT_IO.IS_OPEN(v_file_name) THEN<\/p>\n<p style=\"margin-left: 36pt;\">TEXT_IO.PUT_LINE(v_file_name, cmd_line);<\/p>\n<p style=\"margin-left: 36pt;\">END IF;<\/p>\n<p style=\"margin-left: 36pt;\">TEXT_IO.FCLOSE(v_file_name);<\/p>\n<p style=\"margin-left: 36pt;\"><span style=\"color: #00b0f0;\"><em>&#8211;If the return value is true then only this object will be included in the report output<br \/>\n<\/em><\/span><\/p>\n<p style=\"margin-left: 36pt;\">return (TRUE);<\/p>\n<p style=\"margin-left: 36pt;\">end;<\/p>\n<p>&nbsp;<\/p>\n<p style=\"margin-left: 36pt;\">Similarly include the below code in the format trigger of the repeating frame to write the receipt records into the output file.<\/p>\n<p style=\"margin-left: 72pt;\">function R_shipment_linesFormatTrigger return boolean is<\/p>\n<p style=\"margin-left: 72pt;\">cmd_line VARCHAR2(2000);<\/p>\n<p style=\"margin-left: 72pt;\">v_file_name text_io.file_type;<\/p>\n<p style=\"margin-left: 72pt;\">begin<\/p>\n<p style=\"margin-left: 108pt;\">cmd_line := :Source||&#8217;~&#8217;||:Document_Number||&#8217;~&#8217;||:Line||&#8217;~&#8217;||:Description||&#8217;~&#8217;||:C_FLEX_ITEM_DISP||&#8217;~&#8217;||:C_FLEX_CAT_DISP||&#8217;~&#8217;||:Organization_name||&#8217;~&#8217;||:Ship_To_Location||&#8217;~&#8217;\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0  \u00a0\u00a0\u00a0\u00a0          ||:Quantity_Ordered||&#8217;~&#8217;||:C_qty_net_rcvd||&#8217;~&#8217;||:qty_billed||&#8217;~&#8217;||:qty_accepted||&#8217;~&#8217;||:qty_rejected||&#8217;~&#8217;||:qty_cancelled||&#8217;~&#8217;||:C_qty_corrected||&#8217;~&#8217;||:C_qty_rtv_and_corrected||&#8217;~&#8217;||:C_qty_corrected_rtv||&#8217;~&#8217;||:Receipt_Number||&#8217;~&#8217;||:Receipt_Date||&#8217;~&#8217;||:Transaction_Type||&#8217;~&#8217;  \u00a0\u00a0\u00a0\u00a0          ||:Parent_Transaction_Type||&#8217;~&#8217;||:Transaction_Quantity||&#8217;~&#8217;||:Transaction_Unit;<\/p>\n<p style=\"margin-left: 72pt;\">v_file_name := TEXT_IO.FOPEN(:C_OUTPUT_FILE, &#8216;A&#8217;);<\/p>\n<p style=\"margin-left: 72pt;\">IF TEXT_IO.IS_OPEN(v_file_name) THEN<\/p>\n<p style=\"margin-left: 72pt;\">TEXT_IO.PUT_LINE(v_file_name, cmd_line);<\/p>\n<p style=\"margin-left: 72pt;\">END IF;<\/p>\n<p style=\"margin-left: 72pt;\">TEXT_IO.FCLOSE(v_file_name);<\/p>\n<p style=\"margin-left: 72pt;\">return (TRUE);<\/p>\n<p style=\"margin-left: 72pt;\">end;<\/p>\n<p style=\"margin-left: 72pt;\">&nbsp;<\/p>\n<ol>\n<li>Now that the changes are done, save the report.<\/li>\n<li>Connect to the database by navigating to File &gt; Connect<\/li>\n<\/ol>\n<p><img decoding=\"async\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/032511_1246_DelimitedRe52.png\" alt=\"\" \/><\/p>\n<ol>\n<li>\n<div>Then compile the report by navigating to Program&gt; Compile&gt; All.<\/div>\n<p>Errors will be listed if there are any. Correct them and recompile. If there are no errors and the compilation was successful, you will get the below message. Click OK and save again.<\/li>\n<\/ol>\n<p><img decoding=\"async\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/032511_1246_DelimitedRe53.png\" alt=\"\" \/><\/p>\n<ol>\n<li>Now move the report to the Custom top\/Reports\/US<\/li>\n<li>Register it as a concurrent program in Oracle Applications and assign it to the desired responsibilities. Please refer to Concurrent Program registration article for registration details.<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>Overview: In this tutorial, we will see how to customize the existing standard Oracle report to get a delimited output file instead of the regular layout. Most business users prefer delimited report output as it can easily be imported into Excel where they can manipulate and perform calculations on the data easily. Report Builder is [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,16,11],"tags":[],"class_list":["post-353","post","type-post","status-publish","format-standard","hentry","category-articles","category-oracle-reports","category-tools"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>oracle apps report output in excel format<\/title>\n<meta name=\"description\" content=\"Most business users prefer delimited report output as it can easily be imported into Excel where they can manipulate or view data easily.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/erpschools.com\/erps\/articles\/delimited-report-output-using-report-builder\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Prudhvi\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"11 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/erpschools.com\/erps\/articles\/delimited-report-output-using-report-builder#article\",\"isPartOf\":{\"@id\":\"https:\/\/erpschools.com\/erps\/articles\/delimited-report-output-using-report-builder\"},\"author\":{\"name\":\"Prudhvi\",\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/person\/dbed9bb7fb66aa7a700fc565da024512\"},\"headline\":\"Delimited Report Output using Report Builder\",\"datePublished\":\"2011-03-25T07:17:34+00:00\",\"dateModified\":\"2011-03-25T07:17:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/erpschools.com\/erps\/articles\/delimited-report-output-using-report-builder\"},\"wordCount\":2259,\"commentCount\":17,\"publisher\":{\"@id\":\"https:\/\/erpschools.com\/erps\/#organization\"},\"image\":{\"@id\":\"https:\/\/erpschools.com\/erps\/articles\/delimited-report-output-using-report-builder#primaryimage\"},\"thumbnailUrl\":\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/032511_1246_DelimitedRe1.png\",\"articleSection\":[\"Articles\",\"Oracle Reports\",\"Tools\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/erpschools.com\/erps\/articles\/delimited-report-output-using-report-builder#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/erpschools.com\/erps\/articles\/delimited-report-output-using-report-builder\",\"url\":\"https:\/\/erpschools.com\/erps\/articles\/delimited-report-output-using-report-builder\",\"name\":\"oracle apps report output in excel format\",\"isPartOf\":{\"@id\":\"https:\/\/erpschools.com\/erps\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/erpschools.com\/erps\/articles\/delimited-report-output-using-report-builder#primaryimage\"},\"image\":{\"@id\":\"https:\/\/erpschools.com\/erps\/articles\/delimited-report-output-using-report-builder#primaryimage\"},\"thumbnailUrl\":\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/032511_1246_DelimitedRe1.png\",\"datePublished\":\"2011-03-25T07:17:34+00:00\",\"dateModified\":\"2011-03-25T07:17:34+00:00\",\"description\":\"Most business users prefer delimited report output as it can easily be imported into Excel where they can manipulate or view data easily.\",\"breadcrumb\":{\"@id\":\"https:\/\/erpschools.com\/erps\/articles\/delimited-report-output-using-report-builder#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/erpschools.com\/erps\/articles\/delimited-report-output-using-report-builder\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/erpschools.com\/erps\/articles\/delimited-report-output-using-report-builder#primaryimage\",\"url\":\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/032511_1246_DelimitedRe1.png\",\"contentUrl\":\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/032511_1246_DelimitedRe1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/erpschools.com\/erps\/articles\/delimited-report-output-using-report-builder#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/erpschools.com\/erps\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Delimited Report Output using Report Builder\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/erpschools.com\/erps\/#website\",\"url\":\"https:\/\/erpschools.com\/erps\/\",\"name\":\"erpSchools\",\"description\":\"Oracle Apps\",\"publisher\":{\"@id\":\"https:\/\/erpschools.com\/erps\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/erpschools.com\/erps\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/erpschools.com\/erps\/#organization\",\"name\":\"erpSchools\",\"url\":\"https:\/\/erpschools.com\/erps\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/erps_logo7.png\",\"contentUrl\":\"https:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/erps_logo7.png\",\"width\":250,\"height\":60,\"caption\":\"erpSchools\"},\"image\":{\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"http:\/\/facebook.com\/erpschools\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/person\/dbed9bb7fb66aa7a700fc565da024512\",\"name\":\"Prudhvi\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/488cec3605845b95cb20e60c67a8f5c7e74b65a305525c8006315d524f120db9?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/488cec3605845b95cb20e60c67a8f5c7e74b65a305525c8006315d524f120db9?s=96&d=blank&r=g\",\"caption\":\"Prudhvi\"},\"sameAs\":[\"http:\/\/www.erpschools.com\"],\"url\":\"https:\/\/erpschools.com\/erps\/author\/prudhvi\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"oracle apps report output in excel format","description":"Most business users prefer delimited report output as it can easily be imported into Excel where they can manipulate or view data easily.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/erpschools.com\/erps\/articles\/delimited-report-output-using-report-builder","twitter_misc":{"Written by":"Prudhvi","Est. reading time":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/erpschools.com\/erps\/articles\/delimited-report-output-using-report-builder#article","isPartOf":{"@id":"https:\/\/erpschools.com\/erps\/articles\/delimited-report-output-using-report-builder"},"author":{"name":"Prudhvi","@id":"https:\/\/erpschools.com\/erps\/#\/schema\/person\/dbed9bb7fb66aa7a700fc565da024512"},"headline":"Delimited Report Output using Report Builder","datePublished":"2011-03-25T07:17:34+00:00","dateModified":"2011-03-25T07:17:34+00:00","mainEntityOfPage":{"@id":"https:\/\/erpschools.com\/erps\/articles\/delimited-report-output-using-report-builder"},"wordCount":2259,"commentCount":17,"publisher":{"@id":"https:\/\/erpschools.com\/erps\/#organization"},"image":{"@id":"https:\/\/erpschools.com\/erps\/articles\/delimited-report-output-using-report-builder#primaryimage"},"thumbnailUrl":"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/032511_1246_DelimitedRe1.png","articleSection":["Articles","Oracle Reports","Tools"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/erpschools.com\/erps\/articles\/delimited-report-output-using-report-builder#respond"]}]},{"@type":"WebPage","@id":"https:\/\/erpschools.com\/erps\/articles\/delimited-report-output-using-report-builder","url":"https:\/\/erpschools.com\/erps\/articles\/delimited-report-output-using-report-builder","name":"oracle apps report output in excel format","isPartOf":{"@id":"https:\/\/erpschools.com\/erps\/#website"},"primaryImageOfPage":{"@id":"https:\/\/erpschools.com\/erps\/articles\/delimited-report-output-using-report-builder#primaryimage"},"image":{"@id":"https:\/\/erpschools.com\/erps\/articles\/delimited-report-output-using-report-builder#primaryimage"},"thumbnailUrl":"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/032511_1246_DelimitedRe1.png","datePublished":"2011-03-25T07:17:34+00:00","dateModified":"2011-03-25T07:17:34+00:00","description":"Most business users prefer delimited report output as it can easily be imported into Excel where they can manipulate or view data easily.","breadcrumb":{"@id":"https:\/\/erpschools.com\/erps\/articles\/delimited-report-output-using-report-builder#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/erpschools.com\/erps\/articles\/delimited-report-output-using-report-builder"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/erpschools.com\/erps\/articles\/delimited-report-output-using-report-builder#primaryimage","url":"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/032511_1246_DelimitedRe1.png","contentUrl":"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/032511_1246_DelimitedRe1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/erpschools.com\/erps\/articles\/delimited-report-output-using-report-builder#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/erpschools.com\/erps"},{"@type":"ListItem","position":2,"name":"Delimited Report Output using Report Builder"}]},{"@type":"WebSite","@id":"https:\/\/erpschools.com\/erps\/#website","url":"https:\/\/erpschools.com\/erps\/","name":"erpSchools","description":"Oracle Apps","publisher":{"@id":"https:\/\/erpschools.com\/erps\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/erpschools.com\/erps\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/erpschools.com\/erps\/#organization","name":"erpSchools","url":"https:\/\/erpschools.com\/erps\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/erpschools.com\/erps\/#\/schema\/logo\/image\/","url":"https:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/erps_logo7.png","contentUrl":"https:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/erps_logo7.png","width":250,"height":60,"caption":"erpSchools"},"image":{"@id":"https:\/\/erpschools.com\/erps\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/facebook.com\/erpschools"]},{"@type":"Person","@id":"https:\/\/erpschools.com\/erps\/#\/schema\/person\/dbed9bb7fb66aa7a700fc565da024512","name":"Prudhvi","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/erpschools.com\/erps\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/488cec3605845b95cb20e60c67a8f5c7e74b65a305525c8006315d524f120db9?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/488cec3605845b95cb20e60c67a8f5c7e74b65a305525c8006315d524f120db9?s=96&d=blank&r=g","caption":"Prudhvi"},"sameAs":["http:\/\/www.erpschools.com"],"url":"https:\/\/erpschools.com\/erps\/author\/prudhvi"}]}},"_links":{"self":[{"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/posts\/353","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/comments?post=353"}],"version-history":[{"count":0,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/posts\/353\/revisions"}],"wp:attachment":[{"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/media?parent=353"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/categories?post=353"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/tags?post=353"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}