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 SEPTEMBER 26, 2016

Applies to:

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

Symptoms

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

Error

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 10.1.0.5.0 - 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 11.1.0.7.0 - 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

 

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