Last updated on AUGUST 21, 2016
Applies to:Oracle Item Master - Version 12.1.3 and later
Information in this document applies to any platform.
When upgrading to 12.1.3, the default category set for functional area "Product Reporting" is overlaid with the seeded category set even though the customer has updated the value in the 11i instance.
Use the following script to confirm that the default category set for functional Area Product Reporting was updated by a user. Run the script in the pre-upgrade instance (11i).
Per development, If the last_updated_by and last_update_date are different from seeded, the system should not overlay the default category set upon upgrade.
The issue can be reproduced at will with the following steps:
1. In 11i, update the default category set for functional area Product Reporting to Customer created Category Set using a user that is not sysadmin.
2. Upgrade to 12.1.3
3. the default category set for functional area Product Reporting is overlaid with value Product.
The issue has the following business impact:
Due to this issue, users cannot change the default category set for functional area "Product Reporting" back to Customer created Category Set. because to do so causes the following table to be cleared out: WIP_DEF_CAT_ACC_CLASSES
Also, after the upgrade, users may no longer get a default category assigned when assigning items to child organizations.
Upgrade to 12.1.3
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms