Oracle Apps Adapter 6.0 | webMethods Oracle Applications Adapter Documentation | webMethods Oracle Applications Adapter 12.2.7 Predefined Transaction Services Documentation | Manufacturing Predefined Transaction Services | Receive Resource Transaction Service
 
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.
For more details on receive transactions, see Overview of Receive Service Transaction Processing.
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