Old Invoice Not Getting Generated After Adding The Fields In Pin_invoice_data_map (Doc ID 1992573.1)

Last updated on JUNE 18, 2017

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.4.0.0.0 to 7.4.0.0.0 [Release 7.4.0]
Information in this document applies to any platform.

Goal

On Oracle Communications Billing and Revenue Management(BRM), 7.4.0.12.0 Version,

Scenario: Old Invoice is not getting generated after adding the fields in pin_invoice_data_map

Added two fields in pin_invoice_data_map (PIN_FLD_DESC and PIN_FLD_IMPACT_CATEGORY) and made the necessary changes in the Pipeline side to flow the data to event_t table for usage event.

But when tried to generate invoice (using pin_inv_accts) of an account which has usage data, before and after making changes (basically it has two different structure of invoice data in event_t table), it is giving below error.

However, new invoices are generated successfully for the customer which has usage data after changes in the event_t table.

Qn: How to generate old invoice data?

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