• Welcome to the upgraded JDELIST forum and thank you for your patience.
    Please restrict discussions and issues regarding the new forum software to the Off Topic forum. We will be monitoring that forum for issues.
    If you have trouble logging in, please reset your password using the forgotten password form: https://www.jdelist.com/community/index.php?lost-password/
    If you are unable to successfully reset your password, please contact us: Click here!
    We hope that you enjoy the upgraded forum.
  • Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Promoting BI Publisher objects - gotcha's


Promoting BI Publisher objects - gotcha\'s

1. When BI Publisher (XP...) templates are promoted, the start effective date is not carried forward. So go into the application P95600 on the web client in the environment promoting to, and manually set the start effective date (there's a form/row exit called Effective Dates).

2. Oracle stores the parameter-type definition data in the F95625 and F95626 tables, within the Control Tables; however, Oracle does NOT copy these records when promoting a report definition from one environment to another. So one way or another, you have to copy the Control Table records [I just SQL'd them myself]. If you don't do this, while your reports may generate, any text-substitution in the subject/body, or any data-driven e-mail addresses will be missing.