Oracle® Fusion Middleware Administrator's Guide for Oracle E-Business Suite Adapter for Oracle Enterprise Content Management 11g Release 1 (11.1.1) Part Number E15865-02 |
|
|
View PDF |
This chapter describes how to install and configure the E-Business Suite components used by ECM solutions.
This chapter covers the following topics:
As part of AXF configuration, solution integrators configure the following E-Business Suite components.
In AXF, user interface .PLL extension modules are used to access workflow tasks (Imaging Solution) and documents associated with business records (both solutions).
The Custom.PLL module is slightly modified during installation to call AXF functions. It notifies AXF each time an E-Business Suite event occurs, allowing AXF to determine if it relates to AXF functionality. See "Compiling E-Business Suite Forms".
The AXF_Custom.PLL component performs the following functions:
Calls out to a web service to execute an AXF Command
Responds to the following AXF response commands:
Open Browser
Terminate Conversation
Renders menus to expose AXF functionality based on the E-Business Suite configuration database.
The following PL/SQL procedures are provided. (In some cases, separate E-Business Suite release 11 and 12 versions are provided.) See "Configuring the E-Business Suite Database".
PL/SQL Procedure | Purpose |
---|---|
AXF_CREATE_TABLES_SYNONYM | Creates the tables and synonyms used by AXF. |
AXF_EBS_PROPERTIES_DATA | Populates the AFX_PROPERTIES table with security information for various E-Business Suite calls to AXF. |
AXF_APPS_INIT | Required for E-Business Suite attachment. |
AXF_ADD_EBS_ATTACHMENT_PROC_R11
AXF_ADD_EBS_ATTACHMENT_PROC_R12 |
Creates a stored procedure that adds an attachment to a transaction in E-Business Suite. |
AXF_MANAGED_ATTACHMENT_DATA
AXF_MANAGED_ATTACH_AVAIL AXF_MANAGED_ATTACH_VALUES |
Required for document attachment. |
AXF_SOAP_CALL_PROC | Creates a stored procedure to make SOAP calls from PL/SQL. |
Configuring AXF for E-Business Suite requires configuring AXF-related tables in E-Business Suite. These tables are used to specify which screens are enabled to execute configured AXF commands. See "About the AXF Tables in E-Business Suite".
AXF-related E-Business Suite tables include the following:
AXF_CONFIGS Table
AXF_COMMANDS Table
AXF_COMMAND_PARAMETERS Table
AXF_PROPERTIES Table
AXF_FND_MAP Table
Installation of the E-Business Suite portion of AXF requires an active connection to the E-Business Suite database, general database experience, and knowledge of E-Business Suite Forms Builder. Consult your local DBA for assistance with these tasks. The instructions in this section assume the use of SQL*PLUS, but you can use any tool capable of querying the Oracle Database.
This section describes how to configure E-Business Suite components for the solutions. It covers the following topics:
The adapter uses an E-Business Suite database to store PL/SQL procedures and E-Business Suite configuration information. Follow these steps to create a database user for use by AXF within the E-Business Suite database.
Create a user named AXF
.
A system account username and password is required to create the user. For assistance creating the user, contact your DBA.
Assign the configuration schema user the following access privileges:
Create table
Create sequence
Create public synonym
Create session
Create procedure
Unlimited tablespace
Follow these steps.
Locate the scripts in the following folders. Separate folders are provided for E-Business Suite releases 11 and 12.
MW_HOME/ECM_HOME
/axf/adapters/ebs/R12/
MW_HOME/ECM_HOME
/axf/adapters/ebs/R11/
Using SQL*PLUS, log in to the E-Business Suite database as the AXF E-Business Suite configuration schema user.
This user was previously created, as described in "Creating the AXF E-Business Suite Configuration Schema User (AXF)".
As the AXF user, execute the AXF_CREATE_TABLES_SYNONYM script from the applicable E-Business Suite location. This script creates the tables and synonyms used by AXF.
To execute the script, enter:
@AXF_CREATE_TABLES_SYNONYM.sql
Verify that the following tables were created: AXF_COMMAND_PARAMETERS, AXF_COMMANDS, AXF_CONFIGS, AXF_PROPERTIES, and AXF_FND_MAP.
As the AXF user, execute the AXF_EBS_PROPERTIES_DATA script from the applicable E-Business Suite location.
To execute the script, enter:
@AXF_EBS_PROPERTIES_DATA.sql
As the APPS user, execute the AXF_APPS_INIT script from the applicable E-Business Suite location.
Execute the script by entering:
@AXF_APPS_INIT.sql
As the APPS user, execute the AXF_ADD_EBS_ATTACHMENT_PROC_12 or AXF_ADD_EBS_ATTACHMENT_PROC_11 script from the applicable E-Business Suite location. This script creates a stored procedure for inserting attachments to the transaction record.
Execute the script by entering the command appropriate for your version:
@AXF_ADD_EBS_ATTACHMENT_PROC_R12.sql
@AXF_ADD_EBS_ATTACHMENT_PROC_R11.sql
Note:
This compilation may result in warnings, which can be ignored.As the APPS user, execute the AXF_MANAGED_ATTACH_AVAIL, AXF_MANAGED_ATTACH_VALUES, and AXF_MANAGED ATTACHMENT_DATA scripts from the applicable E-Business Suite location.
Execute the scripts by entering:
@AXF_MANAGED_ATTACH_AVAIL.sql
@AXF_MANAGED_ATTACH_VALUES.sql
@AXF_MANAGED_ATTACHMENT_DATA.sql
As the APPS user, execute the AXF_SOAP_CALL_PROC script from the applicable E-Business Suite location. This script creates a stored procedure to make SOAP calls from PL/SQL.
Execute the script by entering:
@AXF_SOAP_CALL_PROC.sql
AXF installation requires certain files to be uploaded to the E-Business Suite system, which enables a seamless integration of custom actions with existing E-Business Suite Forms.
Note:
For information on using Oracle Forms Builder, see the following E-Business Suite documentation:http://www.oracle.com/technology/documentation/applications.html
Follow these steps to copy the AXF_CUSTOM.pld file, convert it to an AXF_CUSTOM.pll file, make modifications, and then compile it to an AXF_CUSTOM.plx file.
For the applicable version listed below, copy the AXF_CUSTOM.pld file to the E-Business Server (to FORMS_PATH for E-Business Suite 12, or FORMS60_PATH for E-Business Suite 11).
E-Business Suite 12: MW_HOME/ECM_HOME
/axf/adapters/ebs/R12/AXF_CUSTOM.pld
E-Business Suite 11: MW_HOME/ECM_HOME
/axf/adapters/ebs/R11/AXF_CUSTOM.pld
Note:
If you are using a Linux/UNIX system and copied the .PLD from a Windows system, issue thedos2unix
command before converting it below.Open Oracle Forms Builder and connect to the E-Business Suite database as the APPS user. Forms Builder is typically located in the /bin/
subdirectory of your database's Oracle home.
Note:
Be sure to connect to the E-Business Suite database. If you fail to connect, verify the tnslistener.ora file.In Forms Builder, open and convert AXF_CUSTOM.pld
to AXF_CUSTOM.pll
, by selecting File, then Administration, then Convert. Select PL/SQL libraries and Text to binary while converting the file.
Note:
If the following error is displayed during conversion of AXF_CUSTOM.pld to AXF_CUSTOM.pll, repeat this step until the file successfully converts.PDE-PLI038 - Can not open file as a PL/SQL Library
Note:
If the following error is displayed during conversion, click OK repeatedly until the file successfully converts.PDE-PLI018 - Could not find library AXF_CUSTOM
From the File menu, open AXF_CUSTOM.pll.
Select Program, then Compile pl/sql, then All (E-Business Suite 12) or Program, then Compile, then All (E-Business Suite 11).
Compile AXF_CUSTOM
into a module (.plx
) by selecting Program, then Compile Module (E-Business Suite 12) or File, then Administration, then Compile File (E-Business Suite 11).
Notes:
AXF_CUSTOM must be compiled using the APPS schema user ID.
If you encounter the following identifier or other errors referencing objects in APPCORE.pll while compiling, this indicates that the APPCORE.pll
file must be attached to your form:
'APP_SPECIAL.ENABLE' must be declared
(a).
Select File then Connect and ensure that you are connected to the database as the APPS user.
Back up the CUSTOM.pll
file.
WARNING:
Modifications to CUSTOM.pll are modifications to the E-Business Suite infrastructure. Ensure that this file is appropriately backed up before making changes.
Open CUSTOM.pll
by selecting File, then Open and selecting PL/SQL Libraries (*.pll) in the Files of Type field. After opening the file and expanding Program Units, right-click the custom package body of CUSTOM.pll and select pl/sql editor.
In CUSTOM.pll
, modify the following text formatted in bold italics for the solutions you are configuring. If the file contains other customizations, place these modifications after the existing code inside each function/procedure.
For Managed Attachments Only or Both Solutions:
function zoom_available return boolean is
begin
-- Required for ALL integrations
return true;
end zoom_available;
For Imaging Solution Only:
function zoom_available return boolean is
begin
-- Required for ALL integrations
return AXF_CUSTOM.zoom_available();
end zoom_available;
In CUSTOM.pll
, modify the following text formatted in bold italics. If the file contains other customizations, place these modifications after the existing code inside each function/procedure.
procedure event(event_name varchar2) is
begin
-- Required for AXF integrations
AXF_CUSTOM.event(event_name);
null;
end event;
With CUSTOM.pll
open, determine if AXF_CUSTOM is listed as an attached library.
If it is listed, highlight AXF_CUSTOM and click the minus (-) symbol to detach it. Then reattach AXF_CUSTOM by highlighting Attached Libraries under CUSTOM and clicking the plus (+) symbol; browse to AXF_CUSTOM.pll and select it.
If it is not listed, attach AXF_CUSTOM by highlighting Attached Libraries under CUSTOM and clicking the plus (+) symbol; browse to AXF_CUSTOM.pll and select it.
When prompted to remove the path, click Yes.
With CUSTOM.pll
open, select Program, then Compile pl/sql, then All (E-Business Suite 12) or Program, then Compile, then All (E-Business Suite 11).
Compile CUSTOM into a module (.plx) by selecting Program, then Compile Module (E-Business Suite 12) or File, then Administration, then Compile File (E-Business Suite 11).
Save all before exiting Forms Builder. Verify that the Zoom menu command is displayed in the appropriate E-Business Suite forms.
This section covers the following topics:
Follow these steps to configure SOAP security, in which the application sends the SOAP user and password in the header for authentication.
Enable SOAP security by specifying TRUE
for the AXF_SOAP_SECURITY property in the AXF_PROPERTIES table (see "AXF_PROPERTIES Table").
Set the AXF_SOAP_POLICY property to USER_NAME_TOKEN
.
Store the SOAP password in the database vault by executing the following command as APPS schema:
execute fnd_vault.put('AXF','
AXF_SOAP_USER
','
SOAP_PASSWORD
');
Where AXF_SOAP_USER is the SOAP user id used in the SOAP header for authentication, and SOAP_PASSWORD is the SOAP password.
Verify the previous command with this statement:
select fnd_vault.get ('AXF','
AXF_SOAP_USER
') from dual;
Follow the steps in this section to apply the wss_username_token_service_policy to all web services via the WebLogic Server Administration Console.
Log in to the WebLogic Server Administration Console.
From the Domain Structure options, select Deployments. The Summary of Deployments page is displayed.
From the Deployments table, select imaging.
Click the Update button. The Update Application Assistant page is displayed.
Select the lower Redeploy this application using... option to redeploy the ear file with a deployment plan.
Click the Change Path button for the Deployment plan path option, browse to the following location, and select the Plan.xml file:
MW_HOME
/user_projects/applications/
domain_name
/server/ipm
Continue the wizard and complete the deployment.
You may want to examine the following AXF-related logs:
Use the AXF logs to isolate issues in solution configuration. By default, some AXF logging automatically occurs as part of Application Server logging. Follow these steps to configure more detailed and separate AXF logging.
Add a log handler to the Application Server configuration. Add the handler inside the <log_handlers> tag in the logging.xml file, at the following location:
DOMAIN
/config/fmwconfig/servers/
SERVER
/logging.xml
An example location follows:
base_domain/config/fmwconfig/servers/IPM_Server1/logging.xml
<log_handler name='axf-handler'class='oracle.core.ojdl.logging.ODLHandlerFactory' level='ALL'> <property name='path' value='${domain.home}/servers/${weblogic.Name}/logs/axf.log'/> <property name='maxFileSize' value='5485760'/> <property name='maxLogSize' value='54857600'/> <property name='encoding' value='UTF-8'/> </log_handler>
Add a logger to the logging.xml file and set the level from the Log Levels (ODL Message Types) listed in Table 2-1. You can set the logging level in the XML file or using Enterprise Manager.
<logger name='oracle.imaging.axf' level='TRACE:32' useParentHandlers='false'> <handler name='axf-handler'/> <handler name='console-handler'/> </logger>
Note:
Remove the console-handler tag to omit logging on the console.Table 2-1 Available Logging Levels
Log Type | Description | Log Level (ODL Message Type) |
---|---|---|
NULL |
The logger inherits the log level set for its parent. |
n/a |
SEVERE |
Log system errors requiring attention from the system administrator. |
ERROR:1 |
WARNING |
Log actions or conditions discovered that should be reviewed and may require action before an error occurs. |
WARNING:1 |
INFO |
Log normal actions or events. This could be a user operation, such as login completed, or an automatic operation, such as a log file rotation. |
NOTIFICATION:1 |
CONFIG |
Log configuration-related messages or problems. |
NOTIFICATION:16 |
FINE |
Log trace or debug messages used for debugging or performance monitoring. Typically contains detailed event data. |
TRACE:1 |
FINER |
Log fairly detailed trace or debug messages. |
TRACE:16 |
FINEST |
Log highly detailed trace or debug messages. |
TRACE:32 |
Restart Administration Server if it is running. The logger is displayed in Enterprise Manager. You can change the logging level at run time.
You enable logging for specific forms in the AXF_CONFIGS Table. For details, see "Enabling E-Business Suite Logging".
For information about Content Server logging, see the Oracle Fusion Middleware System Administrator's Guide for Universal Content Management.
Follow these steps to uninstall AXF from E-Business Suite.
Assign the AXF configuration schema user the following privileges:
Drop table
Drop sequence
Drop public synonym
As the AXF user, execute the AXF_DROP_TABLES_SYNONYM script for your E-Business Suite version, from the applicable location listed below. This script drops all tables, synonyms, and sequences created by the AXF_CREATE_TABLES_SYNONYM script run during installation.
E-Business Suite 12: MW_HOME/ECM_HOME
/axf/adapters/ebs/R12/AXF_DROP_TABLES_SYNONYM.sql
E-Business Suite 11: MW_HOME/ECM_HOME
/axf/adapters/ebs/R11/AXF_DROP_TABLES_SYNONYM.sql
Execute the script by entering:
@AXF_DROP_TABLES_SYNONYM.sql
Remove the AXF database schema user.
Remove AXF_CUSTOM.* (AXF_CUSTOM.pll, AXF_CUSTOM.pld, and AXF_CUSTOM.plx) from FORMS_PATH
(or FORMS60_PATH
on E-Business Suite 11 systems).
Restore the CUSTOM.pll file you backed up in step 7 in "Compiling E-Business Suite Forms".
Open Oracle Forms Builder and connect to the E-Business Suite database as the APPS user. Forms Builder is typically located in the /bin/
subdirectory of your database's Oracle home.Open the restored CUSTOM.pll
by selecting File, then Open and selecting PL/SQL Libraries (*.pll) in the Files of Type field.With CUSTOM.pll
open, select Program, then Compile pl/sql, then All (E-Business Suite 12) or Program, then Compile, then All (E-Business Suite 11).Compile CUSTOM into a module (.plx) by selecting Program, then Compile Module (E-Business Suite 12) or File, then Administration, then Compile File (E-Business Suite 11).Save all before exiting Forms Builder.