Results for “get_model_derived”

8 results




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

Overview

OE_FLEX_COGS_PUB (source file OEXWCGSS.pls) is a public PL/SQL package in the APPS schema that resolves the Cost of Goods Sold (COGS) accounting flexfield combination for Order Management transaction lines. It is an API-classification ("PUB") package, meaning it is intended for supported external invocation by forms, workflows, and custom code. Its central business purpose is to derive the correct COGS Account CCID and its concatenated segment string for a given order line, then make that account available to downstream accounting and subledger processes.

The package operates primarily within the Oracle Workflow engine. The Order Management COGS account generation workflow calls its activity functions to evaluate which derivation rule applies to a line, return the resulting CCID and concatenated segments, and pass that result back to the workflow activity. Because COGS account derivation can depend on the item, the order type, the model line (for option lines), the sales representative, and the inventory organization, the package exposes a family of discrete derivation routines behind a single entry point rather than a single monolithic rule.

Key Procedures and Functions

  • START_PROCESS — Public function that launches the workflow process to create the COGS account. Accepts an API version number and a line ID, and returns the derived CCID, concatenated segments, segment IDs, and segment descriptions, along with standard message count and message data output parameters.
  • GET_COST_SALE_ITEM_DERIVED — Workflow-standard activity procedure that derives the COGS account for a line regardless of the option flag setting. This is the general-purpose derivation path.
  • GET_MODEL_DERIVED — Derives the COGS account for a line based on its model line, applied when the line is an option (configuration child) line.
  • GET_ORDER_TYPE_DERIVED — Derives the CCID from the Order Type, using the transaction type's accounting rules.
  • GET_SALESREP_REV_DERIVED — Derives the COGS account from sales representative revenue information.
  • GET_SALESREP_ID — Resolves the sales representative identifier used by the salesrep-based derivation rule.
  • GET_INVITM_ORG_DERIVED — Derives the COGS account from the inventory item and inventory organization combination.
  • GET_TRX_TYPE — Retrieves the transaction type applicable to the line for use in derivation logic.
  • CHECK_OPTION — Determines whether the line is an option line, influencing which derivation routine is selected.
  • UPGRADE_COGS_FLEX — Performs upgrade processing on the COGS flexfield setup, supporting migration of COGS account configuration.
  • BUILD — Constructs the return values (CCID, concatenated segments and descriptions) from a resolved account combination.
  • GET_TYPE_FROM_LINE — Resolves line type information from the order line for use in the derivation rules.

Tables Accessed

The package reads order and transaction data from OE_ORDER_HEADERS, OE_ORDER_LINES, and OE_ORDER_LINES_ALL to obtain the order line context, and OE_TRANSACTION_TYPES_ALL for transaction type accounting rules. Item and organization context are drawn from MTL_SYSTEM_ITEMS and HR_ORGANIZATION_INFORMATION (inventory organization). Sales credit information comes from OE_SALES_CREDITS and OE_SALES_CREDIT_TYPES. Receivables-side reference data is read from RA_CUSTOMER_TRX and RA_CUST_TRX_TYPES_ALL. PLITBLM is used for flexfield segment value handling.

Usage Notes

OE_FLEX_COGS_PUB is normally invoked indirectly. The primary caller is the Order Management COGS account generation workflow, which invokes the derivation activity procedures (the GET_*_DERIVED routines) with the standard workflow parameters itemtype, itemkey, actid, and funcmode, returning a result string. START_PROCESS provides a programmatic entry point for code that needs the COGS CCID for a specific line. The package is referenced by five other packages, indicating it is embedded in the broader Order Management accounting call chain rather than called in isolation. UPGRADE_COGS_FLEX supports one-time upgrade activity rather than routine transactional use. Because the derivation rules depend on order type and item setup, implementations customizing COGS accounting should configure Order Management transaction type and item COGS rules rather than modifying this package. Note that this object's scope is entirely unrelated to aftermarket automotive intake manifold or carburetor applications; the search term "Edelbrock intake for 600cfm Holley" does not correspond to any documented functionality of this Oracle EBS package.