EBS INTEGRATION WITH ECM using AXF method

EBS HTML based pages refer to Integrating Oracle E-Business Suite (11i, R12, and R12.1) with Content Management Repositories [ID 1061947.1]
Ref for HTML BASED EBS INTEGRATION : ID 1061947.1

Ref for FORM BASED EBS INTEGRATION : http://docs.oracle.com/cd/E17904_01/doc.1111/e17953/toc.htm

STEPS :

[root@server1 ~]# su - oradr12

[oradr12@server1 ~]$ lsnrctl start dr12

[oradr12@server1 ~]$ sqlplus '/as sysdba'

SQL> startup

SQL> create tablespace AXF datafile '/dr12/d02/oracle/dr12/db/apps_st/data/AXF01.dbf' size 1G autoextend on;

SQL> create user AXF identified by AXF quota unlimited on AXF;

SQL> grant create table to AXF;

SQL> grant create sequence to AXF;

SQL> grant create public synonym to AXF;

SQL> grant create session to AXF;

SQL> grant create procedure to AXF;

SQL> grant unlimited tablespace to AXF;

SQL> commit;

SQL> connect AXF/AXF;

SQL> @/Webcenter/Middleware/Oracle_ECM1/axf/adapters/ebs/R12/AXF_CREATE_TABLES_SYNONYM.sql

SQL> desc AXF_COMMAND_PARAMETERS;

SQL> desc AXF_COMMANDS;

SQL> desc AXF_CONFIGS;

SQL> desc AXF_PROPERTIES;

SQL> desc AXF_FND_MAP;

SQL> @/Webcenter/Middleware/Oracle_ECM1/axf/adapters/ebs/R12/AXF_EBS_PROPERTIES_DATA.sql

SQL> connect apps/apps

SQL> @/Webcenter/Middleware/Oracle_ECM1/axf/adapters/ebs/R12/AXF_APPS_INIT.sql

SQL> @/Webcenter/Middleware/Oracle_ECM1/axf/adapters/ebs/R12/AXF_ADD_EBS_ATTACHMENT_PROC_R12.sql

SQL> @/Webcenter/Middleware/Oracle_ECM1/axf/adapters/ebs/R12/AXF_MANAGED_ATTACH_AVAIL.sql

SQL> @/Webcenter/Middleware/Oracle_ECM1/axf/adapters/ebs/R12/AXF_MANAGED_ATTACH_VALUES.sql

SQL> @/Webcenter/Middleware/Oracle_ECM1/axf/adapters/ebs/R12/AXF_MANAGED_ATTACHMENT_DATA.sql

SQL> @/Webcenter/Middleware/Oracle_ECM1/axf/adapters/ebs/R12/AXF_SOAP_CALL_PROC.sql

SQL> commit;

[root@server1 ~]# su - appldr12

[appldr12@server1 ~]$ cp -r /Webcenter/Middleware/Oracle_ECM1/axf/adapters/ebs/R12/AXF_CUSTOM.pld $FORMS_PATH(/dr12/d01/oracle/dr12/apps/apps_st/appl/au/12.0.0/resource)

[appldr12@server1 ~]$ cd /dr12/d01/oracle/dr12/apps/tech_st/10.1.2/bin/

[app[appldr12@server1 bin]$ ./frmbld

It shows Object Navigator window. In that

File -> connect -> username=apps, password=apps, database=dr12

Now forms connected to database objects.

Then convert AXF_CUSTOM.pld to AXF_CUSTOM.pll as follows,

File -> convert -> Type=Pl/SQL Libraries, Direction=Text-to- Binary, File = /dr12/d01/oracle/dr12/apps/apps_st/appl/au/12.0.0/resource/AXF_CUSTOM.pld -> convert

Then compile pl/sql and module by using,

File -> open -> AXF_CUSTOM.pll -> program -> compile pl/sql -> All

AXF_CUSTOM.pll -> program -> compile Module

Then take a backup of CUSTOM.pll in the same path as AXF_CUSTOM.pll

cp -r CUSTOM.pll CUSTOM.pll-ori

Then open CUSTOM.pll

File -> open -> CUSTOM.pll - program units - package body - pl/sql editor(rigt click on package body)

Then edit the following things

#................................#
function zoom_available return boolean is
begin

-- Required for ALL integrations
return true;                       -> default FALSE
end zoom_available;
#.....................................#

#..................................#
procedure event(event_name varchar2) is
begin

-- Required for AXF integrations
AXF_CUSTOM.event(event_name);      -> add this single line
null;

end event;
#...................................#


File -> Save

CUSTOM.pll - Attached libraries - Attach AXF_CUSTOM.pll(click + symbol(ie) create symbol(leftside)) it will ask library path. In that u have to attach AXF_CUSTOM.pll file. Now the AXF_CUSTOM.pll file is added under the attached libraries of CUSTOM.pll

Inside ATTACHED LIBRARY of CUSTOM.pll check APPCORE and APPCORE2 listed. now detach and attach(by clicking +,- symbol)

CUSTOM.pll -> program -> compile pl/sql -> All

CUSTOM.pll -> program -> compile Module

File -> save.........



[root@server1 ~]# su - oradr12

[oradr12@server1 ~]$ lsnrctl start dr12

[oradr12@server1 ~]$ sqlplus '/as sysdba'

SQL> connect AXF/AXF;

SQL> select * from AXF_PROPERTIES;

SQL> update AXF_PROPERTIES set PROPVALUE='TRUE' WHERE PROPNAME='AXF_SOAP_SECURITY';

SQL> connect apps/apps

SQL> execute fnd_vault.put('AXF','weblogic','Welcome123');

SQL> select fnd_vault.get ('AXF','weblogic') from dual;

SQL> connect AXF/AXF;

SQL> update AXF_PROPERTIES set propvalue='file:walletpath' where propname = 'AXFWalletPath';

SQL> update AXF_PROPERTIES set propvalue='ON/OFF' where propname = 'SecureMode';

SQL> commit;

SQL> desc AXF_CONFIGS;

Follow this link for complete integration.
http://docs.oracle.com/cd/E28389_01/doc.1111/e17953/c01_overview.htm

After these setup i tried to integrate ECM with EBS using this Webservice method.[ID 1061947.1] and
http://docs.oracle.com/cd/E18727_01/doc.121/e13108/T384757T489532.htm

ECM ECM ECM WebDAV http://server1.yantro.com:8024/content/ws http://server1.yantro.com:8024/content/dav 5

Test connection successful and then connection with the repository is successful.

Again i tried to integrate ECM using AXF method by following this link : http://docs.oracle.com/cd/E28389_01/doc.1111/e17953/c01_overview.htm. In that link i started only from fifth point only(ie) configuring imaging solutions.

USEFUL LINKS (http://www.yonaweb.be/webcenter_11g_ps3_tutorial_introduction_content_integration, http://docs.oracle.com/cd/E21043_01/doc.1111/e14495/configipm.htm

ISSUE : a repository error occured  unable to utilize socket connection to content server

SOLUTION : Need to start ucm_server1 and change the IP ADDRESS FILTER for UCM by accessing through weblogic server. In server1.yantro.com:7001, click on UCM and click configuration and modify IP ADDRESS FILTER like "127.0.0.1|127.0.0.1|*.*.*.*

Now login to the server1.yantro.com:16000/imaging and click on manage connection-> create content server connection->Name = ECM -> uncheck Use Local Content Server and add machin as server1.yantro.com and pool 4444. -> click next until finish.


IP ADDRESS FILTER FOR UCM : 127.0.0.1|127.0.0.1|0.0.0.0.0.0.0.1 BY DEFAULT