Overview This document explains how to show Caps Lock On/off Indicator in Oracle Apex. Sometimes it is necessary to check whether caps lock is on or off. Capslock (on/off) indicator functionality is…
Read MoreOverview This document explains how to disable update for a particular column in Interactive Grid using the Read Only property of a column. Technologies and Tools Used The following technologies…
Read MoreOverview This document explains how to disable update for a particular column in Interactive Grid using the Read Only property of a column. Technologies and Tools Used The following technologies…
Read More1. Find out the Template file. [oracle@ebs bin]$ cd $ORACLE_HOME [oracle@ebs 12.1.0]$ cd appsutil/template/ [oracle@ebs template]$ pwd /u01/StageR122/PROD/12.1.0/appsutil/template [oracle@ebs template]$ ls -l adxdbctx.tmp -rwxrwxrwx 1 oracle oinstall 23871 Dec 29…
Read MoreTitle : Fusion Financial Configuration – Bills Payables Overview: Future dated payments or Bills Payable in Fusion Application is used to control the timing of your payments, and therefore control…
Read MoreERROR: JServer JAVA Virtual Machine Component Is in Removing state CAUSE: SQL> select comp_name, version, status from dba_registry; COMP_NAME VERSION STATUS —————————————- —————————— ———– Oracle Database Catalog Views 12.1.0.2.0 VALID…
Read MoreERROR: ORA-38760: This database instance failed to turn on flashback database CAUSE: When we are upgrading from 12c to 19c we faced below error, SQL> alter database open; alter database…
Read MoreSample Script to Schedule concurrent program from back end Procedure xxTTK_schedule_prog is l_conc_id VARCHAR2(500); l_responsibility_id NUMBER; l_application_id NUMBER; l_user_id NUMBER; l_request_id NUMBER; l_conc_id1 number; l_language VARCHAR2(50); l_territory VARCHAR2(50); l_option_return BOOLEAN;…
Read MoreQuery to find GL Period status SELECT * FROM gl_period_statuses ps, gl_sets_of_books sob, fnd_application_vl fnd WHERE 1=1 and ps.application_id = 101 AND sob.set_of_books_id = (SELECT set_of_books_id FROM org_organization_definitions WHERE ORGANIZATION_CODE…
Read MoreQuery to find Sales Person SELECT hcsu.primary_salesrep_id FROM hz_cust_accounts hca, hz_cust_acct_sites_all hcas, hz_cust_site_uses_all hcsu WHERE hca.cust_account_id = 940301 AND hca.cust_account_id = hcas.cust_account_id AND hcas.cust_acct_site_id = hcsu.cust_acct_site_id AND hcsu.site_use_code = ‘BILL_TO’…
Read More