This appendix covers the following topics:
Oracle Product Hub provides the following seeded library containing attribute groups, attributes, and value sets. For more information about using data libraries, see: Using Seeded Attributes. The attribute groups in this library are assigned to the Item Revision business entity.
This library is not automatically installed. The system administrator must perform the following steps to upload the library after installing the Oracle Product Hub for Communications patch.
Installing the Library
Upload the value set library file. This file contains all of the value sets required by the Sellable Product Information Library, as well as those required by all other Oracle Product Hub for Communications libraries.
Tip: You only need to install this file once for all Oracle Product Hub for Communications libraries.
Filename
$EGO_TOP/patch/115/import/US/egomstrlibvs.ldt
Command
FNDLOAD apps 0 Y UPLOAD $EGO_TOP/patch/115/import/egoefval.lct $EGO_TOP/patch/115/import/US/egomstrlibvs.ldt ORACLE Password:
Upload the Sellable Product Information Library file.
Filename
$EGO_TOP/patch/115/import/US/egospilib.ldt
Command
FNDLOAD apps 0 Y UPLOAD $EGO_TOP/patch/115/import/egoefag.lct $EGO_TOP/patch/115/import/US/egospilib.ldt ORACLE Password:
| Attribute Group Display Name (Internal Name) Behavior |
Attribute Display Name (Internal Name) | Attribute Description | Value Set |
|---|---|---|---|
| Additional Billing Information (Additional_Billing_Information) Single-Row Assigned to the Item business entity. |
Billing Entity Type (Billing_Entity_Type) | Identifies the type of billing product. Use the DVM for mapping these values.
Note: You can use the billing type instead and ignore this attribute during integration. |
Billing_Type |
| - | Billing Service Type (Billing_Service_Type) | The service type associated with the product. It represents the service the product belongs to. | BRM_PERMITTED |
| Additional Entity Details (Additional_Entity_Details) Single-Row Assigned to the Item business entity. |
Effective Start Date (Effective_Start_Date) | Start date of the product. | EGO_Lib_NumVS |
| - | Effective End Date (Effective_End_Date) | End date of the product. | EGO_Lib_NumVS |
| - | Internal Reference Code (Internal_Reference_Code) | Alphanumeric value that identifies the item. The value is immutable (does not change across instances). No validations or constraints are provided. Users must define rules and constraints to ensure uniqueness and to prevent updates. | - |
| - | Entity Type (Entity_Type) | - | Entity_Type |
| Product Details: Definitions (Prod_Details_Definitions) Single-Row |
Price Type (Price_Type) | Select the price type. The options are:
|
Price_Type |
| - | Structure Type (Structure_Type) | Indicates whether an item has children or a bundle. Sample values include Bundle, None, Customizable. | Structure_Type |
| - | Sales Product (Sales_ Product) | Indicates that the item can be used for order type 'SalesOrder'. | EGO_Lib_Yes_No |
| - | Service Product (Service_Product) | Indicates whether the item is a service. | EGO_Lib_Yes_No |
| - | Product Level (Product_Level) | The numeric product level in the product hierarchy. | EGO_Lib_NumVS |
| - | Format (Format) | For training products, select a training format such as Instructor led or Web-based. | Format |
| - | Parent Product (Parent_Product) | Select the parent product. This field is for information only. It is not used for creating or managing products with components. | Parent_Product |
| - | Quantity (Quantity) | The number of items in the unit of measure. | EGO_Lib_PosNumVS |
| - | Pricing Code (Pricing_Code) | Identifies the type of pricing associated with the item. None = No pricing associated, Standard = Simple pricing model associated, Billing = BRM pricing model. | Pricing_Code |
| - | Product Line (Product_Line) | The product belongs to this product line. | Object_Product_Line |
| - | Check Eligibility (Check_Eligibility) | System check customers' eligibility to buy the product. Used by Siebel. | EGO_Lib_Yes_No |
| - | Inclusive Eligibility (Inclusive_Eligibility) | Used to ensure that the Eligibility matrix is validated when a quote or an order is created for the item. | EGO_Lib_Yes_No |
| Product Details: Marketing (Product_Details_Marketing) Single-Row |
Targeted Industry (Targeted_Industry) | The industry to target with this product. | Targeted_Industry |
| - | Targeted Min Age (Targeted_Min_Age) | The minimum age of buyers for this product. | EGO_Lib_PosNumVS |
| - | Targeted Max Age (Targeted_Max_Age) | The maximum age of buyers for this product. | EGO_Lib_PosNumVS |
| - | Targeted Postal Code (Targeted_Postal_Code) | The postal code to target for sales of this product. | - |
| - | Targeted Country (Targeted_Country) | The country where you want to sell this product. | Targeted_Country |
| Product Details: Service (Product_Details_Service) Single-Row |
MTBF (MTBF) | The mean time between failure for the product. | EGO_Lib_PosNumVS |
| - | MTTR (MTTR) | The mean time to repair the product. | EGO_Lib_PosNumVS |
| - | Field Replacable (Field_Replaceable) | Indicates if this is a field-replaceable unit. | EGO_Lib_Yes_No |
| - | Return if Defective (Return_if_Defective) | Indicates if a defective product should be returned by the customer when a replacement is shipped. | EGO_Lib_Yes_No |
| - | Tool (Tool) | Indicates if this product is a tool, such as one used by field service engineers. | EGO_Lib_Yes_No |
| Product Details: Logistics (Product_Details_Logistics) Single-Row |
Vendor Part Number (Vendor_Part_Number) | The vendor's part number for this product. | Vendor_Part_Number |
| - | Lead Time (Lead_Time) | The standard lead time for ordering the product, measured in weeks. | - |
| - | Ship Carrier (Ship_Carrier) | The name of the shipping carrier for this product. | Ship_Carrier |
| - | Ship Method (Ship_Method) | The shipping mode. For example, air, ground, and so on. | Ship_Method |
| - | Allocate Below Safety (Allocate_Below_Safety) | Indicates if you allow allocation below the safe inventory level of this product. | EGO_Lib_Yes_No |
| - | Auto Substitute (Auto_Substitute) | Indicates if you allow auto-substitutions. | EGO_Lib_Yes_No |
| - | Auto Allocate (Auto_Allocate) | Indicates if you use automatic allocation during the fulfillment process. | EGO_Lib_Yes_No |
| - | Auto Explode (Auto_Explode) | Flag to indicate explosion of child components. | EGO_Lib_Yes_No |
| - | Shipping Required (Shipping_Required) | Flag to indicate if shipping is required. | EGO_Lib_Yes_No |
| Product Details: Additional Information (Prod_Detail_More_Info) Single-Row |
Division Code SAP (Division_Code_SAP) | User defined access code for the item. | - |
| - | Global Product Identifier (Global_Product_Identifier) | A unique product identification string. This field is intended for use by integrators who need to move product information between applications. | - |
| - | Serialized (Serialized) | Indicates if instances of this product are tracked as serialized assets or simply as quantities of product | EGO_Lib_Yes_No |
| - | Model Product (Model_Product) | This field is obsolete. It is provided as a reference for upgrade users of Configurator. | EGO_Lib_Yes_No |
| - | Tax Subcomponent Flag (Tax_Subcomponent_Flag) | Indicates whether to compute the tax on a bundle by adding up the tax on its components. | EGO_Lib_Yes_No |
| - | Project Resource (Project_Resource) | Indicates if the product is a service for a project. | EGO_Lib_Yes_No |
| - | Compensable (Compensable) | Indicates if sales personnel can receive compensation for selling the product. | EGO_Lib_Yes_No |
| Additional Entity Details (Additional_Entity_Details) Single-Row Defined at the item level. |
Effective Start Date (Effective_Start_Date) | Start date of the product. | - |
| - | Effective End Date (Effective_End_Date) | End date of the product. | - |
| - | Internal Reference Code (Internal_Reference_Code) | Identifies the type of product. This is a user defined list. | - |
| Subject Compatibility Rules (Sub_Compatible_Rule) Multi-Row |
Serial Number (Serial_Number) | Unique identifier of the record in the multi-row. | - |
| - | Subject Product (Subject_Product) | Select the subject product. The default is the product that is selected in the Products list, but you can select any product to replace it. NOTE: Make an entry in only one of the following fields:
|
Product |
| - | Rule Type (Rule_Type) | Select the type of the rule. | Rule_Type |
| - | Object Product (Object_Product) | Select the object product. | Product |
| - | Object Product Line (Object_Product_Line) | Select the object product line. | Object_Product_Line |
| - | Object Product Class (Object_Product_Class | Select the object product class. | Product_Class |
| - | Start Date (Start_Date) | The date when the rule goes into effect. | - |
| - | End Date (End_Date) | The date when the rule is no longer in effect. | - |
| - | Matrix Name (Matrix_Name) | The compatibility group used for grouping this rule. | Matrix_Name |
| Pricing:Simple Price List (Simple_Price_List) Multi-Row |
Price List Name (Price_List_Name) | Name of the price list. | Pricelist_Name |
| - | Currency (Currency) | Currency associated with the price list. | Currency_Code_Selected |
| - | Price Type (Price_Type) | Charge type associated with the price. | Price_Type |
| - | Charge Period (Charge_Period) | Frequency of applying the charge. | Charge_Period |
| List Price (List_Price) | The standard price used for most transactions and the most commonly used target price for price adjustments. | - | |
| - | Promotional Price (Promotional_Price) | If you enter a promotional price, it will be used instead of the list price in all functions that do not explicitly identify the list price as the target price. | - |
| - | Pricing Commit Type (Pricing_Commit_Type) | Field that identifies whether a price override (Committed) or a discount override (Dynamic) is defined for the charge. | Pricing_Commit_Type |
| - | Dynamic Discount Method (Dynamic_Discount_Method) | Whenever a discount override is applied to the charge, this field identifies the type of discount (either 'Percent' or 'Amount'). | Dynamic_Discount_Method |
| - | Service Price Percent (Service_Price_Percent) | A percentage that is used to mark up the price of the service product. | - |
| - | Service Pricing Method (Service_Pricing_Method) | Specify the basis used for calculating the price markup of the service product from the covered product. | Service_Pricing_Method |
| - | Volume Discount (Volume_Discount) | A volume discount is an adjustment to the price of a product based on the quantity of that product that is requested in the quote. For example, a 5% discount when the user requests five to 10 of the item. | Volume_Discount |
| - | Attribute Adjustment (Attribute_Adjustment) | Specifies the attribute pricing table name that provides attribute-based pricing adjustments for this line item product. This attribute pricing table uses attribute data from the Class to which the product belongs. | Attribute_Adjustment |
| - | Maximum Price (Maximum_Price) | Maximum price that can be charged. | - |
| - | Minimum Price (Minimum_Price) | Minimum price that can be charged. | - |
| - | Description (Description) | Description about the charge. | - |
| - | Start Date (Start_Date) | Start date of the price. | - |
| - | End Date (End_Date) | End date of the price. | - |
| Promotion:More Information (Promotion_More_Information) Single-Row |
Promotion Type (Promotion_Type) | The type of the promotion. Options include coupon and bundled promotion. | Promotion_Type |
| - | Score (Score) | The ranking of promotion | Score |
| - | Message (Message) | The message for the promotion. | Message |
| - | Instances (Instances) | The value that specifies how many times a customer is allowed to use this promotion. Options are One Per Customer, One Per Order, and No Limit. | Instances |
| - | Show In Catalog (Show_In_Catalog) | Indicates whether to display the promotion in the product catalogs. | Show In Catalog |
| - | Track As Agreement (Track_As_Agreement) | Indicates whether to track the promotion as an agreement. | Track As Agreement |
| - | Period (Period) | Identifies the duration on the promotion after which the penalty is not applied if it is discontinued. | Period |
| - | Period UOM (Period_UOM) | Unit of measure for the period. | Period UOM |
| - | Grace Period (Grace_Period) | Identifies the grace period before which the promotion can be discontinued without application of the penalty. | Grace Period |
| - | Grace UOM (Grace_UOM) | Unit of measure for the grace period. | Grace UOM |
| Promotion:Charge Plan:Non Recurring Charge Details (Charge_Plan_Non_Recurring) | Non Recurring Charge (Non_Recurring) | The total amount of the nonrecurring charge. | EGO_Lib_NumVS |
| - | NRC Quantity (NRC_Quantity) | Non recurring quantity. | EGO_Lib_PosNumVS |
| Promotion:Charge Plan:Recurring Charge Details (Charge_Plan_Recurring) Single-Row |
Recurring Charge (Recurring) | The schedule for the recurring charge. | EGO_Lib_NumVS |
| - | RC Adjust Amount (RC_Adjust) | The adjustment for a recurring charge. | EGO_Lib_NumVS |
| - | RC Adjust U/M (RC_Adjust_UM) | The time period to which the recurring charge adjustment applies. Options include Per Day and Per Week. | RC_Adjust_UM |
| Promotion:Charge Plan: Charges,Adjustment,Usage Plan Details (Charge_Plan_Adjust_Usage) Single-Row |
Adjust Charge (Adjust_Charge) | A special adjustment to the amount the customer is charged. | EGO_Lib_NumVS |
| - | Adjust Reason (Adjust_Reason) | The reason for the special adjustment. | - |
| Commit (Commit) | Indicates if the user is finished making changes to the record. | EGO_Lib_Yes_No | |
| - | Charge Basis (Charge_Basis) | Specify when the charge for a period is generated. Options include:
|
Charge_Basis |
| Promotion:Commitment:Charges Credits (Commit_Charge_Credits) Multi-Row |
Charge Credits Type (Charge_Credits_Type | Select the penalty. | Charge_Credits_Type |
| - | Amount (Amount) | The amount of the penalty. | EGO_Lib_NumVS |
| - | Plan (Plan) | The name of the charge plan that is associated. The plan defines the charges that must be applied if the commitment for the promotion is terminated. | Plan |
| Promotion:Commitment:Terms (Commitment_Terms) Multi-Row |
Number (Number_Value) | Enter a number to control what order this text will be displayed in within the list of terms. | EGO_Lib_NumVS |
| - | Name (Name) | Name of the commitment term. | - |
| - | Description (Description) | Enter a brief description of the term. | - |
| - | Commitment Terms Type (Commitment_Terms_Type) | Select the type of the term. Options include Standard, Non-Standard, and Special. When you design screens and reports, you can decide to display only terms of certain types. | Term_Type |
| Promotion:Upgrade (Promotion_Upgrade) Multi-Row |
Original Promotion (Original_Promotion) | The earlier promotion that customers can break without penalty. | Promotion |
| - | Commitment Start (Commitment_Start) | Specify when the commitment starts for the new promotion. Options include:
|
Commitment_Start |
| - | Duration (Duration) | Specify the duration of the new promotion. Options include:
|
Duration |
| - | Penalty (Penalty) | The penalty for upgrading from the old to the new promotion, if any. | EGO_Lib_NumVS |
| - | Currency (Currency) | Currency in which the penalty is defined. | - |
| Product Promotions:Components (Prod_Promotions_Components) Single-Row Important: This is a component attribute group. |
Min (Min) | Minimum cardinality for the component of the promotion. | EGO_Lib_PosNumVS |
| - | Max (Max) | Maximum cardinality for the component of the promotion. | EGO_Lib_PosNumVS |
| - | Default (Default_Value) | Default cardinality for the component of the promotion. | EGO_Lib_PosNumVS |
| - | Recommendable (Recommendable) | Select this check box to enable the system to recommend this product promotion to end users when the product exists in a quote or order and is not associated with any other product promotion. | EGO_Lib_Yes_No |
| - | Commitment (Commitment) | Select this check box if the product involves a commitment. | EGO_Lib_Yes_No |
| Component Pricing (Component_Pricing) Single-Row Important: This is a component attribute group. |
Adjustment Type (Adjustment_Type) | Select the type of price adjustment applied to the component product of the promotion. | Adjustment_Type |
| - | Value (Value) | Value of the adjustment. | EGO_Lib_NumVS |
| - | Currency Code (Currency_Code) | Currency associated with the value of the adjustment. | Currency_Code_Selected |
| - | Exchange Date (Exchange_Date) | Exchange date for the currency. | - |
| Version: Structure (Version_Structure) Single-Row Important: This is a component attribute group. |
Relationship Name (Relationship_Name) | Identifies the name of the association of the child to the parent. If not specified then it defaults to product name. | - |
| - | Domain Type (Domain_Type) | Identifies the type of association of the child to the parent. It's a Domain Value Map (DVM) and the values are 'product' and 'class'. | Domain_Type |
| - | Product Class (Product_Class) | If the relationship name is 'Class', this refers to the Class name. | Product_Class |
| - | Default Product (Default_Product) | If the domain type = 'class', then the domain for that child will have more than one product. This represents the default product among the set of products. | Product |
| - | Max Cardinality (Max_Cardinality) | Maximum cardinality of the child in context of the parent. | EGO_Lib_PosNumVS |
| - | Min Cardinality (Min_Cardinality) | Minimum cardinality of the child in context of the parent. | EGO_Lib_PosNumVS |
| - | Default Cardinality (Default_Cardinality) | Default cardinality of the child in context of the parent. | EGO_Lib_PosNumVS |
| Product Promotions: Pricing: Components: Adjustments (Product_Promotion_Com_Adj) Single-Row Important: This is a component attribute group. |
Start Date (Start_Date) | Start date for the adjustment defined for the components of a customizable item included in a promotion. | - |
| - | End Date (End_Date) | End date for the adjustment defined for the components of a customizable item included in a promotion. | - |
| - | Adjustment Type (Adjustment_Type) | Type of adjustment. | - |
| - | Adjustment Value (Adjustment_Value) | Value of the adjustment. | EGO_Lib_NumVS |
| - | Maximum Price (Maximum_Price) | Maximum price that can be charged. | EGO_Lib_PosNumVS |
| - | Minimum Price (Minimum_Price) | Minimum price EGO_Lib_PosNumVSthat can be charged. | - |
Oracle Product Hub provides the following seeded library containing attribute groups, attributes, and value sets. For more information about using data libraries, see: Using Seeded Attributes. The attribute groups in this library are assigned to the Item Revision business entity.
This library is not automatically installed. The system administrator must perform the following steps to upload the library after installing the Oracle Product Hub for Communications patch.
Installing the Library
Upload the value set library file. This file contains all of the value sets required by the Product Management Library, as well as those required by all other Oracle Product Hub for Communications libraries.
Tip: You only need to install this file once for all Oracle Product Hub for Communications libraries.
Filename
$EGO_TOP/patch/115/import/US/egomstrlibvs.ldt
Command
FNDLOAD apps 0 Y UPLOAD $EGO_TOP/patch/115/import/egoefval.lct $EGO_TOP/patch/115/import/US/egomstrlibvs.ldt ORACLE Password:
Upload the Product Management Library file.
Filename
$EGO_TOP/patch/115/import/US/egopmtlib.ldt
Command
FNDLOAD apps 0 Y UPLOAD $EGO_TOP/patch/115/import/egoefag.lct $EGO_TOP/patch/115/import/US/egopmtlib.ldt ORACLE Password:
| Attribute Group Display Name (Internal Name) Behavior |
Attribute Display Name (Internal Name) | Attribute Description | Value Set |
|---|---|---|---|
| Destination System Specification (Destination_Sys_Specification) Multi-Row |
Destination System (Destination_System) | Users can add multiple destination locations. Either PIM ABCS or the Destination ABCS can look at this info and 'ignore' or 'accept' the product. The list of systems is driven by a value set that contains a list of spoke systems. | Destination_System |
| - | Sync Item (Sync_Item) | This defines if the item should be synchronized or not. | EGO_Lib_Yes_No |
| Destination Product Role (Destination_Product_Role) Multi-Row |
Destination System (Destination_System) | Users can add multiple destination locations. Either PIM ABCS or the Destination ABCS can look at this info and 'ignore' or 'accept' the product. The list of systems is driven by a value set that contains a list of spoke systems. | Destination_System |
| - | Role (Role) | The Value Set is driven by Configurator, Billing, Fulfillment, Order Capture etc. (whatever role the product performs in that particular system). | Role |
| - | Selection (Selection) | - | Selection |
| - | Selection Code (Selection_Code) | Customers use this as a discriminator to write code against this Code. NULL by defaut. | Selection_Code |
Oracle Product Hub provides the following seeded library containing attribute groups, attributes, and value sets. For more information about using data libraries, see: Using Seeded Attributes. All seeded attribute groups in this library are assigned to the Item Revision business entity.
This library is not automatically installed. The system administrator must perform the following steps to upload the library after installing the Oracle Product Hub for Communications patch.
Installing the Library
Upload the value set library file. This file contains all of the value sets required by the Communications Services Billing Library, as well as those required by all other Oracle Product Hub for Communications libraries.
Tip: You only need to install this file once for all Oracle Product Hub for Communications libraries.
Filename
$EGO_TOP/patch/115/import/US/egomstrlibvs.ldt
Command
FNDLOAD apps 0 Y UPLOAD $EGO_TOP/patch/115/import/egoefval.lct $EGO_TOP/patch/115/import/US/egomstrlibvs.ldt ORACLE Password:
Upload the Communications Services Billing Library file.
Filename
$EGO_TOP/patch/115/import/US/egocsblib.ldt
Command
FNDLOAD apps 0 Y UPLOAD $EGO_TOP/patch/115/import/egoefag.lct $EGO_TOP/patch/115/import/US/egocsblib.ldt ORACLE Password:
| Attribute Group Display Name (Internal Name) Behavior |
Attribute Display Name (Internal Name) | Attribute Description | Value Set |
|---|---|---|---|
| Billing Products Attributes General (Billing_Prod_Attr_General) Single-Row |
Priority (Priority) | This priority sets the order in which the billing application analyzes products during the rating process. The higher the number, the higher the priority; zero is the lowest priority you can set. | EGO_Lib_NumVS |
| - | Multi-RUM Support (Multi_RUM_Support) | Flag to indicate support of ratable usage metrics. | EGO_Lib_Yes_No |
| - | Provisioning Tag (Provisioning_Tag) | This tag provides a framework to associate extended rating attributes that can enable rating or discounting to vary for a service. | Provisioning_Tag |
| - | Supplier Tax ID (Tax_Supplier) | This is the company or corporate division that sells the product and is responsible for collecting taxes. | Tax_Supplier |
| - | Allow partial purchase (Allow_Partial_Purchase | Indicates whether customers are allowed to purchase a part of the product. For example, if a product gives customers 30 hours of internet connection for $10, you can allow customers to purchase half the amount for half the cost. | EGO_Lib_NumVS |
| - | Purchase Max Quantity (Purchase_Max) | Represents the maximum quantity of the product that can be purchased per transaction. | EGO_Lib_PosNumVS |
| - | Purchase Min Quantity (Purchase_Min) | Represents the minimum quantity of the product that can be purchased per transaction. | EGO_Lib_PosNumVS |
| - | Ownership Max Qty (Own_Max) | Represents the maximum quantity of the product that can be owned by the customer at any given point of time. | EGO_Lib_PosNumVS |
| - | Ownership Min Qty (Own_Min) | Represents the minimum quantity of the product that can be owned by the customer at any given point of time. | EGO_Lib_PosNumVS |
| Billing Products Event Map (Billing_Products_ Event_Map) Multi-Row |
Dynamic Discount Method (Dynamic_Discount_Method) | Whenever a discount override is applied to the charge, the field identifies the type of discount, such as 'Percent' 'Amount'. | Dynamic_Discount_Method |
| - | Event (Event) | The name of the billable event, or charges modeled as the event in the billing application. | Event |
| - | Measured By (Measured_By) | Represents the ratable usage metric (RUM). RUM defines the quantity measured and the units used. | Measured_By |
| - | Pricing Commit Type (Pricing_Commit_Ty pe) | Field that identifies whether a discount override or a price override is defined for the charge. | Pricing_Commit_Type |
| Rate Plan Structure (Rate_Plan_Structure) | This identifies the type of rate plan associated with the product. Single rate plan - Only one rate plan can be associated with the event. Rate Plan Selector – More than one rate plan can be selected from a selector. Custom event analysis – custom rate plan. | BRM_Rate_Plan_Structure | |
| Rate Plan ID (Rate_Plan_ID) | The identifier of the rate plan associated with the billable event. | - | |
| Rate Plan (Rate_Plan) Multi-Row |
Price List Name (Pricelist_Name) | Price list associated with Rate plan of an item. | Pricelist_Name |
| - | Currency (Currency) | Currency associated with rate plan. | Currency_Code_Selected |
| - | Rate Plan ID (Rate_Plan_ID) | Rate plan unique identifier. | - |
| - | Rate Plan Name (Rate_Plan_Name) | Rate plan name | - |
| - | Rate Plan Description (Rate_Plan_Desc) | Rate Plan Description | - |
| - | Rate Plan Selector ID (Rate_Plan_Selector_ID) | Rate plan selector unique identifier. The rate plan selector provides a framework to define attribute based pricing in billing systems. | - |
| - | Rate Plan Selector Name (Rate_Plan_Selector_Name) | Rate Plan selector name. | - |
| - | Rate Plan Selector Description (Rate_Plan_Selector_Desc) | Rate Plan Selector Description. | - |
| - | Tax When (Tax_When) | Identifies when the tax must be applied. | Tax_When |
| - | (Tax_Code) | This is user defined. Identifies the tax code that is applied. | Tax_Code |
| - | Bill in Advance (Advance_Billing) | Flag to indicate whether advance billing is allowed. | EGO_Lib_Yes_No |
| - | Charge Cycle Fees (Charge_Cycle_Fees | Field to indicate when the monthly charge is billed in advance of the billing cycle. | - |
| - | Charge Cycle Fees UOM (Charge_Cycle_Fee_UOM) | Unit of measure for the 'Charge cycle fees in advance of billing cycle'. | Charge_Cycle_Fee_UOM |
| - | Apply Cycle Fee (Apply_Cycle_Fee) | Flag to indicate that the monthly charge must be applied on the billing date. | EGO_Lib_Yes_No |
| Rate Data (Rate_Data) Multi-Row |
Rate Data ID (Rate_Data_ID) | Rate data unique identifier. | - |
| - | Rate Data Name (Rate_Data_Name) | Rate data name. | - |
| - | Override Credit Limit (Override_Credit_Limit) | Flag to identify whether the credit limit is overridden. A credit limit is the maximum amount of a resource, such as currency or hours, that can accumulate in an account before the customer is prevented from using the service. | EGO_Lib_Yes_No |
| - | Quantity Discount Bracket Basis (Qty_Dis_Bracket_Basis) | You can group charges together into quantity discount brackets to charge different amounts based on quantity. For example, for a telephony service, you could charge 10 cents a minute for the first 120 minutes and 5 cents per minute after 120 minutes. Specifies how the billing application determines the quantities it uses to select the quantity discount bracket. | Qty_Disc_Bracket_Basis |
| - | Quantity Discount Bracket Basis Resources (Qty_Dis_Bracket_Basis_Resource) | If the discount bracket basis is 'resource balance', it identifies the resource. | Qty_Disc_Bracket_Basis_Resource |
| - | Purchase Proration Information (Pur_Proration) | Specify how to charge customers when they purchase the product in the middle of the accounting cycle. | Proration |
| - | Cancel Proration Information (Cancel_Proration) | Specify how to charge customers when they cancel the product in the middle of the accounting cycle. | Proration |
| Balance Impact (Balance_Impact) Multi-Row |
Sequence Number (Seq_Number) | Identifies the sequence of the balance impact. | - |
| - | Rate Plan ID (Rate_Plan_ID) | Rate plan unique identifier. | - |
| - | Rate Tier ID (Tier_ID) | Rate tier unique identifier. | - |
| - | Day Time Range ID (Day_Time_Range_ID) | Day Time Range unique identifier. | - |
| - | Day of the Week Range ID (Day_of_the_Week_Range_ID) | Day of the week unique identifier. | - |
| - | Rate Data ID (Rate_Data_ID) | Rate data unique identifier | - |
| - | Rate Data Minimum (Rate_Data_Min) | Minimum quantity of an event a customer must use for the balance impact or charge to be valid. | - |
| - | Rate Data Maximum (Rate_Data_Max) | Maximum quantity of an event a customer must use for the balance impact or charge to be valid. | - |
| - | Resource ID (Resource_ID) | Identifies the resource that will be charged for the product. For example, dollars, free minutes, etc. | Resource_ID |
| - | GLID (GLID) | An ID assigned to events or charges to record revenue. | GLID |
| - | Impact Category (Impact_Category) | Defines the impact category associated with the rate. | Impact_Category |
| - | Proratable (Proratable) | Flag to identify that the resource is pro-rated. | EGO_Lib_Yes_No |
| - | Discountable (Discountable) | Flag to identify that the resource is discounted. | EGO_Lib_Yes_No |
| - | Sponsorable (Sponsorable) | Enables the resource to be sponsored by another account as part of a sponsor group. In the billing application, you can create sponsor groups where a group owner is billed for certain charges for all of the group's members. | EGO_Lib_Yes_No |
| - | Grantable (Grantable) | Flag to identify that the resource is granted by the balance impact. This will allow specifying the start date and end date on the balance impact. | EGO_Lib_Yes_No |
| - | Fixed Amount (Fixed_Amount) | Represents the fixed amount/price that is applied on the resource that is associated with the billing product. | - |
| - | Scaled Amount (Scaled_Amount) | Represents the amount that can be credited/debited based on rating of the resource. For example, usage of minutes or internet download limits. | - |
| - | Units (Units) | Represents the units for the rating. Usually a picklist [Second, Minute, Kilobyte, Megabyte,…] | Balance_Impact_Units |
| - | Promotional Price (Promotional_Price) | Indicates a promotional or introductory price. | - |
| - | Service Pricing Method (Service_Pricing_Method) | - | Service_Pricing_Method |
| - | Service Price Percent (Service_Price_Percent) | A percentage that is used to mark up the price of the service product. | - |
| - | Start Date (Start_Date) | Start date of the balance impact. | - |
| - | End Date (End_Date) | End date of the balance impact. | - |
| Tier Group (Tier_Group) Multi-Row |
Tier Name (Tier_Name) | Name of the rate tier. | - |
| - | Tier ID (Tier_ID) | Unique identifier of the rate tier. | - |
| - | Effectivity Mode (Effectivity_Mode) | Identifies the effectivity mode associated with the date and time of the tier. 'Absolute' - sets the time period when the rate tier is in effect by specifying dates. 'Relative' -sets the time period when the rate tier is in effect by specifying the number of days relative to the product purchase date. |
Effectivity_Mode |
| - | Start Date Time (Start_Date_Time) | Start date and time of the tier. | - |
| - | End Date Time (End_Date_Time) | End date and time for the tier. | - |
| - | Relative Start (Relative_Start) | Relative start from the product purchase date. | - |
| - | Relative Start UOM (Relative_Start_UOM) |
UOM for the relative start date. | Relative_Start_End_UOM |
| - | Relative End (Relative_End) |
Relative end when the rate tier is no longer active. | - |
| - | Relative End UOM Relative_End_UOM |
UOM for the relative end date. | Relative_Start_End_UOM |
| - | Time Day Restrictions Time_Day_Restrictions |
Indicates whether Day Time restrictions are associated with the Rate Tier.
|
Time_Day_Restrictions |
| Day Time Range (Day_Time_Range) Multi-Row Additional Information: All date and time attributes within this group are time zone independent, meaning there is no need to change the time entered for different time zones. |
Day Time Range ID (Day_Time_Range_ID) | Day and time range unique identifier. | - |
| - | Day Range Name (Day_Range_Name) | Day restrictions name. | - |
| - | Day Range Start Date (Day_Range_Start_Date2) | Starting day. | - |
| - | Day Range End Date (Day_Range_End_Date2) | Ending day. | - |
| - | Use Time of Day Ranges (Use_Time_Day_Ranges) | Select whether or not to use time of day ranges. | EGO_Lib_Yes_No |
| - | Time of Day Range Name (Time_Day_Range_Name) | Time range restrictions name. | - |
| - | Start Time (Start_Time2) | Start time. | - |
| - | End Time (End_Time2) | End time. | - |
| Days of the Week Range (Days_of_the_Week_Range) Multi-Row Additional Information: All date and time attributes within this group are time zone independent, meaning there is no need to change the time entered for different time zones. |
Day of the Week Range ID (Day_of_the_Week_Range_ID) | Day of the week unique identifier. | - |
| - | Day of the Week Range Name (Day_of_the_Week_Range_Name) | Day of the week restrictions name. | - |
| - | Starting Week Day (Start_Day_of_the_Week) | Starting week day. | Days_of_the_Week |
| - | Ending Week Day (End_Day_of_the_Week) | Ending week day. | Days_of_the_Week |
| - | Start Date for the Week (Start_Date_for_the_Week2) | Starting date for the week. | - |
| - | End Date for the Week (End_Date_for_the_Week2) | Ending date for the week. | - |
| - | Use Time in Day of the Week (Use_Time_in_Day_of_the_Week) | Flag to indicate whether time range is specified. | EGO_Lib_Yes_No |
| - | Time in Day of week range name (Time_in_Day_of_week_range_name) | Time range restrictions name. | - |
| - | Start Time in Day of the Week (Start_Time_in_Day_of_the_Week2) | Start time. | - |
| - | End Time in Day of the Week (End_Time_in_Day_of_the_Week2) | End time. | - |
| Billing Discount Attributes (Billing_Discount_Attributes) Single-Row |
Discount Type (Discount_Type) | Identifies the type of discount. It is equivalent to Product Type. Possible values include: Subscription and System. | Discount_Type |
| - | Priority (Priority) | Priority for applying the discount. | EGO_Lib_NumVS |
| - | Multiple Discounts per Event (Multi_Discounts_Per_Event) | Identifies the way discounts are applied, if there are multiple discounts associated per event/charge. Cascading discounts:only apply to parts of the charge packet that have not already been considered for discount. Parallel discounts: Evaluated independently of each other and are always considered. The entire charge packet is discounted, regardless of whether it has been discounted previously. Sequential discounts: Applied as long as a customer charge remains. | Multi_Discounts_Per_Event |
| - | Ownership Maximum Quantity (Ownership_Qty_Maximum) | Total quantity of services/products owned above which the discount does not apply. If set to 0 (default) then it is not used. | EGO_Lib_NumVS |
| - | Ownership Minimum Quantity (Ownership_Qty_Minimum) | Total Quantity of services/products owned below which the discount does not apply. If set to 0 (default) then it is not used. | EGO_Lib_NumVS |
| - | Provisioning Tag (Provisioning_Tag) | Provides a framework to associate extended rating attributes that can enable rating or discounting to vary for a service. | Provisioning_Tag |
| - | Purchase Maximum Quantity (Purchase_Qty_Maximum) | Represents the maximum quantity of the discount that can be purchased per transaction. | EGO_Lib_NumVS |
| - | Purchase Minimum Quantity (Purchase_Qty_Minimum) | Represents the minimum quantity of the discount that can be purchased per transaction. | EGO_Lib_NumVS |
| - | Usage Discount - Valid from middle of the cycle (Usage_Discount_Valid_From) | The field defines validity rules for discounting a usage charge. Identifies the method of handling a discount purchased in the middle of an accounting cycle. Full Discount: Grants the discount for the whole accounting cycle. Prorated Discount: Grants the discount for the portion of the accounting cycle the discount is owned. No Discount: Grants no discount for the accounting cycle. | Usage_Cycle_Discount |
| - | Usage Discount - Valid to middle of the cycle (Usage_Discount_Valid_To) | Identifies the method of handling a discount canceled in the middle of an accounting cycle. | Usage_Cycle_Discount |
| - | Usage Discount - Valid only part of the cycle (Usage_Discount_Valid_Only) | Identifies the method of handling a discount purchased and canceled in the middle of an accounting cycle. | Usage_Cycle_Discount |
| - | Cycle Discount - Valid from middle of the cycle (Cycle_Discount_Valid_From) | The field defines validity rules for discounting a cycle charge. Identifies the method of handling a discount purchased in the middle of an accounting cycle. | Usage_Cycle_Discount |
| - | Cycle Discount - Valid to middle of the cycle (Cycle_Discount_Valid_To) | Identifies the method of handling a discount canceled in the middle of an accounting cycle. | Usage_Cycle_Discount |
| - | Cycle Discount - Valid only part of the cycle (Cycle_Discount_Valid_Only) | Identifies the method of handling a discount purchased and canceled in the middle of an accounting cycle. | Usage_Cycle_Discount |
| Billing Discount Event Map (Billing_Discount_Event_Map) Multi-Row |
Event (Event) | Represents the name of a billable event or charges modeled as an event in the billing application. | Event |
| - | Discount Structure Type (Discount_Structure_Type) | Identifies the type of discount model associated with the product. Discount Model - Only one discount model can be associated with the event. Discount Model Selector– More than one discount model can be selected from a selector. | Discount_Structure_Type |
| - | Model / Model Selector (Model_Selector) | The name of the discount model associated with the discount. | - |
| - | Snowball (Snowball) | If this discount/event combination is a snowball discount. A snowball discount enables distribution of group discounts to group members. | EGO_Lib_Yes_No |
| - | Stop Discounting (Stop_Discounting) | Identifies when to stop applying the discounts. [Never, When inactive, When canceled, When inactive or canceled] | Stop_Discounting |
Oracle Product Hub provides the following seeded library containing attribute groups, attributes, and value sets. For more information about using data libraries, see: Using Seeded Attributes. All seeded attribute groups in this library are assigned to the Item Revision business entity.
This library is not automatically installed. The system administrator must perform the following steps to upload the library after installing the Oracle Product Hub for Communications patch.
Installing the Library
Upload the value set library file. This file contains all of the value sets required by the Communications Product Details Library - Vertical, as well as those required by all other Oracle Product Hub for Communications libraries.
Tip: You only need to install this file once for all Oracle Product Hub for Communications libraries.
Filename
$EGO_TOP/patch/115/import/US/egomstrlibvs.ldt
Command
FNDLOAD apps 0 Y UPLOAD $EGO_TOP/patch/115/import/egoefval.lct $EGO_TOP/patch/115/import/US/egomstrlibvs.ldt ORACLE Password:
Upload the Communications Product Details Library - Vertical file.
Filename
$EGO_TOP/patch/115/import/US/egocpdlib.ldt
Command
FNDLOAD apps 0 Y UPLOAD $EGO_TOP/patch/115/import/egoefag.lct $EGO_TOP/patch/115/import/US/egocpdlib.ldt ORACLE Password:
| Attribute Group Display Name (Internal Name) Behavior |
Attribute Display Name (Internal Name) | Attribute Description | Value Set |
|---|---|---|---|
| Communications:Product Info (Comms_Product_Info) Single-Row |
Network Element Type (Network_Element_Type) | Indicates whether the network item represents a node, connection, or network. | Network_Element |
| - | Compound Product (Compound_Product) | Specifies if this is a networking product which uses compound product validation rules. | EGO_Lib_Yes_No |
| - | Special Rating Max Items (Special_Rating_Max_Items) | Identifies the number of phone numbers allowed for the item when the Item represents a Special rating list. (Friends and Family list) | - |
| - | Special Rating Type (Special_Rating_Type) | Identifies the type of data in the special rating list. | Special_Rating_Type |
| - | Composition Type (Composition_Type) | This is fulfillment dependent information. It identifies what the item is composed of. 1. PartialItem 2. Wholeitem. | Composition_Type |
| - | Success Dependency (Success_dependency) | This field is used during order submission. It declares if all order items must fulfill successfully or else the whole order fails. 1. None 2. All or None. | Success_Dependency |
| - | Billable (Billable) | This flag identifies the purchased products that will be sent to billing applications during order submission. | EGO_Lib_Yes_No |
| - | Service Instance Enabled (Service_Instance_Enabled) | This flag identifies a billing product which is also a bundle. | EGO_Lib_Yes_No |
| - | Fulfillment Item Code (Fulfillment_Item_Code) | This defaults to the ICC associated with the product, but there is a drop down to pick any ICC in the hierarchy. | - |
| - | MSISDN Required (MSISDN_Required) | MSISDN Required | EGO_Lib_Yes_No |