FindBillDetail Activity Function Query Incorrect

(Doc ID 2225480.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Insurance Policy Administration J2EE - Version and later
Information in this document applies to any platform.


On : version, General

Using the FindBillDetail activity function to find the pending bills, and then pass them to the GenerateBill attached rule to generate the bill. When FindBillDetail is run, it does not find the pending bills. Ran a SQL Profiler Trace on the FindBillDetail function and found that it looks for AsBillDetail.Status = NULL, when it should be looking for AsBillDetail.Status = PENDING. When running the same query in SQL Server Management Studio Query Analyzer and substitute PENDING for NULL, get the correct set of pending bill records from AsBillDetail.

FindBillDetail should return the pending bill records from AsBillDetail.

The issue can be reproduced at will with the following steps:
1. Configure a transaction with FindBillDetail
2. Create some pending bills.
3. Execute the transaction.

The issue has the following business impact:
Due to this issue, users cannot go any further on Billing because we cannot generate bills.


Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms