Complete Course on XML Publisher Reports in Oracle Apps R12
- 4.4
Brief Introduction
XMLreports,Bursting,RTF,Datatemplatemethod,PLSQL method,Dynamiclogo,OA_MEDIA,Barcodes in Oracle Apps Technical R12Description
Course Content :
=============
CLASS1 - First Xml Report
CLASS2 -First Xml Report part 2
CLASS3 - Base Tables for Concurrent program and Data definition and data template
CLASS4 - USER PARAMETERS - BIND AND LEXICAL
CLASS5 -Xml report with Parameters
CLASS6 -triggers (before parameters , after parameters , before report ,between pages , after report)
CLASS7 - User Exits and P_CONC_REQUEST_ID
CLASS8 - Lexical parameter example
CLASS9 -RTF layout creation manually simple example
CLASS10-Po master Detail Report
CLASS11-Formula column and place holder column
CLASS12-Summary column and xdoxslt with minimum and maximum
CLASS13-Fixing the issues in PO Report
CLASS14-Po Report Development - For-each section ,split by page break
CLASS15-CALLTEMPLATE AND CALL@INLINES TAG
class16-conditional statement IF
class17-choose when
class18-Sql and xslt functions in RTF layout
class19-Dynamic Logo Method 1 using Call Template
class20-Dynamic Logo Using OA_MEDIA
Class21-Dyanmic Logo Using Sub template
Class22-Subtemplate With Parameters
Class23-How to create Multi layout and multi language report
class24-How to work with transalations
class25-FND_SUBMIT.REQUEST_SUBMIT
Class26-Realtime example with execution using API FND_SUBMIT.ADD_LAYOUT
Class27-How to limit rows per page Logic
Class28-How to limit rows per page -Execution
Class29-WOrking with barcodes in Xml Publisher reports with execution
class30-XML Bursting with execution -SFTP,FILESYSTEM,EMAIL,FAX,PRINT
class31-Xml Bursting with filters
class32-Working With Data template method - part1
class33-Working with data template method -Master detail report
class34-datatemplatemethod - before and after report triggers and lexical parameters
Also Covered topics on Data Template method and Report Development Using PLSQL
Requirements
- Requirements
- Oracle Apps Technical
- Oracle SQL
- Oracle PLSQL
Knowledge
- Methods to develop Xml Publisher reports in oracle apps r12
- Developement of reports using RDF Method and Datatemplate method and PLSQL method in oracle apps r12
- Base Tables for Oracle Reports in oracle apps r12
- User Parameters in oracle RDF Reports - Lexical and Bind Parameters in oracle apps r12
- Triggers in Oracle RDF and Datatemplate methods - Before and After reports triggers in oracle apps r12
- How to develope Master Detail Report in Xml Publisher Reports in oracle apps r12
- P_CONC_REQUEST_ID In Oracle RDF Reports in oracle apps r12
- Formulae Column and Summary Column and Place Holder Columns With Examples in oracle apps r12
- Tags Related to RTF IF ,call-template,call@inline,for-each,choose etc in oracle apps r12
- limiting lines per page in RTF with execution in oracle apps r12
- subtemplates in oracle Xml reports in oracle apps r12
- Translation in Xml/BI reports in oracle apps r12
- Dynamic Logo - Using Call-template ,OA_MEDIA,Subtemplates with Execution in oracle xml reports in oracle apps r12
- How to submit Conurrent program from back end in oracle apps r12
- FND_SUBMIT ADD_LAYOUT API in oracle xml publisher reports in oracle apps r12
- Working with barcodes in oracle xml reports in oracle apps r12
- XML Bursting with execution - FILESYSTEM,EMAIL,PRINT,FAX,FTP,SFTP in oracle apps r12
- Xml Bursting with Filters in oracle apps r12
- Working with Data template reports in oracle apps r12
- working with lexical parameters in datatemplate method in oracle apps r12
- working with before report and after report triggers in Datatemplate method in oracle apps r12
- Developing reports using PLSQL with execution in oracle apps r12