During the Corrective Invoice Generation (replacement Option), Adjustments Not Coming in /invoice Object (Doc ID 2124888.1)

Last updated on JULY 12, 2023

Applies to:

Goal

On :  7.5.0.12.0 version, Invoicing

When generating invoice for the corrective invoice for the child accounts, adjustments generated by rerating are not coming in the prep invoice or not getting stored into /invoice object.

Due to large number of sub-ordinate accounts under one parent account, the requirement is to generate invoice at child account and parent account separately. The user is generating invoice for sub-ordinate (non-paying) account first and then generating invoice for the parent account. The account hierarchy contains one paying account and many non-paying sub-ordinate accounts.

When allowing system to roll-up sub-ordinate events to the parent (by setting threshold_subords_detail value to 0) and generating corrective invoice for parent account only, in that case all events (original events + adjustment events in PIN_FLD_CORRECTION_INFO) are coming.

To stop roll up of events to the parent account,  entries have been set in bus_params_Invoicing.xml file as:

It is observed that the OOB event search fetches all the rerated events (original event + adjustments), but in fm_inv_make_invoice these adjustments are getting dropped by fm_inv_drop_alloc_items_to_diff_bills() function.

The following commands were used to generate the corrective invoice:
pin_inv_accts -verbose -detail -corr_bills -corr_type replacement -file san
pin_inv_accts -verbose -detail -corr_bills -corr_type replacement -file ban

Is there some other special configuration needs to be done to solve this issue?

Solution

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