Delete Discoverer Workbook from backend

Hi,
I was facing couple of issues while deleting the Discoverere 10g workbook from front end.
I successfully deleted the same from backend.
Please find the scripts to delete particular workbook (select sql - to retrive and confim the workbook name ) and delete sql (pass the parameters as per the outcome/requirement of select statement.

eg:-
1)select * from eul5_documents where doc_id=121412 and DOC_EU_ID=100000;
2)select .DOC_NAME,d.DOC_DEVELOPER_KEY,p.notm,d.notm,d.DOC_DESCRIPTION,p.AP_ID,p.AP_TYPE,p.AP_EU_ID, p.GD_DOC_ID,d.doc_id from eul5_access_privs p, eul5_documents d where p.gd_doc_id=d.doc_id and d.doc_id=121412;
3)select * from eul5_access_privs where gd_doc_id=121412 and AP_UPDATED_BY='EUL_XX_US';
4)DELETE FROM eul5_access_privs where gd_doc_id=121412 and AP_UPDATED_BY='EUL_XX_US';
5)delete from eul5_documents where doc_id=121412 and DOC_EU_ID=100000;
6)commit;

Hope this helps.
Don't forget to give your feedback. :-)
Regards
Guru

Error connecting to database ORA--1

While viewing log and ouput files I am getting below error in log/output window.
Error connecting to database (**** DB NAME****): ORA--1
I did lot of troubleshooting to find the cause of this error. Finally came across that APPLSYSPUP is in EXPIRED (GRACE) status . you can check this under dba_users cloumn account_status.
I changed the status to open using
Alter user APPLSYSPUB identified by PUB;
This resolved my issue.
Regards
Guru

Upgrade/Rollup Patch from 12.1.1 to 12.1.2

Hi Readers,
After a long break I am updating my blog.
Its very difficult to find out patch/RUP details. Currently I am working on implementation project so thought to share few things.
After installation R12.1.1 you need to apply RUP2 patch to upgrade release 12.1.1 to 12.1.2
Here is the patch no's .
First apply pre-requisite then apply RUP2.
a)Pre-requisite - 8502056 - R12.AD.B.DELTA.2 - will take 1 hr
b)Oracle E- business RUP2 - 7303033 [12.1.1 to 12.1.2] - will take 10-12 hrs.

fyi,
select release_name from fnd_product_groups;

Regards
Guru

Change Sysadmin Password from backend

Hi Folks,
As you very much aware that you can change SYSADMIN password using FNDCPASS utility
FNDCPASS apps/appspwd 0 Y system/manager USER SYSADMIN sysadminpwd

Here I am giving another way to change the SYSADMIN password and Application User Login passwords using fnd_user_pkg from backend. Here is the procedure

sql> declare
var_l boolean;
begin
var_l=fnd_user_pkg.change_password('sysadmin','sysadminpwd');
end;
sql> PL/SQL Procedure Successfully Compiled.
You can verify from backend that password has changed successfully or not without login to the application.

sql>select fnd_web_sec.validate_login('sysadmin','sysadminpwd') from dual;
should returns 'Y'.

Happy Reading
Thanks
--Guru