ORACLE REPORTS and XML PUBLISHER REPORTS

XML Publisher Reports

Create XML Publisher Report

Password Protect XML Publisher Report

 

Database Trigger in XML Publisher Reports

ERROR: Please make sure JRE version 1.6 or later is installed

"Please make sure JRE version 1.6 or later is installed" Error When Installing BIP Desktop 11.1.1.6 32 bit (Doc ID 1464328.1)

Complete the following steps:

1.Download the offline installer for Java from this page:
http://www.java.com/en/download/manual.jsp
Make sure to download both Windows Offline (32-bit) and Windows Offline (64-bit).

2.In Windows, go to the Control Panel --> Programs and Features.
3.From the list of installed programs, uninstall all Java / JDK programs from your PC (both 32-bit and 64-bit)
4.Reboot the PC
5.Install the Java Windows Offline (32-bit)
6.Install the Java Windows Offline (64-bit)
7.Reboot the PC
8.Install Oracle BI Publisher Desktop
 

WAIT in Concurrent Program

Display Parameter in XML Publisher Report /RTF

 
Enter <?param@begin:P_START_DATE?> into a Text Form Field at the top of the RTF and then create another Text Form Field to display <?$P_START_DATE?>. Update the template in the Apps and then run the concurrent request for the report.

That is what I did to display the parameter P_START_DATE...Hope this helps
 
 
 

PLSQL Trigger in XML Publisher

XML Report Based on Store Procedures

Watermark in XML Template

XML Commands in Template

 Create Fixed Number of Rows in XML Publisher Template

Maximum Number Of Records Per Page Using XML Publisher With RTF Template
XML Publisher - RTF Template - No of Rows Fixed
Limit rows per page
Row Filler
BI Publisher: Conditionally Limiting Rows on a Page
Limiting lines per page and fixed length table in XML/BI Publisher reports
Xml Publisher Basics (Fixed Rows)
Limiting lines per page in BI Publisher
Limit Number Of Records Per Page in XML/BI Publisher
How limit the number of lines in a RTF template body?
Using Conditional Formatting

if Condition/Choose in XML Publisher Template

if - else condition in XML Publisher
IF ELSE’ condition in XML publisher
How to use If and Choose conditional statement in RTF template
If-then-Else Statement in XML Publisher
how to use "not like" operator in BI Publisher
Syntax for IN / NOT IN Commands
BI Publisher IF statement Logical OR syntax in RTF Template
RTF Template- IF Conditions
if-condition-in-rtf-template
Using Conditional Formatting
XSL: nested <?choose?> in RTF Template
Case Statement in RTF (BI Publisher)
How to Hide a column based on condition in rtf Templates

Functions in RTF Template

 REP-1295 - BLOB Issue in XML Report

How to create a XML Publisher report to display BLOB images from an RDF report
Error while generating XML file from rdf report
Getting REP-1295 REP-69, Not Able to Generate XML output Report Contains A Blob (Image) Data Column (Doc ID 809320.1)
Is It Possible to Have Reports to Generate an XML Output For a Report Containing Images? (Doc ID 730583.1)
Forcing BI template to \'anchor\' text in a certain place

Format Mask in XML Publisher Template

Number Formatting in XML Publisher
Formatting Currencies
ORA-01861: literal does not match format string
Formatting Date in Oracle XML(BI) Publisher
Null XML elements and no NVL function BI Publisher RTF? Try xdofx decode
Extended Function Support in RTF Templates
Formatting Date in Oracle XML(BI) Publisher

Following is the workaround to avoid such errors:
1. Define the date parameter as VARCHAR2 in Oracle Procedure.
2. Register Date Parameter in Concurrent Program with Value Set as "FND_STANDARD_DATE".
3. Use FND_DATE.CANONICAL_TO_DATE function to convert varchar2 value to oracle date format & then use this value in your oracle procedure.

Example:

CREATE PROCEDURE XX_TEMP (errbuf      OUT  VARCHAR2
                         ,retcode     OUT  VARCHAR2
                         ,i_from_date  IN  VARCHAR2
                         ,i_to_date    IN  VARCHAR2
                         )
IS
   ld_from_date DATE := FND_DATE.CANONICAL_TO_DATE (i_from_date);
   ld_to_date   DATE := FND_DATE.CANONICAL_TO_DATE (i_to_date);

   /* Use  ld_from_date and ld_to_date instead of i_from_date and i_to_date in procedure */
END XX_TEMP;
/
==================
for-each@section errors if xml tags don't exist with NullPointerException

.XSD Report and Template

XML-2-XSD 2.0
Building XSL templates

Insert Serial Number Directly to RTF Design (XML Publisher)
1. Insert your design and then copy paste any of your field to the front.
2. Then double click your first field and then change the code as
       <xsl:value-of select="position()"/>

Call the Concurrent Program

Submit concurrent program FND_REQUEST.SUBMIT_REQUEST along with XML Publisher layout and printer options
submit-concurrent-program-using layout and concurrent request
FND_REQUEST.SUBMIT_REQUEST:
How to call a Concurrent Program from a Special Menu Item?
PL/SQL Script to Submit a Concurrent Request from backend
How to submitt XMLP Report using a PL/SQL Script

Delete Data Definition and Template

How to Delete XML Publisher Definition and Template
Xml Publisher ( How to Delete Data Definition & Template from Back end )
Script to delete XML publisher Data Definition or Template
rtf template of crosstab with repeating columns

