Oracle Apps Technical Information

Begin fnd_program.delete_program('SHORTNAME','APPLICATION'); fnd_program.delete_executable('SHORTNAME','APPLICATION'); End ; COMMIT; 

Error Code : 1700 Comments : 1700: Could not connect with username/password 'apps/apps@acp' ('ORA-12541: TNS:no listener '). Reason : TNS Entry Solution : Step 1 : Go to  C:\OraHome_1\network\ADMIN\tnsnames.ora Step 2 : Create  tnsnames.ora   Sample Code : TESTDB=         (DESCRIPTION=                 (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.160.10)(PORT=1766))             (CONNECT_DATA=                 (SID=PROD)             )         )

How to kill a session which is locked in Oracle apps This Article is used to explain how to kill a session which is locked a.            Check if the Package or table are locked using the below query SELECT b.object_name,               a.session_id,                               a.oracle_username,                               a.os_user_name,                               a.process,        ...

delete from my_table t1  where  exists (select 'x' from my_table t2                  where t2.key_value1 = t1.key_value1                    and t2.key_value2 = t1.key_value2                    and t2.rowid      > t1.rowid

Query up the user and ensure the responsibility is NOT end dated  END DATE the USER (not the responsibility), save the record  UNEND DATE the USER, save the record  run the request 'Sync responsibility role data into the WF table'  run the request "Synchronize WF LOCAL tables"  run the request "Workflow Directory Services User/Role Validation" (10000, yes, yes, yes)  have the person log off and back on and verify if the responsibility