Upgrade To R12 Changes The Default Category Set For Product Reporting Functional Area
Last updated on FEBRUARY 15, 2018
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.
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
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms