Migration from 11i to R12.1: not all Period Balances get Migrated from Table Ic_perd_bal to gmf_period_balances

(Doc ID 1306337.1)

Last updated on NOVEMBER 17, 2017

Applies to:

Oracle Process Manufacturing Systems - Version 12.1.3 and later
Information in this document applies to any platform.


On: 12.1.3, Migration issues 11i to R12
Find that Period balances not migrated from table ic_perd_bal for some of the warehouses

Expect to have all concerned Period balances migrated into table GMF_PERIOD_BALANCES

The issue can be reproduced at with the following steps:
1. Following Checklist for process Manufacturing Migration from 11.5.10 to R12 and having completing all steps.
3. During migration, run script GMFG6P14.sql expecting to see records migrated in GMF_PERIOD_BALANCES and no error in migration log.
4. Missing records in gmf_period_balances after migration run against records in ic_perd_bal

Due to this issue, users are Unable to use period balances for Actual Cost calculation and inventory valuation


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