when attempting to execute “adop phase=fs_clone”, the following error occurs: # Calling ApplyAppsTier… # Creating the FMW Home from ApplyAppsTier Creating FMW Home. Running /u01/app/fs1/EBSapps/comn/clone/FMW/pasteBinary.sh -javaHome /u01/app/fs1/EBSapps/comn/clone/FMW/t2pjdk -al /u01/app/fs1/EBSapps/comn/clone/FMW/FMW_Home.jar -tl…
Read MoreThe following query will help you to find the history of concurrent programs run in your EBS environment. You should connect to ‘apps’ user for executing this query and query…
Read MoreEnvironment: E-Business Suite R12.1.3 Discoverer – 11.1.1.6.0 and JRE1.7 Issue: Connecting To Discoverer, EBS Forms become hang or Blank, While check the log file we found the the following error is…
Read MoreIntroduction:- Oracle has a seeded API fnd_user_pkg which has a procedure to create new user login account. Below is the sample script to create user account, change the parameters as per your…
Read MoreIntroduction:- fnd_user_pkg.addresp is an Oracle Seeded API to add responsibilities from one user account to another user account.Below is the script to copy responsibilities of user “ORACLE_TEST_USER_12” to “ORACLE_TEST_USER_89”. API…
Read MoreHere is an easy way to put all the Pending Concurrent requests in hold, if we are going through any situation(Mostly any Production Cutover/Go live scenarios). 1. First create a…
Read MoreSELECT hca.account_number, ( SELECT hp.party_name FROM apps.hz_parties hp WHERE hp.party_id = hca.party_id ) customer_name, jnb.creation_date notes_creation_date, jnb.note_type note_type, fls.meaning note_type_meaning, jnt.notes notes FROM apps.hz_cust_accounts hca, apps.jtf_notes_b jnb, apps.jtf_notes_tl jnt, apps.fnd_lookups…
Read MoreSELECT DISTINCT –gcck.concatenated_segments, gcck.segment1 company, gcck.segment2 location, gcck.segment3 product, gcck.segment4 function, gcck.segment5 account, gcck.segment6 intercompany, gcck.segment7 subaccount, gcck.segment8 future1, gcck.segment9 future2, rctld.gl_date, gjb.name batch_name, gjh.name journal_name, ( SELECT user_je_category_name FROM…
Read MoreSyntax: to_char(-123456,’99G99G99G999PR’) Query: select to_char(-123456,’99G99G99G999PR’) from dual; Output: <1,23,456>
Read MoreProblem: Adcfgclone got complete but at the end it failed for autoconfig with the below error. Error : WARNING: [AutoConfig Error Report] The following report lists errors AutoConfig encountered during…
Read More