PL/SQL user exit procedures

The Oracle adapter installs skeleton PL/SQL user exit procedures for every enterprise service and publish channel.

The PL/SQL user exit procedures reside in the following directory:

rootdirectory\ORACLEAPIS\apisuser

Outbound PL/SQL user exit procedures

In outbound processing, the PL/SQL user exit provides the opportunity to map additional data or modify default mapping to the Oracle open interface table, or to skip the record. The outbound PL/SQL user exit is called just before data is inserted in the Oracle open interface table. The user exit processing typically has three parameters:

  • The IBM® Maximo® Asset Management interface table record
  • The Oracle open interface table records
  • The skip_transaction flag

If the skip_transaction flag is set to true, the integration framework immediately exits the process and does not insert any more records. However, in the case of item records, a skip_transaction can skip the insert and update (or delete and insert) the current record, not immediately exit the process, and go on to insert and update other records.

Inbound PL/SQL user exit procedures

In inbound processing, the PL/SQL user exit provides the opportunity to map additional data or modify default mapping to the IBM Maximo Asset Management interface table, or to skip the record. The inbound PL/SQL exit is called just before data is inserted in the IBM Maximo Asset Management interface table. The user exit processing typically has three parameters:

  • The Oracle base table records
  • The IBM Maximo Asset Management interface table record
  • The skip flags

If the skip_transaction flag is set to true, the integration framework immediately exits the process and does not insert any more records. If the user exit procedure has a skip_line flag that is set to true, the integration framework skips the insert of the current line record and continues processing without skipping other lines.

Note: Do not modify any PL/SQL files besides user exit procedures. You can identify the types of PL/SQL files by their file extension.
Table 1. PL/SQL file types and extensions

PL/SQL file

File extension

Installation scripts

 .sql

PL/SQL packages

 .pkg

PL/SQL package definition

 .psp

Stored procedures

 .sp

User exit procedures

 .usp

Triggers

 .trg