Its same as second case correct (<?sum(TAX_AMOUNT[../TAX_CODE='SGST'])?> ) ? Only put this sum inside if example <?if:TAX_CODE='SGST'?> <?TAX_CODE?> : <?sum(TAX_AMOUNT[../TAX_CODE='SGST'])?> <?end if?> This will print SGST sum only if SGST tax is there. If still it doesnot fulfill you requirement please provide snapshot of…

In which platform you are running the report?

1. if you have two different tags in XML like CGST and SGST you can directly use <?sum(cgst)?> or <?sum(sgst)?> to get respective amount 2. if you have single TAX_AMOUNT tag in xml and along with that you have one more tag TAX_CODE to identify weather its SGST or CGST you can use below to get sum to get sum of CGST :…

I have not worked in OBIEE much but if I am correct Bursting feature is available there as well

you can generate using Bursting feature. Instead of specifying the delivery channel as email we can specify location where pdf will generate. Use below link for detail https://www.packtpub.com/mapt/book/application_development/9781849687126/6/ch06lvl1sec68/implementing-bi-publisher-burst…

Please find the sample RTF : XML : Sample Output Only thing is you need to arrange/play with table inside table design so that it should look good.

This can happened due to 1. Ouput Post Processor not running : Check with DBAs if its running fine 2. Template Not getting picked up : If template not picked up report generate XML output with warning. Check in the Reuest Option its shows template name or not? 3. Junk character in XML : If XML contains junk character then…

Could you please upload your excel and sample XML please...will try in both Desktop plugins as well as EBS...to find out if its version issue between instances if this is the case we need to raise SR with oracle support to get correct version. But before that we want to sure its version issue

you can use for each group. If first two fields are repetitive then please create group for those to columns and create one group under this group which will hold renaming column

The goal is to have 1 fixed sheed and N dynamic sheet. : What is the issue? we can create one fix sheet and then in new tab we can create sheet for which we can define XDO_SHEET_? and XDO_SHEET_NAME_? property only thing is while defining the name space provide the scope of the field as below

You mean to say you want each supplier site data in different tab? If this is your requirement then you can achieve this by below step 1. Specify XDO_SHEET_? group name. By specifying group on this excel will generate those many tabs. e.g. in your case you want separate tab for each supplier site. 2. Specify…

This can happened due to 1. Ouput Post Processor not running : Check with DBAs if its running fine 2. Template Not getting picked up : If template not picked up report generate XML output with warning. Check in the Reuest Option its shows template name or not? 3. Junk character in XML : If XML contains junk character then…

What is the format of the Program Output? Please check below things. Concurrent Program Short name and Data Template Code should be same to generate XML using RDF report.

What is the template type? word or excel? Word maximum column can be 64 and in excel you can achieve your requirement

If you are in child group want to access the parent group element then you can use <.//ELEMENT_NAME> if you are two level down you can use <../../ELEMENT_NAME> and so on(depends on which level you are) In reverse if you are in Parent tag and want to access the child element then you can specify the number in group e.g.…

Hi , PO Approval workflow trigger same PO Output for Communication program. Request you to Run the PO Output for Communication Program manually for same PO/Supplier by passing below parameter Test : Debug Regenerate Document : Yes 1. Above output will generate the XML file for PO Output for communication. Please review the…

there could be several reason for this 1. Check the mail id is present in the XML file(you can see the program XML by click request id > Diagnostics > View XML) 2. Please check in the Bursting control you have correctly specified the rtf template name with correct application name and locale 3. Check the XML Administration…

May I know which environment it is, Oracle EBS, Fusion or any other?

May i know which platform you are using....is this Oracle EBS?

Normally in PO Print, once you print the PO print flag/Print Date will be Yes so you cannot generate the PO document again, in this case you can re-print the PO. While Submitting the PO Output for communication in the parameter re-generate Yes/No option will be there you can use it to print the PO document again