BI Publisher (MOSC)

MOSC Banner

Field in Field?

edited May 15, 2015 8:57AM in BI Publisher (MOSC) 3 commentsAnswered

I am sorry if the title is meaningless, as I don't know how to name my problem.

I am using Oracle EBS r12, XML Publisher

put in simply of what I want to achieve:

let said I have a table with 2 columns: (tableA)

name1greet1
AdamGood Morning, &name1, how are you there?
DavidWelcome to ABC, how are you &name1 ?

and the SQL in XML data definition is simply:

select name1, greet1 from tableA

and in the RTF template, i have these fields:

<?greet1?>

i test it, and it gives me: (which is not I want)

Good Morning, &name1, how are you there?

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