Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Complete Course on XML Publisher Reports in Oracle Apps R12
Rating: 4.1 out of 5(702 ratings)
3,852 students

What you'll learn

  • 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

Course content

3 sections • 38 lectures • 17h 50m total length

  • notes0:26
  • Class1 - First Xml Report35:23
  • CLASS2 -First Xml Report part 218:17
  • CLASS3 - Base Tables for Concurrent program and Data definition and datatemplate14:00
  • CLASS4 - USER PARAMETERS - BIND AND LEXICAL19:18

    Understand user parameters in RDF reports by comparing bind parameters (colon) and lexical parameters (ampersand), enabling runtime SQL with dynamic columns, tables, where clauses, and order by.

  • CLASS5 -Xml report with Parameters1:09:48
  • CLASS6 -triggers (before para,after para,before report,between,after report)17:30
  • CLASS7 - User Exits and P_CONC_REQUEST_ID15:05
  • CLASS8 - Lexical parameter example22:15
  • CLASS9 -RTF layout creation manually simple example19:03
  • CLASS10-Po master Detail Report29:05

    Build master-detail reports with XML publisher in Oracle apps r12. Define master and child columns, design the layout and rdf, and test with po numbers and line items.

  • CLASS11-Formula column and place holder column58:29
  • CLASS12-Summary column and xdoxslt with minimum and maximum27:21
  • CLASS13-Fixing the issues in PO Report19:58

    Fix the PO report by hiding organization, making PO number parameters optional, and auto-populating the operating unit with a profile-driven value set; update RDF and test in the concurrent program.

  • CLASS14-Po Report Developement-Foreach section ,split by page break38:32
  • CLASS15-CALLTEMPLATE AND CALL@INLINES TAG27:08
  • class16-conditional statement IF22:54
  • class17-choose when5:15
  • class18-Sql and xslt functions in RTF layout26:27
  • class19-Dynamic Logo Method 1 using Call Template12:25

    Learn how to implement a dynamic logo in Oracle apps XML publisher using the call template method, including defining templates, mapping US and UK logos, and simple conditional logic.

  • class20-Dynamic Logo Using OA_MEDIA47:39
  • Class21-Dyanmic Logo Using Subtemplate20:38
  • Class22-Subtemplate With Parameters12:11
  • Class23-How to create Multi layout and multi language report7:44
  • class24-How to work with transalations21:32
  • class25-FND_SUBMIT.REQUEST_SUBMIT26:46
  • Class26-Realtime example with execution using API FND_SUBMIT.ADD_LAYOUT31:28
  • Class27-How to limit rows per page Logic9:32
  • Class28-How to limit rows perpage -Execution22:25
  • Class29-WOrking with barcodes in Xml Publisher reports with execution21:13

    Learn to render barcodes in XML publisher reports by downloading a code 128 true type font, configuring font paths, updating the config with the font, and testing the output locally.

  • class30-XML Bursting with execution -SFTP,FILESYSTEM,EMAIL,FAX,PRINT1:24:26
  • class31-Xml Bursting with filters43:20

Requirements

  • Oracle Apps Technical
  • Oracle SQL
  • Oracle PLSQL

Description

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

Who this course is for:

  • Oracle Apps Developers
  • those who knows orcle EBS

Report abuse