Gl_id Not Correctly Populated In Event_bal_impacts_t For Adjustments

(Doc ID 567030.1)

Last updated on JUNE 15, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 6.7.0.0.1 and later
Information in this document applies to any platform.
Information in this document applies to any platform.
***Checked for relevance on 19-Oct-2012***
***Checked for relevance on 14-Jan-2014***

Goal

It has updated "G/L ID mappings for pre-rated events" and gl_id are not correctly populated in event_bal_impacts_t table for adjustments except if update manually config_map_glid_t table.

Made the currency adjustment with Customer Center (Credit of 11.223) and can see these data in event_bal_impacts_t table
ACCOUNT_OBJ_ID0 ACCOUNT_OBJ_TYPE ACCOUNT_OBJ_REV AMOUNT GL_ID IMPACT_CATEGORY IMPACT_TYPE ITEM_OBJ_ID0 ITEM_OBJ_TYPE

259974 /account 59 -11,223 0 2 282303 /item/adjustment

Consider the value of the column GL_ID (0)

The problem is:

1) It was not used load_localized_strings since the migration from 6.0.3 to 6.7 and had the following data in config_map_glid_t (as columns REASON_CODE_STR_VER and REASON_CODE_STR_ID did not exist in 6.0.3, it had been valued to NULL during the migration) and now have right GL_ID (105) in event_bal_impacts_t when made currency adjustment with Customer Center.

OBJ_ID0 REC_ID EVENT_TYPE GLID REASON_CODE_STR_VER REASON_CODE_STR_ID
278659 2 /event/billing/adjustment/item 105
278659 3 /event/billing/payment 109
278659 4 /event/billing/reversal 109
278659 5 /event/billing/refund 109
278659 0 /event/billing/adjustment 105
278659 1 /event/billing/adjustment/account 105
278659 6 /event/billing/dispute 107
278659 7 /event/billing/dispute/item 107
278659 8 /event/billing/settlement 108
278659 9 /event/billing/settlement/item 108
278659 10 /event/billing/writeoff 106
278659 11 /event/billing/writeoff/item 106

2) As it needs to add new reason codes used load_localized_strings and got the data with the STR_VER and STR_ID as 100 and 0 because it is the behavior of load_localized_strings.When don't provide a reason ID and string version ID then there is no problem in the adjustment. When make a currency adjustment with Customer Center, GL_ID is always 0 in event_bal_impacts_t .

Solution

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