Integration control details

Control name

Name of the integration control

Description

A brief description of the control

Type

Control type:

B = Boolean

L = List

V = Value

X = Cross‐reference

Domain

If applicable, the name of the Maximo® Asset Management domain that contains the valid value(s) for the control.

N/A = Domains are not applicable to the control

N = No domain

Organization and site

Indicates if the system‐level control value can be overridden at the organization or site level

N = Neither

O = Organization

S = Site

Value

The predefined value(s) of the control

(D) = default value

APLINETYPE

Default invoice line type in Oracle E‐Business Suite

V

N

S

ITEM (D)

APSEND

Status(es) at which invoices are sent from Maximo Asset Management to Oracle E‐Business Suite

L

IVSTATUS

S

APPR

CATEGORYXREF

Cross‐reference an item category and the Oracle E‐ Business Suite stock‐enabled flag

X

CATEGORY

S

STK = Y

NS = N

COAXREF

Cross‐reference an organization ID and the Oracle E‐Business Suite chart of accounts ID

X

N

N

Null (D)

CONVHRS

Hours to convert annual salary to hourly rate

V

N

N

2080

CRAFTXREF

Multiply the Oracle E‐Business Suite craft code to organizations

X

N

N

Null (D)

DTC_EXP

Destination type code for direct issue PO lines

V

N

S

EXPENSE (D)

DTC_INV

Destination type code for replenishment PO lines

V

N

S

INVENTORY (D)

GENITEM

Dummy identifier for masking item number

V

N

S

Null (D)

GENSTORE

Dummy identifier for masking storeroom on outbound transaction

V

N

S

Null (D)

GENUSR

Dummy identifier for masking user ID in outbound transactions

V

N

O

Null (D)

GLCURNCY

Default GL currency code in the Oracle E‐Business Suite

V

N

O

USD (D)

GLCURNCYTYPE

Type of currency exchange rates

V

N

O

User (D) or Corporate

GLSOURCE

Source business object of a general ledger journal

L

GLSOURCE

S

Null

INVCSTATUSXREF

Translate internal and external invoice status, if using synonyms

X

N

S

APPR=APPR

PAID=PAID

INVCTYPEXREF

Cross‐reference Maximo Asset Management Asset management and Oracle E‐Business Suite invoice document types

X

INVTYPE

S

INVOICE = STANDARD

CREDIT = CREDIT

DEBIT = DEBIT

ITMSUBXREF

Cross‐reference Oracle E‐Business Suite inventory organization and default subinventory code

X

N

S

Null (D)

JECATXREF

Cross‐reference a transaction type and Oracle E‐ Business Suite journal category

Valid transaction types:

AVGCSTADJ, CAPCSTADJ, CREATEASSET, CURBALADJ, CURVAR, INSERTITEM, INVCEVAR, KITCOSTVAR, MATRECTRANS‐ INVOICE, MATRECTRANS‐KITBREAK, MATRECTRANS‐KITMAKE, MATRECTRANS‐ MISCLRECEIPT, MATRECTRANS‐POCOST, MATRECTRANS‐RECEIPT, MATRECTRANS‐ RETURN, MATRECTRANS‐TRANSFER, MATUSETRANS‐INVOICE, MATUSETRANS‐ ISSUE, MATUSETRANS‐KITBREAK, MATUSETRANS‐KITMAKE, MATUSETRANS‐ MISCLRECEIPT, MATUSETRANS‐POCOST, MATUSETRANS‐RETURN, MATUSETRANS‐ TRANSFER, NON‐WORK, OT‐REF, PCOUNTADJ, RECBALADJ, SERVRECTRANS, SICK, STDCSTADJ, STDRECADJ, TAX1, TAX2, TAX3, TAX4, TAX5, TOOLTRANS, TOTAL, TRAV, VAC, WMATL, WORK

X

N

O

Null (D)

JEPROJSEND

The project transaction types to be sent to Oracle E‐Business Suite

L

GLSOURCE

O

LABTRANS

MATRECTRANS

MATUSETRANS

SERVRECTRANS

TOOLTRANS

LABXREF

Multiply an Oracle E‐Business Suite labor code to organizations

X

N

N

Null (D)

LANGXREF

Cross‐reference a language code and the Oracle E‐ Business Suite process set ID

X

N

N

Null (D)

LINETYPEXREF

Cross‐reference a line type (synonyms) and the Oracle E‐Business Suite line type

X

LINETYPE

S

EXTERNAL = Goods

ITEM = Goods

MATERIAL = Goods

SERVICE = Services

SPORDER = Goods

STDSERVICE = Services

TOOL = Goods

LOTTYPEXREF

Cross‐reference the Maximo Asset Management and the Oracle E‐Business Suite lot control indicators

X

LOTTYPE

O

NOLOT = 1

LOT = 2

OACATXREF

Cross‐reference the line type and the Oracle E‐ Business Suite item or service category identifier.

Note: Cross‐reference a value ITEM to an external value Null so the category defaults based on item number and destination organization

X

LINETYPE

S

Null (D)

OAITMLOTPREFIX

Lot prefix for lot controlled item

V

N

S

Null (D)

OAITMLOTSTARTNUM

Lot start number for lot controlled item

V

N

S

Null (D)

OAPCDEFORDERUNIT

Order unit default on purchase contract line when no unit of measure is specified on a purchase contract line in Oracle

V

N

S

Null (D)

ORGXREF

Cross‐reference an organization and the Oracle E‐ Business Suite ledger ID

X

N

N

Null (D)

PCSEND

Statuses at which contracts are sent from Maximo Asset Management to Oracle E‐Business Suite

L

CONTRACTSTATUS

O

APPR

PCSTATUSXREF

Cross‐reference the internal and external contract status, if using synonyms

X

CONTRACTSTATUS

O

APPR = APPR

CAN = CAN

CLOSE = CLOSE

PCTYPEXREF

Cross‐reference Maximo Asset Management and Oracle E‐Business Suite contract types

X

CONTRACTTYPE

O

BLANKET = BLANKET

BLANKET = CONTRACT

BLANKET = PLANNED

POSEND

Statuses at which purchase orders are sent from Maximo Asset Management to Oracle E‐Business Suite

L

POSTATUS

S

Any PO status

APPR (D)

POSTATUSXREF

Cross‐reference the internal and external PO status, if using synonyms

X

POSTATUS

S

APPR = APPR

POTYPEXREF

Cross‐reference Maximo Asset Management and the Oracle E‐Business Suite purchase order types

X

POTYPE

S

STD = STANDARD

REL = RELEASE

PRSEND

Statuses at which purchase requisitions are sent from Maximo Asset Management to Oracle E‐ Business Suite

L

PRSTATUS

S

Any PR status

APPR (D)

PRSTATUSXREF

Cross‐reference the internal and external PR status, if using synonyms

X

PRSTATUS

S

APPR = APPR

CAN = CAN

CLOSE = COMP

WAPPR = WAPPR

SITEXREF

Cross‐reference the site ID and the Oracle E‐ Business Suite operating unit

X

N

N

Null (D)

SUBLOCDEL

Delimiter between subinventory code and locator ID in the bin number

V

N

S

- (D) hyphen

USEPRNUM

Specifies when integration framework uses the PR number as the Oracle E‐Business Suite PR number (value 1) or uses the auto generated number used by the Oracle import routine (0)

B

N/A

S

1 or 0 (D)