Query To Check Concurrent Program Run History in EBS
The 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 MoreDiscoverer Java connecting screen become hang or Blank
Environment: 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 MoreCreate Oracle User Login Account Using API
Introduction:- 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 MoreOracle API Script to Copy Responsibilities of one user account to another user account
Introduction:- 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 MoreHold Pending Concurrent Requests and release them
Here 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 MoreOracle R12 Query To Find Customer Notes
SELECT 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 MoreOracle R12 GL To AR Transaction Details
SELECT 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 MoreOracle SQL Query To Return Negative Numbers Within Bracket
Syntax: to_char(-123456,’99G99G99G999PR’) Query: select to_char(-123456,’99G99G99G999PR’) from dual; Output: <1,23,456>
Read MoreHow to reslove “adadmprf.sh INSTE8_PRF”
Problem: 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“Output Post Processor” Concurrent Manager not able to start R12.1
Cause: Unable to initialize state monitor. oracle.apps.fnd.cp.gsm.GenCartCommException: ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at “APPS.FND_CP_GSM_IPC”, line 499 ORA-06512: at line 1 at oracle.apps.fnd.cp.gsm.GenCartComm.initService(GenCartComm.java:233) at oracle.apps.fnd.cp.gsm.GenCartComm.<init>(GenCartComm.java:80)…
Read More