RE-USE of template ID in another report definition — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

RE-USE of template ID in another report definition

Received Response
31
Views
2
Comments

Summary

RE-USE of template ID in another report definition

Content

I have 2 report definitions to print our diplomas.  One is a batch print (Everything for the specified term) and a reprint - (Prints a single diploma based on Student ID)

These 2 reports actually share the same template ID's - requiring me to only update once - and it changes for both reports.

I don't know how I did it and I need to add a new template ID

I need to add a new template ID, 2 be used by the 2 different reports - but it will not let me enter the same template ID in both reports.

Answers

  • timdexter
    timdexter Rank 6 - Analytics Lead

    Hi Darcy

    Im not entirely clear about the issue. What version/flavor of BI Publisher are you using and in what context? Can you expand on the problem a little more?

    Tim

  • Dswope
    Dswope Rank 4 - Community Specialist

    Thanks Tim - I have my answer.

    The table PSXRPTTMPL  that stores the relationship between BI Pub reports and templates -  has both the report ID and the Template ID as a combination key. Allowing a template to be associated with more than one report.  However, all the PeopleSoft Page code will check against the table to see if that template has ever been entered.  If it has, the PAGE code prevents the template it to be added to the table even if it is associated with a different report ID.

    Some how, about 2 years ago, the PeopleCode did not catch that the template was already in the table, and allowed me to insert it again along with a different report ID.

    According to Oracle, none of their versions have allowed it, and I never should have been able to do it the first time.

    The Unsupported Solution:  Manually insert a row into the table using an existing template ID with a different report ID.   This is not supported, nor recommended by Oracle.

    Darcy