Search Results so_price_copy_parameters




Overview
Explore in AI Chat

Overview

The SO_PRICE_COPY_PARAMETERS table is a core data object within the Order Entry (OE) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It functions as a parameter repository for the process of copying item groups. Specifically, it stores configuration rules that govern how pricing and other attributes are replicated from a source item group to a target item group. This table is integral to maintaining pricing consistency and efficiency when managing complex, multi-line sales orders or when creating new item groups based on existing templates. Its existence directly supports the flexible pricing and configuration capabilities that are central to the Oracle Order Management system.

Key Information Stored

While the provided ETRM metadata does not list specific columns beyond the foreign key, the table's description and relationships indicate its core structure. The primary data stored includes the GROUP_ID, which is a foreign key linking to the SO_ITEM_GROUPS table, identifying the specific item group to which the copy parameters apply. Additional columns typically define the scope of the copy operation. These parameters likely control which pricing attributes—such as price lists, modifiers, adjustments, formulas, or qualifiers—are to be copied. The table essentially holds a set of flags or rules that answer "what to copy" for a given group, enabling a controlled and selective replication process rather than a full, ungoverned data copy.

Common Use Cases and Queries

The primary use case is the administrative setup and execution of the "Copy Item Groups" functionality within Oracle Order Management. A user configuring a new item group can leverage existing groups by copying their pricing structures, with the parameters in this table defining the exact blueprint for the copy. Common queries involve retrieving the copy rules for a specific group or validating parameters before a copy operation. For reporting, one might join this table to item group headers to audit which groups have custom copy parameters defined.

  • Sample Query to View Parameters for a Group: SELECT * FROM oe.so_price_copy_parameters WHERE group_id = <group_id>;
  • Use Case: Before launching a high-volume order import, an administrator runs a script to verify that all template item groups have the correct price copy parameters set, ensuring consistent pricing for the new orders.

Related Objects

The SO_PRICE_COPY_PARAMETERS table has a direct and documented foreign key relationship with the SO_ITEM_GROUPS table, as per the provided metadata. This relationship is fundamental to its purpose.

  • SO_ITEM_GROUPS: This is the parent table. The column SO_PRICE_COPY_PARAMETERS.GROUP_ID references a primary key in SO_ITEM_GROUPS. An item group must exist before copy parameters can be defined for it. Any join to retrieve descriptive group information would use this key relationship: SELECT ig.name, pcp.* FROM oe.so_item_groups ig, oe.so_price_copy_parameters pcp WHERE ig.group_id = pcp.group_id;

The table is likely referenced by internal OE APIs and PL/SQL packages that perform the actual copy logic, though these are not detailed in the excerpt. Its data is essential for the "Copy Group" forms and concurrent processes within the application.