Oracle Fusion Middleware Oracle E-Business Suite Adapter User's Guide

Skip Headers

Contents

Overview

This appendix describes the properties applicable to the Oracle E-Business Suite Adapter, including:

For more information about JCA properties, see:

Section A.11, Generic Oracle JCA Adapter Properties, Oracle Fusion Middleware Understanding Technology Adapters for properties applicable to all Oracle JCA Adapters
Configuring Oracle JCA Adapters, Oracle Fusion Middleware Administering Oracle SOA Suite and Oracle Business Process Management Suite
Appendix E, Propagating Normalized Message Properties Through Message Headers, Oracle Fusion Middleware Developing SOA Applications with Oracle SOA Suite

JCA Properties for Oracle E-Business Suite Adapter

The following table lists the JCA properties used for Oracle E-Business Suite Adapter:


Property	Description
`SchemaName`	The schema of the Oracle E-Business Suite. Usually points to the “Apps” or Apps-equivalent schema.
`PackageName`	Name of the PL/SQL package or the wrapper package.
`ProcedureName`	Name of the procedure or function to be invoked. Points to Wrapper procedure / function if present.
`DataSecurityCheck`	Passing this property with a value of “yes” enables function security check for PL/SQL APIs and Concurrent Programs.
`QueryTimeout`	This property specifies the maximum number of seconds that the JDBC driver should wait for the specified stored procedure or function to execute. When the threshold is exceeded, SQLException is thrown. If the value is zero, then the driver waits indefinitely.
`APIErrorHandler`	Passing this property enables the caller to retrieve error messages from FND_MSG_PUB message stack, without the need for another explicit call to retrieve them.
`GetActiveUnitOfWork`	If it is set to "true", this advanced setting forces all invoked activities in the same global transaction to use the same SQL connection if going to the same database. This guarantees that later invoked activities can see the changes of earlier invoked activities. (However, this may not be needed if using emulated two-phase commit, which automatically uses the same connection.)
`IRepOverloadSeq`	This is automatically populated and is not user-configurable. It works in conjunction with “DataSecurityCheck” property. Note: This property should not be altered by end users and modification might lead to undesirable results.
`IRepInternalName`	Holds an internal value used by Oracle E-Business Suite Adapter. Note: This property should not be altered by end users and modification might lead to undesirable results.

The following JCA properties are specific to Enqueue and Dequeue operations that are applicable for XML Gateway and Business Event Outbound interfaces:


Property	Description
`QueueName`	The name of the AQ Queue being read from or written to.
`DatabaseSchema`	The schema of the Oracle E-Business Suite. Usually points to the “Apps” or Apps-equivalent schema.
`Consumer`	Name of the AQ Consumer, which dequeues the messages from the AQ Queue.
`MessageSelectorRule`	Specifies the condition based on payload or queue header values, to screen the messages and accept only those that meet the condition. Note: This property should not be altered by end users and modification might lead to undesirable results.
`AppsEventSchema`	Passing one of the following event schema selection options to be used for the business event payload: No Schema Any Schema Specify Schema For information on each schema selection option, see Specifying Event Schema.

JCA Properties for Oracle E-Business Suite Adapter: Normalized Properties

The following table lists the normalized message properties used for Oracle E-Business Suite Adapter:


Property	Description
`jca.apps.Username`	This property specifies the Oracle E-Business Suite application username information. In the case of a null or empty value, the default Username is `SYSADMIN`,
`jca.apps.Responsibility`	This property specifies the Oracle E-Business Suite application responsibility information for setting applications context. The default Responsibility is `System Administrator`.
`jca.apps.ORG_ID`	This property specifies the organization ID used in Oracle E-Business Suite application.
`jca.apps.RespApplication`	This property specifies the responsibility application short name information for setting applications context. It accepts Application Short Name (such as FND) as its value.
`jca.apps.SecurityGroup`	This property specifies the security group information for setting applications context. The default Security Group Key is `Standard`,
`jca.apps.NLSLanguage`	This property specifies the NLS language information. The default NLS Language is `US`, It is used for multiple language support (MLS) feature for Oracle E-Business Suite.
`jca.apps.ecx.TransactionType`	This property specifies External Transaction Type for the business document from the Trading Partner table. The transaction type for an inbound XML document must be the same as the transaction type defined in the Trading Partner form. This property sets XML Gateway message header information required for XML Gateway inbound transactions.
`jca.apps.ecx.TransactionSubtype`	This property specifies External Transaction Subtype for the business document from the Trading Partner table. The transaction subtype for an inbound XML document must be the same as the transaction subtype defined in the Trading Partner form. Similar to `jca.apps.ecx.TransactionType`, this property sets XML Gateway message header for XML Gateway inbound transactions
`jca.apps.ecx.PartySiteId`	This property specifies the party site identifier for an inbound XML document. The party site must be the same as the Source Trading Partner location defined in the Trading Partner form. This property is used to set XML Gateway message header.
`jca.apps.ecx.MessageType`	This property sets XML Gateway message header for payload message format. This defaults to `XML`.
`jca.apps.ecx.MessageStandard`	This property sets XML Gateway message standard. Message format standard as displayed in the Define Transactions form and entered in the Define XML Standards form. This defaults to OAG. The message standard entered for an inbound XML document must be the same as the message standard in the trading partner setup.
`jca.apps.ecx.DocumentNumber`	This property sets document number for XML Gateway. The document identifier used to identify the transaction, such as a purchase order or invoice number.
`jca.apps.ecx.ProtocolType`	This property specifies the protocol type for setting XML Gateway message header.
`jca.apps.ecx.ProtocolAddress`	This property specifies the protocol address for setting XML Gateway message header.
`jca.apps.ecx.Username`	This property specifies the username for setting XML Gateway message header. `USERNAME` is defined in the Trading Partner table.
`jca.apps.ecx.Password`	This property specifies the password associated with the `USERNAME` that is defined in the Trading Partner table.
`jca.apps.ecx.Attribute1`	This property specifies the Attribute1 parameter that may be defined by the base application.
`jca.apps.ecx.Attribute2`	This property specifies the Attribute2 parameter that may be defined by the base application.
`jca.apps.ecx.Attribute3`	This property specifies the Attribute3 parameter. For outbound messages, this parameter has the value from the Destination Trading Partner Location Code in the Trading Partner table. For inbound messages, the presence of this value generates another XML message that is sent to the trading partner identified in the Destination Trading Partner Location Code in the Trading Partner table. This value must be recognized by the hub to forward the XML message to the final recipient of the XML Message. For more information, see Destination Trading Partner Location Code, Oracle XML Gateway User's Guide.
`jca.apps.ecx.Attribute4`	This property specifies the Attribute4 parameter that may be defined by the base application.
`jca.apps.ecx.Attribute5`	This property specifies the Attribute5 parameter that may be defined by the base application.
`jca.apps.ecx.Payload`	This property specifies the payload information for XML Gateway transactions.

Binding Properties for Oracle E-Business Suite Adapter

The following table lists the binding properties used for Oracle E-Business Suite Adapter:


Property	Description
`DequeueTimeOut`	It is the interval after which the dequeue() API will time out if no message is received on the inbound queue. The default value is 1s.
`ConnectionRetryDelay`	The time for which Oracle E-Business Suite Adapter will wait before trying to re-create a connection after a connection is lost. The default value is 15s

Oracle E-Business Suite Adapter Properties

Overview

JCA Properties for Oracle E-Business Suite Adapter

JCA Properties for Oracle E-Business Suite Adapter: Normalized Properties

Binding Properties for Oracle E-Business Suite Adapter