Change Order Type Drop Down Results Limited By Setting Profile FND: View Object Max Fetch Size At The Site Level (Doc ID 2107117.1)

Last updated on AUGUST 09, 2017

Applies to:

Oracle Product Hub - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms


Unable to successfully create change orders since not all change order types are being shown from drop down list.
 
WHAT WORKS
---------------------

If the profile 'FND: View Object Max Fetch Size' is set at the site level for let's say 2000, then all 665 change order types can be seen.

WHAT DOES NOT WORK
------------------------------

If the profile 'FND: View Object Max Fetch Size' is set at the responsibility or any other lower levels to let's say 2000 while leaving the site level value to 500,
then only 501 change order types can be seen drop down list. It does not appear that profile FND: View Object Max Fetch Size when set at the responsibility level
or any other lower level is taking precedence over the site level.

STEPS
--------

1) Set the profile 'FND: View Object Max Fetch Size' at the site level to 500.
2) Set the profile 'FND: View Object Max Fetch Size' at the responsibility level for Development Manager to 2000.
3) Navigate to item catalog/item simple search and look up any item and then choose create change order.
4) From change order type drop down expand and check what options to choose from. Will notice only 501 available change order types to choose from
when expecting full 665 change order types to choose from.
5) Alternatively, you could navigate to change managemenrt/create change order and look at the change order type drop down and will see same result.
 

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