R12.2.5 Post Upgrade script asnmmres.sql for Migrating old 11i Custom Resp to R12 Custom Resp Not Working (Doc ID 2159110.1)

Last updated on SEPTEMBER 04, 2016

Applies to:

Oracle Sales - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

R12.2.5 Post Upgrade script asnmmres.sql for Migrating old 11i Custom Resp to R12 Custom Resp Not Working

The script (asnmmres.sql) takes old and new responsibility keys and responsibility application code as inputs. It does not create new responsibilities, but exits with an error if either the old or new responsibilities are not present. For each user having an old Sales Online responsibility, it assigns a new Sales responsibility, if it is not already assigned to that user, and end-dates the old responsibility.

This does not work, tried application code and ID for the input, also created new responsibilities and keys, it did not copy the Menus and functions to the new responsibility, it did not end date the old responsibility and did not do anything.

Changes

 

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