Gmf_xla_extract_lines Table Showing Wrong Lot Information for Resource Transactions and Batch Closing Event
Last updated on DECEMBER 15, 2016
Applies to:Oracle Process Manufacturing Financials - Version 12.2.4 and later
Information in this document applies to any platform.
On : 12.2.4 version, Subledger Accounting
The gmf_xla_extract_lines table is showing the wrong lot numbers for Batch Closing events.
Since, by current system design, all posting for event type Batch Close, the inventory_item_id is populated with value 0 (zero) in the gmf_xla_extract_headers table.
So, there is no point in having the LOT_NUMBER being populated (as well) in the gmf_xla_extract_lines table, since there is no way to link that lot number to a specific item.
The issue can be reproduced at will with the following steps:
1. Perform a check of the gmf_xla_extract_lines table (FIle: gmf_xla_extract_lines_EBSD.xlsx) and see it is showing the wrong lot numbers for Batch Close Variance (CLS) events.
2. See that Lot 'U010024' represents to item 'VV-00132' which is not at all related to closed Production Batches: 1110000015 / 1110000016 / 1110000017, Product: VV-00127, Ingredient: VV-00126, as expected.
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