How to create XML publisher Report with parameter in Oracle apps R12 using PL SQL Approach

Опубликовано: 23 Март 2025
на канале: Subratkumar123

3,277

how to create XML publishers report

1. Using Pl SQL
2. Using Report Buileder

Today we will create XML Publishers report through PL SQL Approach

Lets start
Steps involve

1. Create Procedure
2. Create executables
2. Register as a concurrent IN CONCURRENT FORMAT SHOULD BE XML
3. NEED TO ATTACHED IN REQUEST GROUP -----OM Concurrent Programs
2. Generate XML
3. Open word file and import XML
4. GENERATED RTF

7.
8.Transfer rdf report to top here i am transferring in ONT top Order Managment super user

P_DEPTNO

Error Coming -Routine FDPREP cannot read the
file /oraAS/oracle/VIS/apps/apps_st/appl/ont/12.0.0/reports/US/FIRST_XML_REPORT.rep.

Reason- we have not trasfer our rdf to to report location

location-/oraAS/oracle/VIS/apps/apps_st/appl/ont/12.0.0/reports/US/

9.Create data definitions
10.Create templates
11.Run the report

Finally report competed

Let me know in case any confustion will try to explain

i will attach this step in my blog and link will be share in description

=========================================================================
Error came due to we have not defined input paramater -- p_deptno

I hope you enjoiyed...

Subscribe if you liked..