Work Order Material Transaction Service

Service to import component transactions for work order execution as well as product transactions in orderless execution. For component transactions in work order execution, the component can be issued to work order or returned to inventory. For product transactions in orderless execution, product completion, return, scrap as well as return from scrap transactions can be reported with reference to a work definition which is used to backflush the components and charge the resources.

Life Cycle Status: Active

QName: {http://xmlns.oracle.com/apps/scm/commonWorkExecution/workOrderMaterialTransactions/materialTransactionsService/}WorkOrderMaterialTransactionService

Service WSDL URL: https://servername/fscmService/WorkOrderMaterialTransactionService?WSDL

Logical Business Objects

  • SCM : Common Work Execution : Work Order Material Transaction

Relationships

The following table describes how this service data object is related to other service data objects or business object services.

Relationship Type Object or Service

Handles

Work Order Header Details

Handles

Material Transaction Details

Handles

Material Transaction Lot Details Output

Handles

Material Transaction Serial Details

Handles

Material Transaction Header Output

Handles

Material Transaction Message Detail

Handles

Material Transaction Batch

Handles

Material Transaction Interface Message

Handles

Material Transaction Serial Details Output

Handles

Material Transaction Lot Details

Handles

Material Transaction Lot Details

Handles

Material Transaction Process Status

Handles

Material Transaction Serial Details

Handles

Material Transaction Process Status Translation

Handles

Material Transaction Details

Operations

createWorkOrderMaterialTransactions

Imports component transactions for work order execution and production transactions in orderless execution.

Life Cycle Status: Active

Request Payload

Element Name Type Description

batchInput

Material Transaction Batch

The input payload for the batch of material transactions.

Response Payload

Element Name Type Description

result

Material Transaction Process Status

The output payload for the batch of material transactions.

getDfltObjAttrHints

The web service consuming application can invoke this method to resolve UI hints on the server without requiring a database roundtrip.

Life Cycle Status: Active

Request Payload

Element Name Type Description

viewName

string

view name

localeName

string

locale name

Response Payload

Element Name Type Description

result

{http://xmlns.oracle.com/adf/svc/types/}ObjAttrHints

return the static control hints (UI hints) defined on a view instance and its attributes

getServiceLastUpdateTime

to get the file timestamp of the last updated schema file

Life Cycle Status: Active

Request Payload

Response Payload

Element Name Type Description

result

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

return the last modified time for the service schema files

getEntityList

to get the list of service view instance names, XSD type, and flags that indicate whether the service view supports Create, Update, Merge, and Delete operations

Life Cycle Status: Active

Request Payload

Response Payload

Element Name Type Description

result

{http://xmlns.oracle.com/adf/svc/types/}ServiceViewInfo

The method returns the list of service view instance names, XSD type, and flags that indicate whether the service view supports Create, Update, Merge, and Delete operations.

Security

The following tables list the privileges required to perform the service operations, and the duty roles that each privilege is granted to.

Service Operations to Privileges Mapping

Operation Name Privilege Code Privilege Name Privilege Description

All Operations

WIP_IMPORT_MATERIAL_TRANSACTIONS_PRIV

Import Material Transactions

Allows import of work order material transactions. Also allows correction of import validation errors, using a spreadsheet.

Privileges to Duty Roles Mapping

Privilege Code Granted to Duty Role Code Granted to Duty Role Name Granted To Duty Role Description

WIP_IMPORT_MATERIAL_TRANSACTIONS_PRIV

ORA_WIE_PRODUCTION_SUPERVISOR_JOB

Production Supervisor

Individual responsible for planning, directing and coordinating production operations and activities in a manufacturing organization. This person ensures product output and quality meet established goals while remaining on budget.

Duty Roles to Duty or Job Roles Mapping

Duty Role Code Granted to Duty or Job Role Code Granted to Duty or Job Role Name Granted To Duty or Job Role Description

ORA_WIE_PRODUCTION_SUPERVISOR_JOB

ORA_FUN_FSCM_LOAD_INTERFACE_ADMIN_DUTY

FSCM Load Interface Administration

Manages load interface file for import

ORA_WIE_PRODUCTION_SUPERVISOR_JOB

ORA_EGP_ITEM_INQUIRY_DUTY

Item Inquiry

Queries and views items in the enterprise.

ORA_WIE_PRODUCTION_SUPERVISOR_JOB

ORA_WIE_PRODUCTION_OPERATOR_JOB

Production Operator

Individual responsible for material handling, fabrication, assembly and finishing of products, and preparing finished products for warehousing and shipping.

ORA_WIE_PRODUCTION_SUPERVISOR_JOB

ORA_WIE_MANUFACTURING_PRODUCTION_SERVICE_DUTY

Production REST Services

Provides service access using REST Services to manufacturing work set up and work execution.

ORA_WIE_PRODUCTION_SUPERVISOR_JOB

ORA_RCS_SCM_COMMON_WEB_SERVICE_DUTY

Supply Chain Common Web Service

Provides web service access to supply chain common to perform activities such as viewing inventory organizations, plant parameters, carriers and units of measure list of values.