My Oracle Support Banner

When running 'Customer text data creation and indexing' program for Customer Search, Get Error Wrong Number Or Types Of Arguments In Call To GETINDEXMD (Doc ID 1570008.1)

Last updated on JANUARY 28, 2022

Applies to:

Oracle iReceivables - Version 12.1.1 and later
Information in this document applies to any platform.


When searching for a customer in iReceivables, the following error is displayed:


The customer information in the applications database is not indexed.  Please ask the system administrator to run the 'Customer text data and indexing' concurrent program to enable the Customer Search.


When customer runs the program, this fails with the error:

C:\oracle\TST12\apps\apps_st\appl\fnd\12.0.0\sql>sqlplus apps/apps @aflobbld.sql

SQL*Plus: Release - Production on Tue Jun 4 08:04:00 2013
Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Enter value for 1: APPLSYS
Enter value for 2: APPS
ERROR at line 1:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-10502: index FND_LOBS_CTX does not exist
DRG-50857: oracle error in drdmlpo
ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'GETINDEXMD'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
ORA-06512: at line 299



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.