Batch BCU2 does not copy Foreign Key Characteristic values from the Billable Charge Line Upload Characteristics (CI_B_LN_UP_CHAR) to Billable Charge Line Characteristics (CI_B_LN_CHAR) (Doc ID 2508495.1)

Last updated on SEPTEMBER 28, 2022

Applies to:

Symptoms

On : Customer Care and Billing, BI - Billing

ACTUAL BEHAVIOR
---------------
Batch BCU2 does not copy Foreign Key Characteristic values from the Billable Charge Line Upload Characteristics (CI_B_LN_UP_CHAR) to Billable Charge Line Characteristics (CI_B_LN_CHAR).

EXPECTED BEHAVIOR
-----------------------
BCU1 batch should cover validations when the Billable Charge Line Upload Characteristic is of Foreign Key Value characteristic type.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Set - up three (3) characteristic types (Adhoc Value, Foreign Key Value, Predefined Value). Make sure each one has the same Characteristic Entities
2. Add a Billable Charge Upload Staging record. This will be in Pending status.
3. Add three characteristics on the Line tab, populate values.
4. Submit a BCU1 batch job to perform validations on the Billable Charge Upload Staging records. Then, run BCU2 batch to add billable charges using the data from the staging table.
5. Verify that Billable Charge has been created (ID populated)
6. Check the new Billable Charge. On Line Characteristics tab, verify that the value of the Foreign Key characteristic is missing.

Changes

Cause

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