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 03, 2016

Applies to:

Oracle Process Manufacturing Systems - Version 12.1.3 and later
Information in this document applies to any platform.
***Checked for relevance on 08-APR-2014 ***

Symptoms


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

EXPECTED BEHAVIOR
-----------------
Expect to have all concerned Period balances migrated into table GMF_PERIOD_BALANCES


STEPS
----------
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


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

Cause

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