How to View Concurrent Request Output on Browser Step 1. Go To System Administrator Responsibility select Profile>System     Step 2. Search the Profile option ‘Viewer:%’    Step 3. Set the profile Viewer: …

ERROR ORA-20002: Version of statistics table APPLSYS.FND_STATTAB is too old

ERROR ORA-12899: value too large for column “APPLSYS”.”FND_PROFILE_OPTION_VALUES”.”PROFILE_OPTION_VALUE”

Useful Commands For Unix Operating System   1.Deleting files older than N number of days ? find . -name ‘*.trc’ -mtime +[N in days]  -exec rm {} \;   Command will …

Enable/Disable Maintenance Mode without using ADADMIN We can Enable or Disable Maintenance mode without using ADADMIN through following given procedure: Enable Maintenance Mode: $sqlplus apps/appspassword SQL>$AD_TOP/patch/115/sql/adsetmmd.sql ENABLE Disable Maintenance Mode: …

How to Add Responsibility to User from Back End SYNTAX fnd_user_pkg.addresp(username => Application User Name ,resp_app => Responsiblity_Application_Short_Name ,resp_key => Responsibility_Key ,security_group => Security_Group ‘Mostly it is ‘STANDARD’ so it …

ERROR Routine AFPGCP cannot create a process ID for your concurrent manager process ORACLE error 8004 in FDUUID Cause: FDUUID failed due to ORA-08004: sequence FND_CONCURRENT_PROCESSES_S.NEXTVAL exceeds MAXVALUE and cannot …

How to Find Request Group associated for a Program SELECT rg.application_id         “Request Group Application ID”,         rg.request_group_id         “Request Group – Group ID”,         rg.request_group_name,         rg.description,         rgu.unit_application_id,         rgu.request_group_id         “Request Group Unit – Group ID”,         rgu.request_unit_id,         cp.concurrent_program_id,         cp.concurrent_program_name,         cpt.user_concurrent_program_name,         Decode(rgu.request_unit_type, ‘P’, ‘Program’,                                       ‘S’, ‘Set’,                                       rgu.request_unit_type) “Unit Type”  FROM   fnd_request_groups rg,         fnd_request_group_units rgu,         fnd_concurrent_programs cp,         fnd_concurrent_programs_tl cpt  WHERE  rg.request_group_id = rgu.request_group_id  …

How to Find Scheduled Concurrent Program Below Query will Fetch all the details for a scheduled concurrent program. SELECT a.requested_by,         a.status_code,         a.phase_code,         a.request_id,         b.user_concurrent_program_name,         c.concurrent_program_name,         a.requested_start_date,         c.execution_method_code,         d.execution_file_name,         d.execution_file_path  FROM   apps.fnd_concurrent_requests a,         apps.fnd_concurrent_programs_tl b,         apps.fnd_concurrent_programs c,  …

Different Statuses of Concurrent Manager   PENDING STATUS Normal – Request is waiting for the next available manager. Currently all manager are running other requests. Standby – Program to run request is incompatible with …