This post covers one issue that our trainee faced while running Purge Concurrent Request and/or Manager Data.
This Data program ‘Purge Concurrent Request and/or Manager Data‘ to purge:
- Request log files,
- Concurrent manager log files,
- Report output files from product directories maintained by the operating system and Application Object Library tables
If you are looking for Concurrent Managers : Overview & Concepts Oracle EBS R12 for Apps DBAs then check here
To resolve this error ‘APP-FND-01564: ORACLE error 8102 in request’ while running Purge Concurrent Request and/or Manager Data.” follow the steps mentioned below:
Issue
While running Purge Concurrent Request and/or Manager Data as
1. Login as SYSADMIN -> Responsibility System Administrator
2. Run Concurrent Program “Purge Concurrent Request and/or Manager Data”
Error in logs:
$APPLCSF/$APPLLOG
+—————————————————————————+
Application Object Library: Version : 12.0.0
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
FNDCPPUR module: Purge Concurrent Request and/or Manager Data
+—————————————————————————+
Current system time is 27-DEC-2018 10:38:00
+—————————————————————————+
APP-FND-01564: ORACLE error 8102 in request
Cause: request failed due to ORA-08102: index key not found, obj# 34563, file 25, block 24555 (2).
The SQL statement being executed at the time of the error was: and was executed from the file.
+—————————————————————————+
Start of log messages from FND_FILE
+—————————————————————————+
+—————————————————————————+
End of log messages from FND_FILE
+—————————————————————————+
+—————————————————————————+
Executing request completion options…
Finished executing request completion options.
+—————————————————————————+
Concurrent request completed
Current system time is 27-DEC-2018 10:40:47
Cause
The issue is caused by a mismatch between the key(s) stored in the index and the values stored in the table, because of corruption.
Solution
Please run the following steps
SQL> select owner,object_name, object_type from dba_objects where object_id=34563;
OWNER OBJECT_NAME OBJECT_TYPE
—————————— ———————————-
APPLSYS FND_CONCURRENT_REQUESTS_N1 INDEX
SQL> Analyze Index APPLSYS.FND_CONCURRENT_REQUESTS_N1 validate structure online;
Index analyzed.
SQL> select dbms_metadata.get_ddl(‘INDEX’,’FND_CONCURRENT_REQUESTS_N1′,’APPLSYS’) from dual;
DBMS_METADATA.GET_DDL(‘INDEX’,’FND_CONCURRENT_REQUESTS_N1′,’APPLSYS’)
——————————————————————————–
CREATE INDEX “APPLSYS”.”FND_CONCURRENT_REQUESTS_N1″ ON “APPLSYS”.”FND_CONCURR
SQL> select TABLE_NAME,INDEX_NAME,COLUMN_NAME,COLUMN_POSITION from dba_ind_columns where TABLE_NAME in (‘FND_CONCURRENT_REQUESTS’) order by 1,2,COLUMN_POSITION;
ALTER INDEX APPLSYS.FND_CONCURRENT_REQUESTS_N1 rebuild online;
ALTER INDEX APPLSYS.FND_CONCURRENT_REQUESTS_N2 rebuild online;
ALTER INDEX APPLSYS.FND_CONCURRENT_REQUESTS_N3 rebuild online;
ALTER INDEX APPLSYS.FND_CONCURRENT_REQUESTS_N4 rebuild online;
ALTER INDEX APPLSYS.FND_CONCURRENT_REQUESTS_N5 rebuild online;
ALTER INDEX APPLSYS.FND_CONCURRENT_REQUESTS_N6 rebuild online;
ALTER INDEX APPLSYS.FND_CONCURRENT_REQUESTS_N7 rebuild online;
ALTER INDEX APPLSYS.FND_CONCURRENT_REQUESTS_N8 rebuild online;
ALTER INDEX APPLSYS.FND_CONCURRENT_REQUESTS_N9 rebuild online;
ALTER INDEX APPLSYS.FND_CONCURRENT_REQUESTS_N10 rebuild online;
ALTER INDEX APPLSYS.FND_CONCURRENT_REQUESTS_N11 rebuild online;
ALTER INDEX APPLSYS.FND_CONCURRENT_REQUESTS_U1 rebuild online;
Related/Further Readings
- [Troubleshooting] Concurrent Manager: System Hold, Fix Manager Before Resetting Counters
- Troubleshoot/Debug Long Running Concurrent Request in Oracle EBS (R12/11i)
- Concurrent Processing – FNDCPPUR APP-FND-01564 ORA-08102 – Unable to Purge Concurrent Request Records and Request Log/Output Files (Doc ID 730617.1)
- Concurrent Processing – How To Run the Purge Concurrent Request FNDCPPUR, Which Tables Are Purged, And Known Issues Like Files Are Not Deleted From File System (Doc ID 822368.1)
- Oracle AppsDBA (R12): Step by step Activity Guides
This post is from our Oracle Apps DBA (R12.2) Training, in which we cover Architecture & Changes in Oracle E-Business Suite R12.2, Staging & Installation, File System & Important Files in R12.2, Start/Stop, Patching, AD Administration, Cloning, Concurrent Managers, AutoConfig, Password Management, and Troubleshooting and much more
Next Task For You
We cover Oracle E-Business R12.2 Architecture & concepts in our Oracle Apps DBA For Beginners Training along with the Installation, Patching, Cloning, and Troubleshooting and also, Database upgrade to 19c and much more including the hands-on labs you must perform to upgrade your skills and get a good job with a high package.
Begin your journey towards becoming an Apps DBA by joining our FREE Masterclass on How To Learn Oracle Apps DBA (R12) & It’s New Features.
Leave a Reply