Billable Charge Template With One Bind Variable Cannot Pass Multiple Values In 'IN' Condition
(Doc ID 2624974.1)
Last updated on JANUARY 03, 2020
Applies to:Oracle Financial Services Revenue Management and Billing - Version 184.108.40.206.0 and later
Information in this document applies to any platform.
Using a Billable charge template which has a single bind variable using the 'IN” operator to accept values. Here is the template SQL:
SELECT BILLABLE_CHG_ID FROM CI_BILL_CHG WHERE TRIM(PRICEITEM_CD) IN (:PRC1);
When we create the Invoice construct using this template this is how the SQL looks in the CI_CONSTRUCT_TEMPLATE :
SELECT BILLABLE_CHG_ID FROM CI_BILL_CHG WHERE TRIM(PRICEITEM_CD) IN (‘00001’,’00002’);
But when the bill is generated on the Invoice Account it only picks up the first input value “00001” and never includes the “00002”.
Why does the application behave this way?
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