ERROR While starting database ORA-03113: end-of-file on communication channel Problem: On further diagnosis of ADRCI logs, I found disk space size assigned to Flash recovery area falling short Solution: Mount…
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 More1. Overview This document talks about prevent opening Oracle APEX application in multiple tabs with the same session state. 2. Technologies and Tools Used The following technologies have been used…
Read MoreHow SharePlex reports out-of-sync conditions For all objects except those involved in transformation, SharePlex verifies that the source and target data in a given operation are synchronized before posting the…
Read MoreIssue ; while closing the AR period we could see one receipt in in valid status in subledger period close exception report. Fix ; we have data fix for…
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 MoreIntroduction: Beginning with Oracle APEX 20.2, the only supported Web listener is Oracle REST Data Services (ORDS). What is ORDS? Oracle REST Data Services (ORDS) is a data service which…
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 More