1. to get the synchronization of userid's etc working between E-Business and 10AS, there are a number of "hoopla's" that needs to be done between the 10AS and E-Biz....

see: Metalink note: `Disabling Profile With oidprovtool Fails With "Unable To Get Guid Of Entry"
Doc ID: Note:391219.1
and: Integrating Oracle E-Business Suite Release 11i with Oracle Internet Directory and Oracle Single Sign-On Doc ID: Note:261914.1 in particular pages 69- "Migrating Data between Oracle E-Business Suite Release 11i and Oracle Internet Directory"


and then do
"oidprovtool.sh" (modify the 10AS as described in the doc above)
"AppsUserExport.sh" (script to export all Apps users from the Apps user account)
"ldifmigrator.sh" (convert from exported file to a file that 10AS can read)
"opmnctl stopall" (stop all ldap processes"
"bulkload.sh" "import all APps users"
"opmnctl startall"
"provsubtool.sh"

The last step errors out.... Have raised SR: 6348905.992: Problem with Integrating Oracle Apps and Oracle 10AS

Following Doc ID: Installing Oracle Application Server 10g with Oracle E-Business Suite Release 11i, Doc ID: Note:233436.1

Opened SR: 6340810.992 as there is an error trying to apply this...
! 4775907 FND: 11i.ATG_PF.H RUP4 SSO 10g Integration

- 5589902 TXK: SSO REGISTRATION FAILS IS GOT SPACE IN COMPANY NAME

Symbol Legend
-------------
!: Unapplied prerequisite patch.

Well.. it appears that the 4775907 has to be appied although all documentation indicates otherwise.....

4775907 FND: 11i.ATG_PF.H RUP4 SSO 10g Integration
4775907 Norwegian
1 hour
5589902 TXK: SSO REGISTRATION FAILS IS GOT SPACE IN COMPANY NAME
30 minutes

run "$HOME/bin/ldapsearch.sh" in the ora10G account
run " txkrun.sh" in the Apps account(patches directory)


and after you need todo:
a) Generate message files
b) Compile APPS schema(s)
c) Compile flexfield data in AOL tables
d) Compile Menu Information
1 hour

That completes the SSO installation...

Following Doc ID: Installing Oracle Application Server 10g with Oracle E-Business Suite Release 11i, Doc ID: Note:233436.1

1. Patches on the DEVL instance:

5989593 - AD: 11i: Remove "REVOKE ALL FROM PUBLIC" from ADGRANTS.SQL
5989593 Norwegian
1 hour
4252319 LANGUAGE FILE SETUP FOR BNE.D(3218526) PATCHSET
15 minutes
3218526 BNE: Patch 11i.BNE.D - Refer to About Web Applications Desktop Integrator Mini-pack 11i.BNE.D, OracleMetaLink Note 287080.1, for installation instructions.
3218526 Norwegian
30 minutes

and Reports Manager.....

3761838 Patch 11i.FRM.G
3761838 Norwegian
30 minutes

4206794 FRM: Patch 11i.FRM.H - Refer to About Oracle Report Manager Minipack 11i.FRM.H, OracleMetaLink Note 378338.1, for installation
4206794 Norwegian
1 hour

3854951 FSG XML PUBLISHER FUNCTIONALITY FOR R11i
3854951 Norwegian
30 minutes

5473858 11i.ATG_PF.H.RUP5 (which is a MAJOR pre-req step)
6 hours
5473858 Norwegian
45 minutes

Failed on icxwtab.odf(See Note: 430673.1)
Solution
To implement the solution, please execute the following steps:
1. Please run the purge program:
a. The name of the program is "Purge data from temporary table".
b. The internal name is ICXDLTMP.
c. Also you can find this SQL script under $ICX_TOP/sql (named ICXDLTMP.sql). count of reows before run approx 224000 after: 0
d. rerun icxwtab.odf
end-of-solution.

Following Doc ID: Installing Oracle Application Server 10g with Oracle E-Business Suite Release 11i, Doc ID: Note:233436.1

1. Do "Pre-Install Task 5: Install OracleAS Identity Management Infrastructure 10g (10.1.4.0.1)"
5 hours (including download time)
2. check for creation of user "dummy_user" : all ok!
3. Do the section: "SSO Task 1: Install E-Business Suite SSO 10g Integration Patch and fix 5589902"

Following Doc ID: Installing Oracle Application Server 10g with Oracle E-Business Suite Release 11i, Doc ID: Note:233436.1

1. Check for httpd is ok within Oracle Apps:
"./httpd -v
Server version: Oracle HTTP Server Powered by Apache/1.3.19 (Unix)
Server built: Mar 17 2005 16:59:19 (iAS 1.0.2.2.2 rollup 5)"
is ok
2. DBMS_LDAP is installed in the database.
3. Downloading software: Oracle Identity Management 10.1.4.1 (takes forever finding the right software.....)