The Folders_g component by default sets a variable called AuthorDelete=true, which allows users without delete privileges on a security group to delete documents if they are the author. If using the Folders_g Oracle UCM component with the Managed Attachments solution, be aware that this variable's setting may override Managed Attachments dPrivilege or AppAdapterGrantPrivilege deletion settings.

A new feature has been added to the Oracle E-Business Suite adapter that allows administrators to target the same instance/conversation when multiple instances of a particular Oracle E-Business Suite screen are displayed. This feature is enabled through a new configuration parameter called AXF_MULTINSTANCE in the AXF_PROPERTIES table.

If AXF_MULTINSTANCE is set to TRUE, each Oracle E-Business Suite window is treated as a separate conversation and a separate Oracle I/PM or AXF window is targeted.

If AXF_MULTINSTANCE is set to FALSE (default), each Oracle E-Business Suite instance window is treated as the same conversation and uses the same Oracle I/PM or AXF target window.

34.2.3 Can Hide the Bottom Panel in the Task Viewer

If your imaging solution does not utilize the bottom panel on the Task Viewer, you can disable it in the AXF solution. For example, for an invoice processing solution, you may want to hide the bottom panel displaying General Ledger lines. Hiding the panel increases performance speed and screen space.

Follow these steps to hide the bottom panel:

Using a tool such as Oracle SQL Developer, open a connection to the AXF database.

Run the following query, and note the BLOCK_IDs in use for the bottom panel:

A new parameter in the AXF_SOLUTION_ATTRIBUTES table, USERNAME_PASS_THROUGH, allows the authenticated Oracle WebLogic Server user to perform tasks, such as BPEL tasks, rather than the user passed from Oracle E-Business Suite or Oracle PeopleSoft. This allows you to use different user stores for Oracle E-Business Suite/Oracle PeopleSoft and the Oracle WebLogic Server.

The AXF_SOLUTION_ATTRIBUTES table configuration is shown in Table 34-1.

34.2.5 Number of Tasks Displayed in Task List Now Configurable

A new parameter in the AXF_SOLUTION_ATTRIBUTES table, TASKLIST_RANGESIZE, enables you to configure the number of tasks to return in the Task List. For example, you might change the number from 25 (default) to 10 tasks.

The AXF_SOLUTION_ATTRIBUTES table configuration is shown in Table 34-2, where the PARAMETER_VALUE sets the number of tasks to return:

To avoid an issue with the Siebel Adapter for Oracle UCM, in which the Oracle UCM login page displays in the Siebel page instead of the iFrame, add the following entry to the Oracle UCM Config.cfg file:

AllowContentServerInAnyDomains=1

Note:

Be aware that setting the AllowContentServerInAnyDomains variable to 1 allows Oracle UCM pages to be opened in iFrames, which could pose a potential security issue.

34.3 Documentation Errata

This section describes documentation errata. It includes the following topics:

The Update Task From Procedure command calls a stored pl/sql procedure using a specified data source and updates the task payload using XPATH. See Section 34.3.3.2 for an example implementation and Section 34.3.3.3 for an example stored pl/sql procedure.

34.3.3.1 Update Task From Procedure Command Parameters

Table 34-3 Parameters for UpdateTaskFromProcedure Command

Parameter Key

Description

XPATH_DATASTRING

Specifies an XPATH variable contained in the AXF_XPATH_ATTRIBUTES Table that refers to the XPATH where the list of returned data is stored.

XPATH_MESSAGESTRING

Specify an XPATH variable to allow the UpdateFromStoredProcedure function to write data to the BPEL payload for communicating basic status or error codes encountered during execution of the function (axfretrieveuserlist).

CMD_NO_DATA

Specifies the command to execute if no results return from the pl/sql function.

CMD_DATA

Specifies the command to execute if results return from the pl/sql function.

CMD_ERROR

Specifies the command to execute if an error is returned from the pl/sql function.

JNDI_DS

Specifies the name of the JNDI data source, configured on the Application Server, to use for execution of the pl/sql function.

PLSQL_PROC

Specifies the name of the pl/sql function to call.

34.3.3.2 Example Implementation

This example uses the Update Task From Procedure command to call a stored pl/sql procedure called AXFRETRIEVEUSERLIST using a data source (EBSDS). AXFRETRIEVEUSERLIST retrieves the invoice ID, queries for the invoice amount for that transaction, and based on that amount, returns a set of users for invoice approval.

Modify this procedure to retrieve the specific pieces of data from the payload you would like. The only requirement is that the pl/sql function you create must take a VARCHAR2, set up two VARCHAR2 out parameters, and return an INTEGER. The name of the function is in the AXF configuration.

Install the stored procedure on the Oracle E-Business Suite database instance. The procedure must be run as the Apps user.

On the AXF instance and as the AXF user, run the following command to update the AXF_ACTIONS table to insert the new RetrieveUserList Command into the execution path: