Oracle Billing Insight v7.0: About the Item Mapping Table

The item mapping table, PRESTG_BRM_ITEM_MASTER_MAP maps Oracle BRM bill items to the usage types and charge types in Oracle Billing Insight. Bill items in Oracle BRM are customizable and vary in different BRM implementations. You populate this table when configuring the pre-staging schema.

Table 3 shows an example of a configured item mapping table, PRESTG_BRM_ITEM_MASTER_MAP.

Table 3. Sample of a Configured Item Mapping Table, PRESTG_BRM_ITEM_MASTER_MAP
BRM_ITEM_TYPE	BRM_ITEM_TAG	CHARGE_TYPE	SUB_ CHARGE_TYPE	USAGE_TYPE	USAGE_TYPE_ CD	STMT_ MONTHLY	STMT_USAGE	STMT_ CREDIT	STMT_TAX	STMT _OTHER
/item/cycle_arrear	cycle_arrear	Null	Null	Null	Null	Y	Null	Null	Null	Null
/item/cycle_forward	cycle_forward	Null	Null	Null	Null	Y	Null	Null	Null	Null
/item/cycle_forward _arrear	cycle_forward _arrear	Null	Null	Null	Null	Y	Null	Null	Null	Null
/item/onetime	purchase	Y	Y	Null	Null	Null	Null	Null	Null	Y
/item/onetime	purchase_account	Y	Y	Null	Null	Null	Null	Null	Null	Y
/item/cycle_tax	cycle_tax	Null	Null	Null	Null	Null	Null	Null	Y	Null
/item/settlement/roaming	roaming_ settlement	Y	Null	Null	Null	Null	Null	Null	Null	Y
/item/late_fee	LateFee	Y	Null	Null	Null	Null	Null	Null	Null	Y
/item/remittance	remittance	Null	Null	Null	Null	Null	Null	Null	Null	Null
/item/incentive	incentive	Null	Null	Null	Null	Null	Null	Null	Null	Null
/item/usage	RELUsage	Null	Null	Y	VOICE	Null	Y	Null	Null	Null
/item/usage	Tokai	Null	Null	Null	Null	Null	Null	Null	Null	Null
/item/misc	miscGPRS	Null	Null	Y	DATA	Null	Y	Null	Null	Null
/item/misc	miscWAP	Null	Null	Y	DATA	Null	Y	Null	Null	Null
/item/misc	miscGSMTEL	Null	Null	Y	VOICE	Null	Y	Null	Null	Null
/item/misc	miscGSMSMS	Null	Null	Y	MESSAGE	Null	Y	Null	Null	Null
/item/misc	miscGSMFAX	Null	Null	Y	VOICE	Null	Y	Null	Null	Null
/item/misc	miscGPRS	Null	Null	Y	DATA	Null	Y	Null	Null	Null
/item/misc	miscGSMDATA	Null	Null	Y	DATA	Null	Y	Null	Null	Null

The STMT_MONTHLY, STMT_USAGE, STMT_CREDIT, STMT_TAX, and STMT_OTHER columns are used to classify the charge, and only one of these columns can be set to Y for an item type.

If the USAGE_TYPE column is set to Y, then the USAGE_TYPE_CD column must be set. Valid values for the USAGE_TYPE_CD column are VOICE, DATA, and MESSAGE.

You can map a bill item to CHARGE_TYPE and SUB_CHARGE_TYPE, if the bill item is not the usage charge or the monthly charge.

If the bill items change in Oracle BRM, you must update the item mapping table and load master data again.

Integration Guide for Oracle Billing Insight		Copyright © 2016, Oracle and/or its affiliates. All rights reserved. Legal Notices.