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.

Symptoms

On : 12.2 version, Autoconfig Engine

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

adautoconfig

adcmctl.sh

fnd_conc_clone.setup_clean



ERROR
-----------------------

- adautoconfig see :


afdbprf.sh 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
  ORACLE_SID : WMSDEV2
  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 11.2.0.3.0 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.
begin
*
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


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

or

2. from sqlplus >exec fnd_conc_clone.setup_clean;

or

3. run script adcmctl.sh status

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