Upgrade To R12 Changes The Default Category Set For Product Reporting Functional Area (Doc ID 1527649.1)

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.

Symptoms

ACTUAL BEHAVIOR

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).

 

EXPECTED BEHAVIOR
-----------------------
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.

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

BUSINESS IMPACT
-----------------------
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.

Changes

 Upgrade to 12.1.3

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