Sean Hoppe Consulting Group

A2A Suggestions:

·         Set-up error notifications. Update TL Business process scripts to allow for error notifications

·         Grouping of like EDOC records. This process will only process a set of records, for a single EDOC, in a single EXTOL transformation. Currently all EDOCs are processed at once and this process can cause significant labor intensive processes to clean-up unnecessary tables. By implementing an application analysis ruleset (BPS) we can process each EDOC individually

·         Update both header and detail records as processed. Currently Vicki is finding that not all the detail records are being updated when processed in the A2A processes. After we set-up Grouping of like EDOC records we can review the ruleset and binding set-ups such as below:

o   Update ruleset to have detail record, and additional records, updated:

 

o    Update Data Binding for each respective record that needs to be updated:

·         Review processing of large datasets > 10,000 records. After EBI 2.6 is installed Generation Brands should test through-put of large record transactions of > 10,000. I am suspecting there will be a need for a larger allocation of memory needed.

·         Update EXTOL DataSource and/or binding to allow for auto rollback. By configuring EXTOL for auto rollback we can ensure orphan records do not exist. In previous conversations with EXTOL support, I received multiple methods to perform the auto rollback.

o   Method 1: Update Datasource to conform to Oracle JDBC specs*

o   Method 2: Update binding for Full Transaction (below)

*Since the default undo management mode is MANUAL, the instance must be told to use AUTO mode at instance start up. To do this the following initialization parameters can be set:

UNDO_MANAGEMENT = AUTO # Default is MANUAL

UNDO_TABLESPACE = undotbs_01 # The name of the undo tablespace.

UNDO_RETENTION = 900 # The time undo is retained.

# Default is 900 seconds.

UNDO_SUPPRESS_ERRORS = TRUE # Suppress errors when MANUAL undo admin

# SQL statements are issued.

http://www.oracle-base.com/articles/9i/AutomaticUndoManagement.php
http://docs.oracle.com/cd/B14117_01/server.101/b10739/undo.htm#ADMIN013
http://docs.oracle.com/cd/B19306_01/appdev.102/b14261/rollback_statement.htm