Database Blog

Relink of module “fndfmxit.so” failed

Scenario: While applying the application patch end up with relink error. Note : Issue Occurs in 12.0 and later versions Error: ld: 0711-851 SEVERE ERROR: Output file: /test/apps/apps_st/appl/fnd/12.0.0/bin/fndfmxit.so The file…

Read More

FRM-92050 : Failed to connect to the Server: /forms/lservlet-1

Scenario : When we login to Oracle Application R12 we get the following error : Note : Browser version used : IE 8 Error : FRM-92050 : Failed to connect…

Read More

ORA-06508 ONT_HEADER_Def_Hdlr

ERROR : Unable To Open The Sales Order Form ORA-06508 ONT_HEADER_Def_Hdlr in R12.1.1 with 11.1.0.7 Error while opening Sales Order Form CAUSE : The issue is caused by the following…

Read More

EBS R12 Application Purging Routines

Concurrent Processing – Purge Concurrent Request and/or Manager Data Program (FNDCPPUR) Use this program to delete: –          request log files, concurrent manager log files, and report output files from your…

Read More

Untitled

Query for Scheduled request start on prior run less than 5 mins select cs.request_id,cs.concurrent_program_id,cs.program,cs.argument_text,cr.resubmit_interval_type_code,cs.requestor,resubmit_interval,resubmit_interval_unit_code from fnd_concurrent_requests cr,fnd_conc_req_summary_v cs where  cs.phase_code=’P’ and cs.status_code in (‘I’,’Q’) and resubmit_interval_type_code=’START’ and cr.request_id=cs.request_id and resubmit_interval_unit_code=’MINUTES’ and resubmit_interval<5

Read More

ASMlib for RHEL6

Dear all, Oracle has not yet released ASMlib for RHEL6 yet. Oracle’s policy about this can be found in the metalink document id 1089399.1 Regarding ASMLIB Oracle mentioned in note 1089399.1…

Read More

Script to find who has changed the sysadmin Password

The below script helps us to find the user_name who has changed the sysadmin password SELECT substr(d.user_name,1,30) || ‘~’||substr(f.user_name,1,10)||’~’||substr(d.last_update_date,1,10) key,count(*) value from apps.fnd_user d, apps.fnd_user f WHERE trunc(d.last_update_date) = trunc(sysdate)…

Read More

What are the key configuration files of Oracle EBS and Where are the key configuration files located(for 11i and Rel 12)

EXPLANATION OF SOME IMPORTANT CONFIGURATION FILES in 11i:- =================================================== httpd.conf ->This is main Apache configuration file. From this configuration file it identify port definitions, memory settings, loggin levels, log file…

Read More

How to find all Form Personalization through script in Oracle APPS

SELECT FORM_ID, FORM_NAME, USER_FORM_NAME, DESCRIPTION FROM FND_FORM_VL WHERE FORM_NAME IN (SELECT FORM_NAME FROM FND_FORM_CUSTOM_RULES GROUP BY FORM_NAME)

Read More

Golden Gate Installation and Configuration

https://docs.google.com/open?id=0B0ip-JHgbUQ7Q01PeFFMTFFOams

Read More