Wednesday, March 3, 2021

How to set Default OU oracle EBS in tools Query data

Set Default OU

--after run alter seesion

alter session set nls_language = american


--and next run script

BEGIN

        mo_global.set_policy_context('S', 94); -- 94 is ID in Operation_unit 

END;


Select test data show by OU, Enjoy

No comments:

Post a Comment

How to Create shell script to Start Database and Checking Table Space

 #dr_check_db_ERPGF.sh #!/bin/bash #run ./dr_check_db_ERPGF.sh | tee dr_ERPGF.out echo -e "\n" echo -e "+++++ Start Check Dat...