Description:
TIBCO ActiveMatrix BusinessWorks™ Plug-in for Oracle E-Business Suite 1.2.0 Hotfix01 is released for all supported platforms. Hotfixes are cumulative. This is the first hotfix for TIBCO ActiveMatrix BusinessWorks Plug-in for Oracle E-Business Suite 1.2.0. Listed below is a summary of updates included in Hotfix 01. Please refer to the attached Readme for additional details.

================================================================================
Closed Issues in 1.2.0_HF-001 (This Release)

AEBS-234
An error was thrown in the Output tab of the Oracle API activity if no value was
entered in the Input tab of the activity.

AEBS-236
The order of the returned values was not correct when using the PL/SQL API to
query the OBJECT datatype or the TABLE datatype.

AEBS-237
The APPS_INITIALIZE and SETCLIENTINFO options were not included in the
Oracle API and Custom API activities.

This is an enhancement. This hotfix adds a Prerequisite tab to the Oracle API
and Custom API activities respectively, which allows users to call some
Set Client Info and Initialization procedures before calling the main procedure
picked in the Configuration tab.

Users can add new procedure calls and their corresponding package information in
the Prerequisite tab. When the procedure needs to be wrapped, users need to enter
a wrapper package and select a procedure for the wrapper package.
Note: If the procedure name for the wrapper package contains a single dollar
sign ($), the $ in the procedure name will be converted to a hyphen (-) in the
Input and Output tabs.

*Wrapper package known issues:

The wrapper generated by Oracle Jpublisher might have issues preventing it from
being executed successfully. In such cases users need to manually modify these
wrappers. Here are the know issues:

1, QP_PREQ_PUB: 'PRICE_REQUEST' function will raise a 'NO_DATA_FOUND' error
   at wrapper package line 677.

   Workaround: Edit wrapper package source code, ignore the 'NO_DATA_FOUND'
   error come from line 677, then the function will run successfully.
  
2, OE_ORDER_PUB: When use the 'PROCESS_ORDER' procedure to enter order, it
   returns 'U' status with error message'ORA-06502: PL/SQL: numeric or value
   error: NULL index table key value in Package OE_Delayed_Requests_PVT
   Procedure LOGREQUEST'.

   Workaround: Edit wrapper package source code and enter wrapper package body.
   Find the 'SQL_TO_PL1' and 'SQL_TO_PL28' functions, initialize the aPlsqlItem
   variable. If the corresponding item of the aSqlItem variable is null in the
   BEGIN section, do not assign it to aPlsqlItem variable item.


This hotfix can be downloaded from the TIBCO Product Support ftp server, ftp://support-ftp.tibco.com/, using your username and password for the TIBCO Support Web.  Once logged on you can find the hotfix under:

available_downloads/ActiveEnterprise/BusinessWorks/Plugins/OEBS/1.2.0/hotfix-01/


Please contact TIBCO Support if you have any problems finding or downloading this hotfix.

TIBCO ActiveMatrix BusinessWorks™ Plug-in for Oracle E-Business Suite 1.2.0 Hotfix01 is now available.

Product: TIBCO BusinessWorks Plug-in for Oracle E-Business Suite Version: 1.2.0 OS: All --------------------