Restore The Drop Table In 19c Oracle Autonomous Data Warehouse

October 12th, 2025, posted in Oracle Queries
Share
SQL > FLASHBACK TABLE your_table_name TO BEFORE DROP;
SQL > FLASHBACK TABLE TABLE_NAME TO BEFORE DROP;
Share

Find All Scheduled Requests in EBS R12.2.10

October 5th, 2025, posted in Oracle EBS Application, Oracle Queries
Share

SELECT request_id id,
nvl(meaning, 'UNKNOWN') status,
user_concurrent_program_name pname,
to_char(request_date, 'DD-MON-RR HH24:MI:SS') submitd,
to_char(requested_start_date, 'DD-MON-RR HH24:MI:SS') requestd
FROM fnd_concurrent_requests fcr,
fnd_lookups fl,
fnd_concurrent_programs_vl fcpv
WHERE phase_code = 'P'
AND (fcr.requested_start_date >= sysdate OR
status_code = 'P')
AND LOOKUP_TYPE = 'CP_STATUS_CODE'
AND lookup_code = status_code
AND fcr.concurrent_program_id = fcpv.concurrent_program_id
AND fcr.program_application_id = fcpv.application_id
ORDER BY request_date, request_id;





Share

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

September 8th, 2025, posted in Oracle EBS Application
Share
#woesOfDBA, #WoesOfDba, #woesOfDBA, #WoesOfDba, woes of dba, Woes Of Dba, immam dba,dba immam, #immam_dba, #immamDba, #dbaimmam, #dba_immam, IAP-CANNOT READ FIELD,
Refer Metalink Doc id :Concurrent Processing - Error AP-CANNOT
READ FIELD (FIELDNAME=PARAMETER.CONFIG) When Viewing the 
Concurrent Request Output [ID 466410.1]
Share

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

September 2nd, 2025, posted in Oracle EBS Application, Oracle Queries
Share
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’

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

Oracle User ICX:Session Timeout Increase In E-Business Suite 12.1/12.2

August 20th, 2025, posted in Oracle EBS Application
Share
Share