Tuesday, April 12, 2016

Display Sender Name in oracle apex mail



You can display send name using oracle apex_email

 apex_mail.send(
                p_from => "Sender Display Name"<fromemailaddress>

don't enter space after the sender display name double quotes(") and from email address less than symbol (<)

Tuesday, April 5, 2016

List users with DBA privilege


Which users having dba provilege assigned, query dba_role_privs in the SYS schema

SQL>  select * from dba_role_privs where granted_role='DBA';

Wednesday, March 9, 2016

Rebuild UNUSABLE Partition Indexes



Validate and generate rebuild script for partition indexes


Select 'ALTER INDEX '||INDEX_OWNER||'.'||index_name ||' rebuild partition ' || PARTITION_NAME ||';'  from DBA_IND_PARTITIONS Where  status = 'UNUSABLE'



Sunday, March 6, 2016

How to disable CC Direct Manager functionality in Expenses Workflow



1. Open the wft file and double click on 'IS_MANAGER_IN_THE_APPR_PROCESS'.
2. Click on the Node Attributes and here we have an attribute named 'CC Direct Manager Notification'.
3. Please update the value to No, save the workflow file to the database.
4. Bounce the workflow listeners as well as apache.

R12.ATG_PF.C.Delta.5 Release Update Pack Features


This release introduces an updated Look and Feel for Oracle Application Framework-based pages, the Oracle Alta UI. Ensure that you either set the Oracle Applications Look and Feel profile option to "Alta Look and Feel" or to a Look and Feel that extends the Alta Look and Feel, or leave this profile option blank to use the standard Alta Look and Feel by default. Oracle supports only this standard Look and Feel, or one that extends it, for R12.ATG_PF.C.Delta.5. Oracle no longer supports the Look and Feel options of previous releases.