Results for “replen_so_creation_failed”

16 results




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

Overview

JMF_SHIKYU_COMPONENTS is a transaction table in the JMF schema, which belongs to the Oracle E-Business Suite Supply Chain Localizations module. The table stores the SHIKYU (subcontracting) components required to manufacture the outsourced assembly item associated with a subcontracting order shipment. In the Oracle EBS 12.1.1 and 12.2.2 environments, this object supports the Japanese localizations that govern how component parts and materials are priced, quantified, and tracked when an assembly is manufactured by an external supplier rather than in-house.

Under the heuristic Data Vault classification derived from its foreign key structure, JMF_SHIKYU_COMPONENTS is best modeled as a link. It resolves the many-to-many relationship between subcontracting shipments (from JMF_SUBCONTRACT_ORDERS) and inventory items supplied as SHIKYU components (from MTL_SYSTEM_ITEMS_B), carrying descriptive and financial attributes alongside the relationship. This modeling suggestion reflects the table's role as an associative entity rather than a standalone hub or a pure descriptive satellite.

Key Information Stored

The table contains 20 documented columns. The composite primary key, enforced through the JMF_SHIKYU_COMPONENTS_PK constraint, consists of SUBCONTRACT_PO_SHIPMENT_ID and SHIKYU_COMPONENT_ID. A parallel unique index, JMF_SHIKYU_COMPONENTS_U1, uses the same two columns, making them the documented business-key candidates.

  • SUBCONTRACT_PO_SHIPMENT_ID — Foreign key to JMF_SUBCONTRACT_ORDERS, identifying the subcontracting order shipment to which the component belongs. Part of the primary key.
  • SHIKYU_COMPONENT_ID — Foreign key to MTL_SYSTEM_ITEMS_B, identifying the inventory item supplied as a SHIKYU component. Part of the primary key.
  • OEM_ORGANIZATION_ID — Identifies the original equipment manufacturer organization associated with the component line.
  • SHIKYU_COMPONENT_PRICE — The price applicable to the SHIKYU component.
  • CURRENCY — Foreign key to FND_CURRENCIES, defining the currency of the component price.
  • UOM and PRIMARY_UOM — The unit of measure for the transaction quantity and the item's primary unit of measure, respectively.
  • PRIMARY_UOM_PRICE — The component price expressed in the item's primary unit of measure.
  • QUANTITY — The quantity of the SHIKYU component required for the outsourced assembly.
  • PRICE_LIST_ID — Reference to the price list used to derive component pricing.
  • REPLEN_SO_CREATION_FAILED — Flag indicating that replenishment sales order creation failed for the component.
  • REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE — Standard concurrent program and request audit columns.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard WHO audit columns.

Common Use Cases and Queries

Typical reporting scenarios include reconciling SHIKYU component costs against the subcontracting order, verifying which items were supplied to a supplier, and investigating failed replenishment sales orders. A representative query joins the table to MTL_SYSTEM_ITEMS_B for item detail:

  • SELECT sc.SUBCONTRACT_PO_SHIPMENT_ID, sc.SHIKYU_COMPONENT_ID, msib.SEGMENT1, sc.QUANTITY, sc.SHIKYU_COMPONENT_PRICE, sc.CURRENCY FROM JMF.JMF_SHIKYU_COMPONENTS sc, MTL_SYSTEM_ITEMS_B msib WHERE sc.SHIKYU_COMPONENT_ID = msib.INVENTORY_ITEM_ID AND sc.OEM_ORGANIZATION_ID = msib.ORGANIZATION_ID;
  • Querying components where REPLEN_SO_CREATION_FAILED is set helps identify exceptions requiring correction through the replenishment process.
  • Joining to JMF_SUBCONTRACT_ORDERS on SUBCONTRACT_PO_SHIPMENT_ID supports shipment-level cost rollups.
  • Joining to FND_CURRENCIES on CURRENCY validates currency codes and enables multi-currency reporting.

Related Objects

The most significant related objects are those referenced by the documented foreign keys:

  • JMF_SUBCONTRACT_ORDERS — Joined on SUBCONTRACT_PO_SHIPMENT_ID; the parent subcontracting shipment record.
  • MTL_SYSTEM_ITEMS_B — Joined on SHIKYU_COMPONENT_ID (with OEM_ORGANIZATION_ID against ORGANIZATION_ID); provides item master detail.
  • FND_CURRENCIES — Joined on CURRENCY; validates and describes currency codes.
  • JMF_SHIKYU_COMPONENTS_PK / JMF_SHIKYU_COMPONENTS_U1 — The primary key constraint and unique index defining row identity.

These relationships confirm the table's associative role linking subcontracting orders, item definitions, and currency reference data within the JMF localization framework.