Receive Resource Transaction Service
This service is in the WmOAMFG1227 package and has the following fully-qualified service name: workInProcess1227.intoOA.resourceTransaction:receiveResourceTransaction.
This service imports work-in-process (WIP) resource transactions. The Open Resource Transaction Interface program validates the data you load in the Open Resource Transaction Interface tables by ensuring that the columns in the interface tables reference the appropriate values and columns in the rest of the system.
The Cost Manager handles the import process. Interface managers run continuously at regular intervals. They control the number of transaction workers, processing intervals, and number of transactions processed by the worker. The mode of operation for these managers is governed by the setting of profile options prefixed by the letters TP (transaction processing). The Cost Manager is also responsible for costing for other transactions, such as material transactions. Thus, no concurrent process is defined in this service.
Database Scripts
This service does not use database scripts.
Supporting Transaction Definitions
This service was built from the configured services defined in the following transaction definitions:
setResourceTransactionTxn1227.txp
ResourceTransactionTxn1227.txp
For information about using the transaction definition files to customize this service, see
Transaction Definitions.
Flow Control
This service uses the following flow steps to import resource transactions:
specifyDefaultSettings specifies the default parameter settings required for service execution. You should change these settings accordingly.
bizDocMapping maps the incoming business document structure to the required Oracle Applications data structures (the interface tables).
getOrgIdAndCode is a transformer for mapping the business document
IData structure to the interface table
IData structure. It takes ORGANIZATION_NAME as input, and queries the table ORG_ORGANIZATION_DEFINITIONS to get the ORGANIZATION_ID and the ORGANIZATION_CODE.
getOASystemDateObject returns the Oracle Applications system date as a date object.
getOracleAppsUserId is a transformer for mapping the business document
IData structure to the interface table
IData structure. It takes
ORACLE_APPS_USER_NAME as the input parameter from the business document, and queries the table FND_USER to get the USER_ID. The USER_ID information is required for insertion into the interface tables.
getAcctPeriodId is a transformer for mapping the incoming business document to the interface table data structure for Open resource interface. This service takes Period Name as input, and returns Period ID as output, querying the Oracle Applications database.
getActivityId is a transformer for mapping the incoming business document to the interface table data structure for Open resource interface. This service takes Activity Name as input, and returns Activity ID as output, querying the Oracle Applications database.
getDepartmentId is a transformer for mapping the incoming business document to the interface table data structure for Open resource interface. This service takes Department Code and Organization Name as input, and returns Department ID as output, querying the Oracle Applications database.
getPOHeaderId is a transformer for mapping the incoming business document to the interface table data structure for Open resource interface. This service takes Purchase Order header number as an input and results PO header ID as output querying the Oracle Applications database.
getPOLineId is a transformer for mapping the incoming business document to the interface table data structure for the Open Resource interface. This service takes PO Header Number and Line Number as input, and returns the corresponding PO Line ID as output, querying the Oracle Applications database.
getTaskId is a transformer for mapping the incoming business document to the interface table data structure for Open resource interface. This service takes Task and Project Name as input, and returns Task ID as output, querying the Oracle Applications database.
getProjectId is a transformer for mapping the incoming business document to the interface table data structure for the Open Resource interface. This service takes Project Name as input, and returns Project ID as output, querying the Oracle Applications database.
setResourceTransactionTxn inserts data into the interface table. It extracts data from the
IData structure that results from the
bizDocMapping service, and puts the data into the interface table in Oracle Applications for the Open Resource interface.
Business Document Structure
This service uses the business document ResourceTransactionBizDoc. Its structure is as follows:
WIP_COST_TXN
WIP_COST_TXN (Maps to WIP_COST_TXN_INTERFACE)
Field Name | Maps to Column | Description |
TRANSACTION_TYPE | TRANSACTION_ TYPE | Required. Use: 1 for Normal resource transactions 2 for Overhead transactions, or 3 for Outside processing transactions. |
SOURCE_CODE | SOURCE_CODE | Code of the shop floor control system that generated the transaction record. |
ORGANIZATION_NAME | ORGANIZATION_ CODE ORGANIZATION_ID | Required. |
SET_OF_BOOKS_NAME | | |
WIP_ENTITY_NAME | WIP_ENTITY_NAME | Required. WIP job or repetitive assembly name. |
LINE_CODE | LINE_CODE | Line name. |
PRIMARY_ITEM_CODE | PRIMARY_ITEM_ID | Inventory item identifier of assembly that job or schedule creates. |
TRANSACTION_DATE | TRANSACTION_ DATE | Required. Date transaction was performed. Time component of this date should also be entered in the datetime format for TRANSACTION_DATE, which is set to dd-MMM-yy HH:mm:ss. |
ACCT_PERIOD_NAME | ACCT_PERIOD_ID | Accounting period identifier. |
OPERATION_SEQ_NUM | OPERATION_ SEQ_NUM | Required. Operation sequence number within a routing. |
RESOURCE_SEQ_NUM | RESOURCE_ SEQ_NUM | Required. Resource sequence number. |
DEPARTMENT_CODE | DEPARTMENT_ID | Code that uniquely identifies the department. |
EMPLOYEE_NUM | EMPLOYEE_NUM | Employee number. |
RESOURCE_CODE | RESOURCE_CODE | |
RESOURCE_TYPE | RESOURCE_TYPE | |
USAGE_RATE_OR_ AMOUNT | USAGE_RATE_ OR_AMOUNT | Rate per assembly, amount per job, or amount per schedule. |
BASIS_TYPE | BASIS_TYPE | Basis for charging resource. |
AUTOCHARGE_TYPE | AUTOCHARGE_ TYPE | Method of charging the resource. |
STANDARD_RATE_FLAG | STANDARD_ RATE_FLAG | Indicates whether the resource is charged at the standard rate. |
TRANSACTION_QUANTITY | TRANSACTION_ QUANTITY | Required. |
TRANSACTION_UOM | TRANSACTION_ UOM | Required. Unit of measure for the transaction. |
PRIMARY_QUANTITY | PRIMARY_ QUANTITY | Quantity of transaction expressed in assembly’s primary unit of measure. |
PRIMARY_UOM | PRIMARY_UOM | Primary unit of measure for the resource. |
PRIMARY_UOM_CLASS | PRIMARY_ UOM_CLASS | Class to which the primary unit of measure belongs. |
ACTUAL_RESOURCE_RATE | ACTUAL_ RESOURCE_RATE | Actual rate of the resource. |
CURRENCY_CODE | CURRENCY_ CODE | |
CURRENCY_CONVERSION_ DATE | CURRENCY_ CONVERSION_DATE | |
CURRENCY_CONVERSION_ RATE | CURRENCY_ CONVERSION_RATE | |
CURRENCY_ACTUAL_ RESOURCE_RATE | CURRENCY_ACTUAL_ RESOURCE_RATE | Actual resource rate in foreign currency, used when the STANDARD_RATE_FLAG is Y. |
ACTIVITY_NAME | ACTIVITY_NAME | |
REASON_NAME | REASON_NAME | Standard transaction reason name. |
REFERENCE | REFERENCE | |
MOVE_TRANSACTION_ID | MOVE_ TRANSACTION_ID | Transaction identifier for the move that created the costing transaction. |
RCV_TRANSACTION_ID | RCV_ TRANSACTION_ID | Transaction identifier for the receipt that created the costing transaction. |
PO_HEADER_NUM | PO_ HEADER_ID | Purchase order identifier for the receipt. |
PO_LINE_NUM | PO_LINE_ID | Purchase order line identifier for the receipt. |
RECEIVING_ACCOUNT_ NUMBER | RECEIVING_ ACCOUNT_ID | |
PROJECT | PROJECT_ID | |
TASK | TASK_ID | |