Receive Periodic Cost Service
This service is in the WmOAMFG1227 package and has the following fully-qualified service name: costManagement1227.intoOA.periodicCost:receivePeriodicCost.
This service imports periodic costs for the first open period. Costs in subsequent periods are calculated by Oracle Applications.
Database Scripts
This service uses the following database scripts:
Script | Description |
wm_install_into_periodiccost.sql | Runs the scripts listed below, except the uninstall script. |
wm_into_periodiccost_pkg.sql | Installs WM_PC_IMP_HANDLER_PKG. WM_HANDLE_PC_IMP_TXN, which calls the WM_CONC_REQUEST. WM_REQUEST_SUBMIT procedure to submit the Periodic Cost Import process. |
wm_into_periodiccost_seq.sql | Creates the following components: WM_CST_PC_INTERFACE_HEADER_S, which creates the INTERFACE_HEADER_ID sequence WM_CST_PC_INTERFACE_LINE_S, which creates the INTERFACE_LINE_ID sequence |
wm_drop_into_periodiccost.sql | Uninstalls all components created by wm_install_into_periodiccost.sql. |
For more information about using database scripts, see
Database Scripts.
Supporting Transaction Definitions
This service was built from the configured services defined in the following transaction definitions:
setPeriodicCostTxn1227.txp
PeriodicCostTxn1227.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 periodic costs:
specifyDefaultSettings specifies the default parameter settings required for service execution. You should change these settings accordingly.
specifyConcProgParams specifies the default settings required for concurrent program execution. You should change these settings accordingly.
bizDocMapping maps the incoming business document structure to the required Oracle Applications data structures (the interface tables).
getInventoryItemId is a transformer for mapping the incoming business document to the interface table structure. This service selects the inventory item ID from the organization name and item code.
costElementLookUp looks up transformers that transform the cost element text to the cost element flag.
levelTypeLookUp looks up table to transform the level Type text to its desired value.
setPeriodicCostTxn 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 Periodic Cost.
importPeriodicCost imports data into the production table from the interface table. It then calls the services
execPeriodicCostConcProg,
checkPeriodicCostImportStatus, and
importPeriodicCost_ERR to execute the corresponding concurrent program that inserts data into the production table, and to generate the error/acknowledgement message. If the status of the execution is SUCCESS (returned by the service execPeriodicCostConcProg), it checks for the record having the returned request ID in the error interface table. If one is found, it indicates an error during import. In this case, this service calls importPeriodicCostImport_ERR to retrieve the errors. If no record is found, it comes out of the flow, indicating success of the data import process. If the status of the execution is FAILED, it returns the appropriate error message and comes out of execution.
execPeriodicCostConcProg invokes the stored procedure WM_PC_IMP_HANDLER_PKG.WM_HANDLE_PERIODIC_COST. The procedure calls the corresponding concurrent subroutine to execute the data import process for Periodic Cost into Oracle Applications. This service returns Status ID, Request ID, Execution Status Message (for normal concurrent program completion), and database Stored Procedure error message (if an exception occurs in Stored Procedure execution).
checkPeriodicCostImportStatus checks whether the previous step resulted in any error records for the interface records processed.
getPeriodicCostImport_ERR gets the error message that occurs during the data import into the production table from the interface table. Based on the parameter request ID, it scans tables CST_PC_ITEM_COST_INTERFACE and CST_PC_COST_DET_INTERFACE to get the corresponding message matches to the request ID.
Business Document Structure
This service uses the business document PeriodicCostBizDoc. Its structure is as follows:
1.0. CST_PC_ITEM_COST
1.1. CST_PC_COST_DETAILS
1.0. CST_PC_ITEM_COST (Maps to CST_PC_ITEM_COST_INTERFACE)
Field Name | Maps to Column | Description |
ITEM_CODE | INVENTORY_ ITEM_ID | Required. Derives the Inventory Item ID using HR_ALL_ORGANIZATION_ UNITS.NAME and MTL_SYSTEM_ITEMS_ B_KFV.CONCATENATED_ SEGMENTS. Refer to Transformer. |
ORGANIZATION_NAME | | Required. |
COST_GROUP | COST_GROUP | Required. Cost group name. |
COST_TYPE | COST_TYPE | Required. Cost type name. |
PERIOD_NAME | PERIOD_NAME | Required. |
BEGIN_LAYER_QUANTITY | BEGIN_LAYER_ QUANTITY | Required. Period beginning layer quantity. |
ISSUE_QUANTITY | ISSUE_QUANTITY | |
BUY_QUANTITY | BUY_QUANTITY | |
MAKE_QUANTITY | MAKE_QUANTITY | |
ITEM_COST | ITEM_COST | |
MARKET_VALUE | MARKET_VALUE | Market Value. It must be less than item cost. |
JUSTIFICATION | JUSTIFICATION | Required if market value is provided. |
BEGIN_ITEM_COST | BEGIN_ITEM_COST | Period beginning item cost. |
ITEM_BUY_COST | ITEM_BUY_COST | |
ITEM_MAKE_COST | ITEM_MAKE_COST | |
PL_MATERIAL | PL_MATERIAL | Previous level material cost. |
PL_MATERIAL_OVERHEAD | PL_MATERIAL_ OVERHEAD | Previous level material overhead cost. |
PL_RESOURCE | PL_RESOURCE | Previous level resource cost. |
PL_OUTSIDE_PROCESSING | PL_OUTSIDE_ PROCESSING | Previous level processing cost. |
PL_OVERHEAD | PL_OVERHEAD | Previous level overhead cost. |
TL_MATERIAL | TL_MATERIAL | This level’s material cost. |
TL_MATERIAL_OVERHEAD | TL_MATERIAL_ OVERHEAD | This level’s material overhead cost. |
TL_RESOURCE | TL_RESOURCE | This level’s resource cost. |
TL_OUTSIDE_PROCESSING | TL_OUTSIDE_ PROCESSING | This level’s outside processing cost. |
TL_OVERHEAD | TL_OVERHEAD | This level’s overhead cost. |
PL_ITEM_COST | PL_ITEM_COST | Previous level’s item cost. |
TL_ITEM_COST | TL_ITEM_COST | This level’s item cost. |
UNBURDENED_COST | UNBURDENED_ COST | |
BURDEN_COST | BURDEN_COST | |
MATERIAL_COST | MATERIAL_COST | |
MATERIAL_OVERHEAD_ COST | MATERIAL_OVERHEAD_ COST | |
RESOURCE_COST | RESOURCE_COST | |
OVERHEAD_COST | OVERHEAD_COST | |
OUTSIDE_PROCESSING_ COST | OUTSIDE_PROCESSING_ COST | |
REFERENCE | REFERENCE | |
1.1 CST_PC_COST_DETAILS (Maps to CST_PC_COST_DET_INTERFACE)
Field Name | Maps to Column | Description |
COST ELEMENT | COST_ELEMENT_ID | Required. Cost Element. Use: 1 for Material. 2 for Material Overhead. 3 for Resource. 4 for Outside Processing. 5 for Overhead. |
LEVEL_TYPE | LEVEL_TYPE | Required. Level of the cost. Use: 1 for Current Level cost or value added at the current level of an assembly such as resource, outside processing, and overhead costs. Material is always a previous level cost. 2 for Previous Level material, material overhead, outside processing, resource, and overhead costs of the components used in manufacturing an assembly. |
ITEM_ COST | ITEM_COST | Required. |
ITEM_BUY_COST | ITEM_BUY_ COST | Item’s buying cost. |
ITEM_MAKE_COST | ITEM_MAKE_ COST | Item’s making cost. |
REFERENCE | REFERENCE | |