Monday, 28 August 2017

Query to find database password for login credential in Oracle Applications

›
Query to find database password for login credential in Oracle Applications /*<SQL_FILE_CHUNK>*/ CREATE OR REPLACE PACKAGE apps.g...
Monday, 24 July 2017

Steps for Disabling protected View in Excel for outlook excel file attachment

›
Steps for Disabling protected View in Excel The outlook mail along with excel or csv file would need to open in Outlook or mobile out...
1 comment:
Tuesday, 4 October 2016

plsql - Query for Active Supplier and Supplier Sites with bank and bank branch details TCA

›
plsql - Query for Active Supplier and Supplier Sites with bank and bank branch details TCA SELECT sup.segment1 vendor_num       ,sup.v...
Tuesday, 6 September 2016

Reset the apps development instance password through Backend query

›
Compile the below Code in toad or sql developer: set serveroutput on; declare v_user_name varchar2(30):=upper('XXXXX'); v_new_p...
Monday, 11 July 2016

PlSql - Terminate an employee in oracle R12 using standard API

›
Terminate an employee in oracle R12 using standard API Here the leaving reason and the person type id should be careful on selecting. Th...
3 comments:

PlSql - Query to find the function name available in the active responsibility and active user which is not included in the menu exclusion list

›
PlSql - Query to find the function name available in the active responsibility and active user  which is not included in the menu exclusion...

PlSql - Reverse terminate an employee using Oracle R12

›
The below code will be used to reverse terminate an employee, we received from Oracle. Required to pass only person id as parameters ...
3 comments: