Tuesday, April 28, 2020

Disable Oracle Label Security (OLS) 11gR1


Check Oracle Label Security OLS Status
=============================

SELECT * FROM V$OPTION WHERE PARAMETER = 'Oracle Label Security';

Disable Oracle Label Security OLS
=============================

sqlplus sys as sysoper
Enter password: password

SQL> SHUTDOWN IMMEDIATE
SQL> EXIT

$ emctl stop dbconsole
$ lsnrctl stop [listener_name]
cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk lbac_off
cd $ORACLE_HOME/bin
relink all

Wednesday, April 15, 2020

Adop Apply patch and its translation:


adop phase=apply patches=1012464,10124646_AR:u10124646.drv

adop phase=apply apply_mode=downtime patches=30980514,30980514_AR:u30980514.drv

APP-FND-1434: fdlsql cannot find FROM clause in QuickPick statement is returned


PROBLEM STATEMENT
=================
While trying to setup the profile option PO : Attachments to display in Notification Header, 
when calling the LOV error APP-FND-1434: fdlsql cannot
find FROM clause in QuickPick statement is returned















Solution
==========
apply the following patch.

Patch 30007772: In oracle purchasing, profile option 
"PO: Attachment to display in Notification Header" can be set up successfully.