BI Publisher (MOSC)

MOSC Banner

Cannot Pass Parameters to PL/SQL Package used in a Data Template

edited Jun 26, 2018 2:00PM in BI Publisher (MOSC) 7 commentsAnswered
Hello,

Here is my environment:

EBS: 12.1.3

BI Publisher -- Not sure but what ever comes with it

What I am doing?

I am trying to modify a seeded report AP Trial Balance. This is a BI Publisher report in r12 which uses DT that runs a function as a data trigger.

So, I took seeded package and just recompiled as my own. Took the DT, changed it to refer to that and used the seeded template.

Now the report is not working. But If I change the modified template to use the seeded package it worked fine.

After some debug messages I figured out that the parameters of the concurrent program are not passed to the package/function.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center