Enabling interim fix JR47728

Interim fix JR47728 improves the performance of Promotion Code Generation by using the Oracle DML Error Log feature that is found in Oracle 10.2 or higher. This APAR requires the creation of a new table that must be run on Oracle only. If the table does not exist, WebSphere Commerce uses the generic method for generating promotion codes. Run this procedure on the staging environment only, as that is where promotion codes are generated.

Before you begin

Install the cumulative interim fix for Feature Pack 5, JR53048.fep.


  1. Locate the database table creation file. The file might reside in one of the following paths:
    • WC_installdir/schema/oracle/apar/wcs.schema.px_cdpool_error.sql or WC_installdir/components/foundation/schema/fep5/apar/wcs.schema.px_cdpool_error.sql
    • WebSphere Commerce DeveloperWCDE_installdir/schema/oracle/apar/wcs.schema.px_cdpool_error.sql or WCDE_installdir/components/foundation/schema/fep5/apar/wcs.schema.px_cdpool_error.sql
  2. Run the file to create the database table.
    For example, enter the following commands
    1. sqlplus -S [username]/[password]@[connection-spec]
    2. @[WC_installdir]/schema/oracle/apar/wcs.schema.px_cdpool_error.sql;
    3. quit;
    • [username] refers to the username that is authorized to create objects on the appropriate schema
    • [password] refers to the password for [username]
    • [connection-spec] refers to the SID or TNS service-name or expanded service-name of the WebSphere Commerce Oracle instance
    • If the schema that is associated with tables in the database is not the default ([username]) in most cases, you might need to invoke a schema change. For example, to change the schema name
      • If database back end is Oracle, issue the following statement before line 2
        alter session set current_schema=[schemname]
      • Here, [schemaname] refers to the schema that is associated with tables in the WebSphere Commerce database