Symptoms
+---------------------------------------------------------------------------+
Application Object Library: Version : 11.5.0
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
FNDGACST module: Gather All Column Statistics
+---------------------------------------------------------------------------+
Current system time is 24-SEP-2007 17:00:11
+---------------------------------------------------------------------------+
**Starts**24-SEP-2007 17:00:11
ORACLE error 6550 in FDPSTP
Cause: FDPSTP failed due to ORA-06550: line 1, column 7:
PLS-00307: too many declarations of 'GATHER_ALL_COLUMN_STATS' match this call
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
.
The SQL statement being executed
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
Successfully resubmitted concurrent program FNDGACST with request ID 316257 to start at 25-SEP-2007 17:00:00 (ROUTINE=AFPSRS)
+---------------------------------------------------------------------------+
Executing request completion options...
Finished executing request completion options.
+---------------------------------------------------------------------------+
Exceptions posted by this request:
Concurrent Request for "Gather All Column Statistics" has completed with error.
+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 24-SEP-2007 17:00:11
+---------------------------------------------------------------------------+
Solutions
A) Execute the following workaround:
1.System Administrator, Concurrent > Program > Defile,
2.Query the report and press 'Parameters' button,
3.Add the two missing HMODE and INVALIDATE parameters to definition of FNDGCLST
Ex:
8, Hmode, Hmode, Vset: 30 Characters, Required:N, Security:N, Display:Y
9, Invalidate, Invalidate, 1 char, Required:N, Security:N, Display:Y
1 comment:
Sagol kothakar...
Post a Comment