Integration controls
The adapter has a set of controls that are associated with its publish channels and enterprise service.
The following table lists the integration controls that the adapter provides for the Oracle E-Business Suite external system.
| Integration control | Description |
|---|---|
|
APLINETYPE |
Default invoice line type in the Oracle E-Business Suite |
|
APSEND |
Statuses at which invoices are sent from Maximo® Asset Management to Oracle E-Business Suite. The domain is INVSTATUS |
|
CATEGORYXREF |
Cross‐reference Maximo Asset Management item category and Oracle stock enabled flag |
|
CHARGEORG |
Default charge (project expenditure) organization |
|
COAXREF |
Cross‐reference Maximo Asset Management organization ID and Oracle chart of accounts ID |
|
CONVHRS |
Hours to convert annual salary to hourly rate |
|
CRAFTXREF |
Multiply Oracle craft code to Maximo Asset Management organizations |
|
EXPENDITEM |
Oracle Project Accounting item expenditure type |
|
EXPENDLABOR |
Oracle Project Accounting labor expenditure type |
|
EXPENDTOOL |
Oracle Project Accounting tool expenditure type |
|
FCSTATUSXREF |
Cross‐reference Oracle project status and Maximo Asset Management financial control status |
|
GENITEM |
Dummy identifier for masking item number |
|
GENSTORE |
Dummy identifier for masking storeroom on outbound transactions |
|
GENUSR |
Dummy identifier for masking user ID on outbound transactions |
|
GLCURNCY |
Default currency code in the Oracle E-Business Suite |
|
GLCURNCYTYPE |
Type of currency exchange rates |
|
GLSOURCE |
Source business object of Maximo Asset Management general ledger journal. The domain is GLSOURCE. |
|
INVCSTATUSXREF |
Translate Maximo Asset Management internal and external invoice status, if using synonyms |
|
INVCTYPEXREF |
Cross‐reference Maximo Asset Management and Oracle invoice document types |
|
ITMSUBXREF |
Cross‐reference storeroom and subinventory |
|
JECATXREF |
Cross‐reference Maximo Asset Management transaction type and the Oracle E-Business Suite journal category |
|
JEPROJSEND |
List of Maximo Asset Management project transactions to forward to Oracle general ledger. The domain is GLSOURCE. |
|
LABXREF |
Multiply Oracle labor code to Maximo Asset Managementorganizations |
|
LANGXREF |
Cross‐reference Maximo Asset Management language code and Oracle SET_PROCESS_ID |
|
LINETYPEXREF |
Cross‐reference Maximo Asset Management line type (synonyms) and the Oracle E-Business Suite line type |
|
LOTTYPEXREF |
Cross‐reference Maximo Asset Management and Oracle lot control indicators |
|
NLRORG |
Default Oracle Project Accounting non‐labor resource organization |
|
OACATXREF |
Cross‐reference Maximo Asset Management line type and Oracle item or service category identifier |
|
OAGLDELIMITER |
Delimits GL components from GL account numbers. The default value is a hyphen. The OAGLDELIMITER integration control should have the same value as the MAXORACTLS GLDELIMITER Integration control. If GL Components contain a hyphen, do not use a hyphen for OAGLDELIMITER. |
|
OAITMLOTPREF |
Default starting lot prefix |
|
OAITMLOTSTART |
Default starting lot Number |
|
OAPCDEFORDERUNIT |
Default order unit for purchase contracts |
|
ORGXREF |
Cross‐reference Maximo Asset Management organization and Oracle ledger ID |
|
PCSEND |
Statuses at which purchase requisitions are sent from Maximo Asset Management to Oracle E-Business Suite. The domain is CONTRACTSTATUS. |
|
PCSTATUSXREF |
Cross‐reference Maximo Asset Management internal and external contract status, if using synonyms |
|
PCTYPEXREF |
Cross‐reference Maximo Asset Management and Oracle contract types |
|
POSTATUSXREF |
Cross‐reference Maximo Asset Management internal and external PO status, if using synonyms |
|
POSEND |
Statuses at which purchase orders are sent from from Maximo Asset Management to Oracle E-Business Suite. The domain is POSTATUS. |
|
POTYPEXREF |
Cross‐reference Maximo Asset Management and Oracle E-Business Suite purchase order types |
|
PROJAP |
Include project accounting data on outbound invoice lines |
|
PROJPO |
Include project accounting data on outbound purchase order lines |
|
PROJPR |
Include project accounting data on outbound purchase requisition lines |
|
PROJSEND |
Transaction types for which actuals transactions are sent to Oracle Project Accounting. The domain is GLSOURCE. |
|
PRSEND |
Statuses at which purchase requisitions are sent from Maximo Asset Management to Oracle E-Business Suite. The domain is PRSTATUS. |
|
PRSTATUSXREF |
Cross‐reference Maximo Asset Management internal and external PR status, if using synonyms |
|
RESLEVELITEM |
Resource level for items |
|
RESLEVELLABOR |
Resource level for labor |
|
RESLEVELTOOL |
Resource level for tools |
|
SENDPOCOST |
Sends POCOST GL transactions upon receipt of purchase orders if the GL Journal Publish channel is enabled in Maximo Asset Management. The default value is false, which means that POCOST transactions are skipped. SENDPOCOST should be enabled when PO integration is turned off. |
|
SITEXREF |
Cross‐reference Maximo Asset Management site ID and Oracle operating unit |
|
SKIPINVOICECOST |
Skips invoice cost distributions when invoices are sent from Maximo Asset Management to the Oracle E-Business Suite. The default value is false. SKIPINVOICECOST should be enabled when PO integration is turned off. |
|
SKIPLOTSERIAL |
Skips rotating and lot transactions when receipts are sent from Maximo Asset Management to the Oracle E-Business Suite. The default value is false. SKIPLOTSERIAL is used when items are masked in Maximo Asset Management. |
|
SRCTIM |
Transaction source for labor actuals |
|
SRCUSE |
Transaction source for non‐labor actuals |
|
SUBLOCDEL |
Delimiter between subinventory code and locator ID in the Maximo Asset Management bin number |
|
USEPRNUM |
Specifies whether integration uses the Maximo Asset Management PR number as the Oracle E-Business Suite PR number (value 1) or uses the autogenerated number used by the Oracle import routine (0) |