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 

Step 1:Copy Resources Folder to Local dev Suite Ex :/d01/oracle/appl/apps/apps_st/appl/au/12.0.0  (move to Resouce folder to Devsuite installation path ) Step 2 : Add registry in below path HKEY_LOCAL_MACHINE --> SOFTWARE-->Wow6432Node -->Oracle--> KEY_DEvSuiteHome1->FORMS_PATH (EDIT) Ex: C:\DevSuiteHome_1\forms\resource Step 3 : If you get prompt says : APPSTAND or TEMPLATE Missing , move appstand or template.fmd from au->forms->APPSTAND.fmb to local resource folder ( C:\DevSuiteHome_1\forms\resource) Thank you

1) Query up your invoice source , which user have reported Jump in number. Navigate>Setup>Invoice>Source 2) Execute the following script using your source as in step 1.   SELECT batch_source_id, org_id, name FROM ra_batch_sources_all WHERE name LIKE '<source>' ;   or use this query if you have access from database.   SELECT 'alter sequence AR.' ||seq.sequence_name|| ' nocache;' FROM ( SELECT name bsname, org_id org, 'RA_TRX_NUMBER_' ||BATCH_SOURCE_ID|| '_' ||org_id|| '_S' seqname FROM RA_batch_sources_all ) src, dba_sequences seq WHERE src.seqname=seq.sequence_name AND seq.cache_size; ORDER BY org /     3) Using the batch_source_id from the above query , execute the followingscript:   SELECT sequence_owner, sequence_name, cache_size FROM all_sequences WHERE sequence_name LIKE 'RA_TRX_NUMBER%1146%' ;     4) Execute the following:   ALTER sequence SEQ...