My Oracle Support Banner

Status Of "XML Publisher Report Bursting Program" Is Error When Filter Condition Is False In Bursting Control File. (Doc ID 3049931.1)

Last updated on OCTOBER 02, 2024

Applies to:

BI Publisher (formerly XML Publisher) - Version 12.2 to 12.2 [Release 12.2]
Information in this document applies to any platform.

Symptoms

1. The requirement is to send invoice transactions via Xml Publisher Burst Report.

2. Written code in bursting control file.

a. Included a condition.

b. If the condition is True, burst email should be triggered with appropriate transactions.

It is working as expected.

c. If the condition is False, bursting Process should ignore it and need to validate the next transaction as per the code written in loop and mail to be delivered as usual

It is not working as expected, bursting Control program getting completed in error when the condition is false and it is not checking subsequent transactions.

Log file showing the below details:

[STATEMENT] Filter: .//G_INVOICE[CP_MAIL_YES_NO=0] Status : false
[STATEMENT] Filter: .//G_INVOICE[CP_MAIL_YES_NO=0] Status : false

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.