BI Publisher (MOSC)

MOSC Banner

XML DATA TEMPLATE WITH SQL QUERY DATA LINKING ISSUE

edited Sep 20, 2013 5:13AM in BI Publisher (MOSC) 4 commentsAnswered
Hi Gurus,
I have created one xml data defintion file by using sql.

I have two groups where I am fetching customer trx id in main group and passing it to child group. If i query for one customer trx id then it is working fine, but I ran it for range of customer trx id
then only the first only is being used through out rest data. And rest all customer trx id are being ignore.

Here in the main the query i am fetching multiple customer trx ids based on date parameter. And I am passing this customer trx id as bind variable (:CUSTOMER TRX ID)  to the child query. But this data definition is keeping only first value and not at all replacing further values. 

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