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

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.