Thursday, May 24, 2018

EBS QUERY TO FIND RESOURCE AND ITS ASSOCIATED ALTERNATE RESOURCES

Below is the query to find the resources and its associated alternate resource in manufacturing  module.

SELECT A.RESOURCES,ALTERNATE_RESOURCE.ALTERNATE_RESOURCE,A.RESOURCE_DESC,A.RESOURCE_CLASS,
B.MIN_CAPACITY,B.MAX_CAPACITY,
B.IDEAL_CAPACITY,B.CAPACITY_UM,B.GROUP_RESOURCE,MP.ORGANIZATION_CODE
FROM
CR_RSRC_MST_B A,CR_RSRC_DTL B,MTL_PARAMETERS MP,APPS.CR_ARES_MST ALTERNATE_RESOURCE
WHERE A.RESOURCES=B.RESOURCES AND B.ORGANIZATION_ID=MP.ORGANIZATION_ID
AND A.RESOURCES=ALTERNATE_RESOURCE.PRIMARY_RESOURCE
ORDER BY 1 DESC;

Tuesday, May 22, 2018

HOW TO CREATE AND DROP DATABASE LINK

Below is the syntax for creating and dropping DB Link in Oracle

Enter the DB Link Name, username, Password and Schema Name in the below syntax

Note: Schema Name should be in Quotes and you should have sufficient privileges to create and drop DB Link.

CREATE DATABASE LINK
DBLINKNAME 
CONNECT TO USER
IDENTIFIED BY PASSWORD
USING 'SCHEMA NAME';



DROP DATABASE LINK DBLINKNAME ;

Friday, May 18, 2018

HOW TO LOGIN TO OBIEE BYPASSING LOGIN PAGE

Please use the below url to bypass EBS security to Login into OBIEE.

Enter the Username and Password after NQSUser and NQPassword in URL below.

http://localhost:9704/analytics/saw.dll?Dashboard&NQUser=Username&NQPassword=Password