COGS Recognition Transactions Created in Previous Closed Periods (Doc ID 726857.1)

Last updated on MARCH 01, 2023

Applies to:

Symptoms

During execution of Create Accounting-Cost Management it was observed that there were number of COGS recognition transactions which are getting errored out because they belong to a past GL period which is already closed.

The Sales order issue took place in a past period but the invoicing took place in the current period, however when the collect revenue recognition program and the generate cogs recognition events programs were run the COGS recognition transaction was created in the past period.

This is not happening for all cases and there is no pattern as such for this.

Test Case:

SO issue for item 75*7600258 in 11-Feb-08

The first invoice against this order was on 11-Feb-08
There was another invoice against this order and this was only for the top model of this item on
10-Mar-08

When the Collect Revenue Recognition Program is run through this date and thereafter when the
Generate COGS Recognition program was run why did the COGS transaction get created on 11-Feb-08?

Customer can see similar items with similar invoicing which have the COGS transactions created on
the date of the top model invoice.

-- Steps To Reproduce:
For a item with sales order issue and split invoicing,
1. Run collect revenue recognition program
2. Generate cogs recognition events.
3, Run create accounting observe the transactions getting created in the back dated period.

Cause

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