Some EBS AD Tools report ORA-28110: Policy Function Or Package APPS.FND_CONCURRENT_QUEUE_SIZE has error

(Doc ID 1958773.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Applications Technology Stack - Version 12.2.3 and later
Information in this document applies to any platform.


On : 12.2 version, Autoconfig Engine

After completing Export/Import to migrate Database run the following can cause ORA-28110:




- adautoconfig see : started at Tue Nov 25 10:49:29 CST 2014

The environment settings are as follows ...

  ORACLE_HOME : /wms01/product/11.2.0/dbhome_1
  PATH : /wms01/product/11.2.0/dbhome_1/perl/bin:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/orawms/bin:/wms01/product/11.2.0/dbhome_1/bin:.
  Library Path : /wms01/product/11.2.0/dbhome_1/lib:/usr/X11R6/lib:/usr/openwin/lib:/wms01/product/11.2.0/dbhome_1/lib:/usr/dt/lib:/wms01/product/11.2.0/dbhome_1/ctx/lib

Executable : /wms01/product/11.2.0/dbhome_1/bin/sqlplus

SQL*Plus: Release Production on Tue Nov 25 10:49:29 2014

Copyright (c) 1982, 2011, Oracle. All rights reserved.

Enter value for 1: Enter value for 2: Enter value for 3: Connected.
ERROR at line 1:
ORA-28110: policy function or package APPS.FND_PROFILE_OPTION_VALUES has error
ORA-06512: at "APPS.ADX_PRF_PKG", line 52
ORA-06512: at line 7


-- exec fnd_conc_clone.setup_clean;    see

ERROR at line 1:
ORA-28110: policy function or package APPS.FND_CONCURRENT_QUEUE_SIZE has error
ORA-06512: at "APPS.FND_CONC_CLONE", line 354
ORA-06512: at line 1

The issue can be reproduced at will with the following steps:
1. Run adautoconfig


2. from sqlplus >exec fnd_conc_clone.setup_clean;


3. run script status


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