Bursting control files

XML Bursting with Data Templates
Bursting in XML/ BI Publisher
Simple steps to implement XML Bursting Guide
Removing Bursting control files
XML bursting multiple email address
XML Bursting- Mails to multiple mail ids
Using Dynamic XDO Location to Fetch Template in Bursting Control File Generates Exception Error (Doc ID 1186014.1)

SELECT xl.lob_type,
       xl.application_short_name,
       xl.lob_code,
       xl.file_name,
       xl.LANGUAGE,
       xl.territory,
       xl.file_data,
          'xdo://'
       || xl.application_short_name
       || '.'
       || xl.lob_code
       || '.'
       || xl.LANGUAGE
       || '.'
       || xl.territory
       || '/?getSource=true' get_path                                                                                  --
--xxen_util.blob_to_clob(xl.file_data) file_clob
FROM   xdo_lobs xl
 WHERE xl.file_name LIKE '%.rtf'
 AND xl.lob_type IN ('TEMPLATE', 'TEMPLATE_SOURCE')
 AND lob_code = 'XXOEEPLUBBOOKED'

The issue has the following business impact:
Due to this issue, admin people have to hard code the template location in every bursting control file.
<xapi:template type="rtf" location="xdo://TEST.TEST_RAXINV_NEW.en.US/?getSource=true">

XML Bursting Email

  1. DELETE
  2. FROM XDO_LOBS
  3. WHERE LOB_CODE=<DATA_DEFINITION_CODE>
  4. AND LOB_TYPE='BURSTING_FILE' 

Matrix Report

Cross Tab Report

Sum in the XML Publisher

Conditional Totals
Averaging your Totals
How to sum from 2 fields in XML?
Create Running Totals in BI Publisher (XML)
How to sum a calculation column in RTF Template
Extended Function Support in RTF Templates
Forcing BI template to \'anchor\' text in a certain place

Sum IN XML Publisher Data Definition

Number to Words

 

XPATH in XML Publisher

Image Issue in EXCEL Output Format

EXCEL output logo issues in XML Publisher
Company logo URL using {’${OA_MEDIA}/ORACLE_LOGO.gif’}
Media Images can cause hair loss
Dynamic Images

1. Please use the same logo in template as you have copy into Server OA_MEDIA.
2. Width and Height should be the same as on the Server.
3. Logo Always paste into MS Word Header.
example: Paste the url:{'${OA_MEDIA}/logo.png'} into LOGO -> Right Click-> Format Picture -> Alt Text -> Description

 ?? in the bidi issue

<fo:bidi-override direction="ltr" unicode-bidi="bidi-override"><?TRANSACTION_NUMBER?></fo:bidi-override>
 

GL Accounting Flex Field

 

Create Template in XML Template

TEMPLATE Builder for Excel Sheet

 Add BI Publisher in Excel, if Not Visible

1. Open the Excel as "Run as Administrator".
2. File on Right Top Corner ICON-> "Excel Options" Button.
3. Click on "Add-Ins" Left Pane.
4. Open the "Manage" List Box and Click on "COM Add-Ins" Items.
5.Click on Check Box "BI Publisher Template Builder for Excel".
6. Close the Close and Restart Again.
7. "BI Publisher" Menu will Display. 

BI Publisher Disable (Add-Ins...)

1. Open the Excel as "Run as Administrator".
2. File on Right Top Corner ICON-> "Excel Options" Button.
3. Click on "Add-Ins" Left Pane.
4. Check the "Disabled Application Add-Ins" from "Add-Ins" Windows.
5. Open the "Manage" List Box and Click on "Disable Items".
6. Select  the "BI Publisher Template Builder for Excel" Add-Ins and Click on "Enable" Button.
7. Close the Close and Restart Again.
8. "BI Publisher" Menu will Display. 
 

 eTEXT Template

 

 ORACLE Report Builder

 
how to change the report layout in runtime into excel or pdf
Adding GL Accounting Flexfield to Report
Technical Trick: How to add (GL Accounting Flexfield Range) to a customized request on R12 step by step
User Exits in Oracle Reports

DISCOVERER REPORTS

2 comments:

  1. US CPA29 March 2018 at 12:03

    Great Site, The Course were so simple and easy to understand. I would surely recommend it to others who are also looking to learn XML Course for Development.Learn XML Publisher Reports for Beginners Actual cost of this course is 9,999/- But now Kuncham Software Solutions Pvt ltd is giving you Free access. Limited period offer Hurry-up Enroll Now at Udemy.


    Signup and Learn/Download the entire Course

    ReplyDelete
  2. 360 Degree Image Editing Service Are you looking at the ghost mannequin effect service? We provide the invisible man8 November 2021 at 11:36

    requisition Excel Fusion
    Use Simplified Loader Purchase Requisition template provides user-friendly Excel sheets to load Purchase Requisitions to Oracle Fusion. Use Simplified Loader sheets for data migration or BAU. Replace the complex FBDI process with a one-click upload using Simplified Loader. - <a

    href="https://simplifiedloader.com/Catalogue/oracle_fusion_purchase_requisition_excelhttps://simplifiedloader.com/Catalogue/oracle_fusion_purchase_requisition_excell</a

    ReplyDelete

Subscribe to: Posts (Atom)