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

Last updated on NOVEMBER 01, 2023

Applies to:

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

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