Oracle Apps Technical Stuff
Friday, April 26, 2013
API To Add Responsibilty To User
›
/* Grant Particular Responsibility to a User */ SET serveroutput on DECLARE v_user_name VARCHAR...
Monday, April 22, 2013
ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE
›
1. Run the Below Script SELECT OWNER, INDEX_NAME, INDEX_TYPE, STATUS, DOMIDX_STATUS, DOMIDX_OPSTATUS ,TABLE_NAME FROM DBA_INDEXES WHERE ...
Saturday, April 20, 2013
Script To Delete the Business Events and Subscriptions
›
SELECT we.guid event_guid , wes.guid subscription_guid , wes.rule_function FROM wf_events we , wf_event_subscriptions ...
1 comment:
Thursday, April 11, 2013
Convert Number to Words
›
SELECT DECODE (SIGN (:p_number), -1, 'Negative ', 0, 'Zero', NULL) || DECODE (SIGN (ABS (:p_number)), +1, TO_C...
Query to Build the Relationship Hierarchy (HZ_RELATIONSHIP) in Oracle Apps
›
SELECT DISTINCT LPAD (' ', LEVEL * 2) || LEVEL , CONNECT_BY_ROOT hp1.party_name AS ROOT , SYS_CONNEC...
‹
›
Home
View web version