My Oracle Support Banner

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.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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