Here are few\u00a0Apps DBA interview questions you can expect, if recruiter is looking for SSO-Apps Integration expertise<\/p>\n
Q. How to find if your E-Business Suite is integrated with SSO\/OID<\/strong> (10g Identity Management)<\/p>\n – There are multiple ways to find out Apps 11i\/R12 is integrated with SSO\/OID Q. If Single Sign-On server & OID is down, can users still login<\/strong> ? Q. Name few Profile Option w.r.t. SSO Integration * Make sure you know about these profile option as explain these profile option and how they effect SSO Integration<\/p>\n Q. Which SSO build version you are currently working ? Q. What is OID version you used for Apps-SSO\/OID Integration ?<\/strong> Q. What was direction of User synchronization ? Q. What extra steps you need to do after changing apps password in SSO Integrated Apps Instances ?<\/strong> Q. If new users created is not able to login, how will you troubleshoot ? Q. User is currently set to Login via SSO, what steps you need to do to change user for Local Login\u00a0<\/strong><\/p>\n (AppsLocalLogin.jsp) Q. Where is log file for Apps Registration to SSO\/OID ? Q. Where is log file for User Provisioning ?<\/strong> Q. How you clone Oracle Apps (11i\/R12) Instance Integrated with OID\/SSO<\/strong><\/p>\n On Apps On OID\/SSO and finally Register target Apps to Target OID\/SSO<\/p>\n Q. What all issues you encountered during SSO\/OID Integration ?<\/strong><\/p>\n Q. What is Subscription List ?<\/strong><\/p>\n Q. What is mapping file w.r.t. User provisioning between Apps & OID and what is default location of oracle shipped<\/strong><\/p>\n mapping file in Apps ? Q. What is ODISRV in OID ? Q. How to load initial Set of user from Apps to OID or Vice-Versa ? From OID to Apps Post your questions in comment section<\/p>\n","protected":false},"excerpt":{"rendered":" Here are few\u00a0Apps DBA interview questions you can expect, if recruiter is looking for SSO-Apps Integration expertise Q. How to […]<\/p>\n","protected":false},"author":115,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[1],"tags":[],"class_list":["post-211","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"\n
\na) Check if SSOSDK schema exists (in Apps 11i\/R12) and check table in SSOSDK schema
\nb) Check if log file exists at $OAD_TOP\/rgf\/$CONTEXT_NAME\/sso
\nc) Profile option Option “Application SSO Types”<\/p>\n
\nYes, use localLogin<\/p>\n
\n<\/strong>– Application SSO Types
\n– Application SSO login types
\n– Application SSO Auto link User<\/p>\n
\n<\/strong>– Build 1, 2.1, 2.2, 3, 3.1, 4, 5, 6<\/p>\n
\nLatest certified OID version is 10.1.4.0.1 (Other certified were 10.1.2.0.2, 9.0.4 )<\/p>\n
\n<\/strong>– From OID to Apps
\n– Apps to OID
\n– Bidirectional<\/p>\n
\n– Update provisioning profile in OID with new apps password<\/p>\n
\n<\/strong>– Check if user exist in both Apps (FND_USER) and OID\u00a0 (If not check if user provisioning is working fine)
\n– If user exist check Password (in FND_USER) is set to External (If set to LOCAL user should try AppsLocalLogin.jsp)<\/p>\n
\n– Set Profile Option “Applications SSO Login Types” to LOCAL or BOTH
\n– Reset User Password using FNDCPASS
\n– Login using URL\u00a0 \/OA_HTML\/AppsLocalLogin.jsp<\/p>\n
\n<\/strong>$APPLRGF\/sso ($COMMON_TOP\/rgf\/$CONTEXT_NAME\/sso)<\/p>\n
\nOn OID Node under $ORACLE_HOME\/ldap\/odi\/log<\/p>\n
\n– Clone E-Business Suite using Rapid Clone<\/p>\n
\n– Migrate User\/Groups from source to target using ldifwrite & bulkload.sh
\n– Migrate Password Policy, DAS Admin Group<\/p>\n
\n– $FND_TOP\/admin\/template\/*.tmp<\/p>\n
\n<\/strong>ODISRV stands for Directory Integration Server and used during user provisioning between Apps and OID<\/p>\n
\n<\/strong>From Apps to OID
\n– Create intermediate LDIF file
\n– Using ldifmigrator create final LDIF file
\n– Use bulkload to load ldif file containing users to OID
\n– Finally create subscription for bulkloaded users<\/p>\n
\n– Use ldifwrite to create dump of users into LDIF file
\n– Using LDAPUserImport to import user to apps<\/p>\n