My Oracle Support Banner

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 2.8.0.0.0 and later
Information in this document applies to any platform.

Goal

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?
 

Solution

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
Goal
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.