Archive for September, 2025

IAP-CANNOT READ FIELD (FIELDNAME=PARAMETER.CONFIG)

September 8th, 2025, posted in Oracle EBS Application
Share

IAP-CANNOT READ FIELD (FIELDNAME=PARAMETER.CONFIG)
=================================================

#woesOfDBA, #WoesOfDba, #woesOfDBA, #WoesOfDba, woes of dba, Woes Of Dba, immam dba,dba immam, #immam_dba, #immamDba, #dbaimmam, #dba_immam, IAP-CANNOT READ FIELD,

Issue : One of the concurrent request got failed due to below error on 
R12 Clone instance.

Error :- IAP-CANNOT READ FIELD (FIELDNAME=PARAMETER.CONFIG) 

Application Version  :- 12.1.2
Database version : 11.2.0.3.0

Issue cause : 

The ‘APPLFSTT’ parameter didn’t setup to TWO_TASK name in the  MT node 
LISTENER.ora.

MT node listener.ora :-
APPLFSTT=DXXX2I_FO;DXXX2I_BALANCE;DXXX2I,

Solution :-

1. Change the parameter value for ‘APPLFSTT’ in the APPS LISTENER.ora file 
to show TWO_TASK (SID name) value.
Changes :  APPLFSTT=DXXX2I;DXXX2I_FO;DXXX2I_BALANCE;
2. Bounce your middle Tier.
3. Retest the issue. 


Refer Metalink Doc id :Concurrent Processing - Error AP-CANNOT
READ FIELD (FIELDNAME=PARAMETER.CONFIG) When Viewing the 
Concurrent Request Output [ID 466410.1]
Share
read more no comments

ORA-01194: file 1 needs more recovery to be consistent

September 2nd, 2025, posted in Oracle EBS Application, Oracle Queries
Share

ERROR :

SQL> startup
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: ‘/u01/app/oracle/oradata/denemedb/system01.dbf’

SOLUTION :

SQL> show parameter undo

NAME |TYPE |VALUE
— —| — — — | — — — — — —
undo_management |string |AUTO

SQL> alter system set undo_management=manual scope=spfile;

SQL> ALTER SYSTEM SET “_allow_resetlogs_corruption”= TRUE SCOPE = SPFILE;

SQL> ALTER DATABASE OPEN RESETLOGS;

SQL> alter system set undo_management=AUTO scope=spfile;

SQL> shutdown immediate

SQL> startup
Share
read more no comments