Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

ORA-20000: possearchindex.sql(500)

edited Aug 20, 2021 10:15AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 2 commentsAnswered ✓

Hi,

I'm upgrading EBS from 12.2 to 12.2.6 applying patch 21900901 fails on

Time when worker started job: Wed Feb 22 2017 10:33:43

Start time for file is: Wed Feb 22 2017 10:33:43

sqlplus -s APPS/***** @/appsR122/applprod/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/appsR122/applprod/fs1/EBSapps/appl/pos/12.0.0/patch/115/sql/POS_SUPPLIER_SEARCH_INDEX.sql '
Connected.

PL/SQL procedure successfully completed.

DECLARE
*
ERROR at line 1:
ORA-20000: possearchindex.sql(500): ORA-20000: Exception at
POS_SUPPLIER_SEARCH_INDEX_PKG.create_index(1800): ORA-20000: Exception at
POS_SUPPLIER_SEARCH_INDEX_PKG.create_index(1800): ORA-29855: error occurred in
the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-10754: Size (in bytes) must be between 1024 and 52428800

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center