I hope you are running XDOLoader from unix...so once you enter password you can use setty command to hide the password charcters e.g. echo -n "Enter Apps schema password: " stty -echo read APPSPWD stty echo echo "" after this your password will store in variable APPSPWD and you can use in your download script

Please don't hard code the password in download script. You can pass is at runtime.

How you are running XDOLoader command? do you have some shell script ?

That's what I was trying to say.... While you pass password to variable PASS in unix use the 'stty' command that will hide your password to display

Ohh sorry for my confusion , I got your issue....but in my point of you we are not exposing password from application , one level down who has access to unix specially DBAs who has unix access can see the password. But still its interesting to investigate and will let you know if find something... You can get more response…

Once you develop any rtf before it produce output it XDO parser converts the rtf into xsl-fo format. That line number comes from that format. To convert your rtf to xsl-fo Go to BI Publshier Add ins > Export > XSL-FO Stylesheet it will produce it text file which is XSL-FO file you can see your line number here.…

Could you please explain the exact requirement why do you need header? basically in rtf we have header that will print in each page of pdf output but in excel there is only one sheet so you can define your header on top...if you can explain the exact requirement of header that will be helpful to assist you further

You can use excel property to protect the excel sheet from update 1. Click the button on the top left corner of current worksheet to select the whole cells. 2. Press the Ctrl + 1 keys simultaneously to open the Format Cells dialog box. In the dialog box, uncheck the Locked box under the Protection tab, and then click the…

I have handle the same thing in rtf and faced some weird behavior sometime. Once I open the header loop before if condition that solve my problem so my structure was <?for-each@section:G_HEADER?> <?if: country = 'US'?> --US HEADER-- <?start:body?> <for-each:G_LINE> --Line Table--<?end for-each?> <?end body?> --US FOOTER--…

is this for-each or for-each@section....please make sure its for-each@section

could u plz upload sample rtf and xml

do you want the image to appear as watermark?

Can you try for-each@section for Invoice then for each for invoice line, so your template design sample will be <?for-each@section:DocumentGroup?> <for-each: linegroup> your line table <?end for-each?> <?end for-each?>

It should work. I have used RPAD in concatenation it worked for me...may I know where you are facing issue? It will be helpful if you can upload sample e-text rtf and xml file

Dear User, I am not sure that training document comes with people soft installation. To get that document you can install , BI Publisher desktop from below link . I will recoment this because it covers all the aspect of rtf design Oracle BI Publisher - Downloads | Oracle Technology Network | Oracle

Hi, If you don't have access to package in related schema it will error out by calling itself , instead of returning -1. Code debugging require to check from where its returning -1

If I understand correctly...you want table heading populate dynamically instead of hard coded heading? If this is the case...you can generate your heading in XML data and use in rtf

Hi, You can use below <?xdoxslt:toWordsAmt(255)?> Regards, Brajesh

More or less its DBA related question...

Once you install BI Publisher desktop...by default it comes with sample rtf with nice explanation. You can go through it, its very helpful. And if you want further detail you can refer BI Publisher Users Guide.