4.5 AXF_PROPERTIES Table

Use the AXF_PROPERTIES table to define properties for AXF integration for E-Business Suite.

4.5.1 Column Description

Table 4-7 Column Description for AXF_PROPERTIES Table

Column	Description
PROPNAME	Specifies properties to be used. Properties include: SecureMode: To enable SSL, set this property to ON, and set values for AXFWalletPath and AXFWalletPwd properties. AXFWalletPath: Certificate location (path). AXFWalletPwd: Password for Wallet Manager. AXF_VERSION: Specify 1 for AXF 10g, or 2 for AXF 11g. AXF_SOAP_SECURITY: Specify TRUE to enable SOAP security, as described in "Setting SOAP Security". AXF_SOAP_USER: Specify the SOAP userid used in the SOAP header for authentication, as described in "Setting SOAP Security". AXF_SOAP_POLICY: Specify the name of the SOAP policy to be used. The currently supported policy is USER_NAME_TOKEN.
PROPVALUE	Specifies the property's value.

4.5.2 Example Implementation

This example table shows the default properties values.

Table 4-8 Example AXF_PROPERTIES Table

PROPNAME	PROPVALUE
SecureMode	OFF
AXFWalletPath	file:<walletpath>
AXFWalletPwd	walletpassword
AXF_VERSION	2
AXF_SOAP_POLICY	USER_NAME_TOKEN
AXF_SOAP_SECURITY	FALSE
AXF_SOAP_USER	AXF

4.5.2.1 Setting SOAP Security

Follow these steps to configure SOAP security, in which the application sends the SOAP user and password in the header for authentication.

1. Enable SOAP security by specifying TRUE for the AXF_SOAP_SECURITY property in the AXF_PROPERTIES Table.

2. Set the AXF_SOAP_POLICY property to USER_NAME_TOKEN.

3. 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.

4. Verify the previous command with this statement:

   select fnd_vault.get ('AXF','<AXF_SOAP_USER>') from dual;