Results for “start_lot”

20 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

CSTPSMUT is a costing support package in the Oracle E-Business Suite Process Manufacturing (OPM) and Discrete Manufacturing cost management stack. Its name reflects its role as a transaction-level costing utility — the "SMUT" mnemonic corresponds to "Subledger Material Update Transaction." The package provides the procedural layer that converts material movement records in MTL_MATERIAL_TRANSACTIONS into balanced cost subledger entries, and supports specialized material movements such as split, merge, quantity update, and bonus receipts. It belongs to the OSFM (Oracle Shop Floor Management) costing enhancement set introduced with the BOM PatchSet I line of development, as indicated by the header comment "BOM PatchSet I Enhancements for OSFM Costing." The package is owned by APPS and classified as OTHER rather than a formal public API, meaning it is intended for internal invocation by cost processor programs and related packages rather than for direct customer call-out.

Key Procedures and Functions

  • COST_SPLIT_TXN — Costs a material transaction that results from splitting a lot or quantity into a new entity, writing the resulting charges into the cost subledger.
  • COST_MERGE_TXN — Costs the complementary merge operation, consolidating quantities and their associated values into a single transaction.
  • COST_UPDATE_QTY_TXN — Re-costs a transaction following a quantity adjustment without an accompanying value change.
  • COST_BONUS_TXN — Handles the cost accounting of bonus or gratuitous material receipts, where value is booked without a corresponding procurement charge.
  • GET_WIP_TXN_ID — Retrieves the WIP transaction identifier associated with a material movement, used to link shop floor activity to cost records.
  • UPDATE_JOB_QUANTITY — Adjusts the job quantity recorded against a work order in response to material quantity changes.
  • GET_JOB_VALUE — Returns the accumulated value of a job for use in downstream cost and accounting calculations.
  • BALANCE_ACCOUNTING — Validates that debit and credit legs of a cost transaction are balanced before posting.
  • INSERT_MAT_TXN / INSERT_WIP_TXN — Insert material and WIP transaction rows into the respective cost subledger structures.
  • INSERT_MTA — Inserts detailed material transaction accounting lines.
  • INSERT_MAT_TXN_ACCT / BONUS_MAT_TXN_ACCT — Insert standard and bonus accounting entries for material transactions.
  • INSERT_WIP_TXN_ACCT / BONUS_WIP_TXN_ACCT — Insert standard and bonus accounting entries for WIP transactions.
  • START_LOT / RESULT_LOT — Record the costing of start and result lots within an OSFM lot-based production flow.

The header notes that several legacy procedures (GET_PARAMS, UPDATE_OP_RES_REQ_INFO, GET_CHARGE_VAL, GET_SCRAP_VAL) were removed in this revision, reflecting a refactoring of the resource and scrap costing logic into other components.

Tables Accessed

The package reads and writes MTL_MATERIAL_TRANSACTIONS — the transactional source of material movements — and MTL_TRANSACTION_TYPES to determine transaction semantics. Accounting output is written to MTL_TRANSACTION_ACCOUNTS. Item and cost context come from MTL_SYSTEM_ITEMS, CST_ITEM_COSTS, and CST_COST_ELEMENTS. Resource and overhead costing references BOM_OPERATION_SEQUENCES, BOM_RESOURCES, CST_RESOURCE_COSTS, CST_RESOURCE_OVERHEADS, and CST_DEPARTMENT_OVERHEADS. Period validation uses ORG_ACCT_PERIODS, while FND_CURRENCIES supplies currency precision. Sequence generation relies on CST_INV_SUB_LEDGER_ID_S and CST_WIP_SUB_LEDGER_ID_S for subledger line identifiers.

Usage Notes

CSTPSMUT is not a supported public API. It is invoked internally by the cost processor concurrent programs and by other costing packages — the metadata records one package referencing it. Customizations should not call these procedures directly; instead, developers should drive material movements through the supported transaction interfaces such as INV_MATERIAL_TXN_MGR or the Process Manufacturing execution APIs, which in turn trigger the costing logic. When diagnosing cost subledger discrepancies, the package and its target tables (MTL_TRANSACTION_ACCOUNTS and the distribution tables behind MTL_MATERIAL_TRANSACTIONS) are the primary objects to inspect. Because the package uses AUTHID CURRENT_USER, it executes under the calling schema's privileges, so APPS synonyms on the referenced tables must remain valid for correct execution in both 12.1.1 and 12.2.2.