Bursting control file pick up a previous variable value. how to solve it?

Fleong

Summary

bursting control file pick up the previous variable value from xml output

Content

I am in EBS 11.5.10.2  using BI publisher 5.  I have a very strange problem. I will upload the bursting control file and XML Output.   I have a  print invoice concurrent program ( in xml output ) it can have multi-invoice and each invoice either email or print.  In the xml output, it have few variable P_S_DELIVERYMETHOD ( either EMAIL or PRINT ), P_S_COPIES ( if PRINT, it has 1 or zero, depend on user decision..  if EMAIL, NULL ), P_S_VALUE { if PRINT, it is the printer name , if EMAIL, it is the email to address }

Here is what I found 

When the first invoice is EMAIL, and second invoice is PRINT, the log file from "XML Publisher report Bursting Program" will be partial failed.  In the log file, the email is success but the print will have "Error!! Could not deliver the output for Delivery channel:null . Please check the Log for error details.."   if I go to invoice XML output.  Find the <P_S_COPIES> for the first email invoice and change from

 <P_S_COPIES></P_S_COPIES>   to <P_S_COPIES>0</P_S_COPIES>, the "XML Publisher report Bursting Program" completed succesfully.  Both email and print are working.

I did put a filter to if the P_S_DELIVERYMETHOD ='PRINT", use the P_S_COPIES.  but that does not seem working as expect.

Any help ?  

 

Version

bi publisher version 5 in EBS 11.5.10.2