Modifying Mass Change in PeopleSoft Order Management

This chapter provides an overview of how mass change is used in PeopleSoft Order Management and discusses how to:

Click to jump to parent topicUnderstanding How Mass Change is Used in People Soft Order Management

PeopleSoft Order Management uses mass change functionality in these processes:

Click to jump to top of pageClick to jump to parent topicCreate Sales Orders (OMCNTRCT)

The table contains the mass change definitions that are included in this Order Management process:

Step

Mass Change Definition

Description

1

OMSCN-1

Insert sales buying agreement data into PS_OMSCN_TMP, selecting fields from PS_RUN_OM_SCON, PS_SCON_HDR, PS_SCON_LINE, and PS_SCON_RELEASE.

2

OMSCN-2

Insert single order with multiple buying agreements into PS_OMSCN_DISTINCT, selecting distinct fields from PS_OMSCN_TMP.

3

OMSCN-3

Insert single order buying agreements into PS_OMSCN_DISTINCT, selecting distinct fields from PS_OMSCN_TMP.

4

OMSCN-4

Insert sales order header data into PS_ORD_HEADER, selecting fields from PS_OMSCN_DISTINCT and PS_RUN_OM_SCON.

5

OMSCN-5

Insert sales line data into PS_ORD_LINE selecting fields from OMSCN_TMP, PS_SCON_LINE, PS_SCON_RELEASE, and RUN_OM_SCON.

Click to jump to top of pageClick to jump to parent topicSales Rebate Interface (OMSRBTIN)

The table contains the mass change definitions that are included in this Order Management process:

Step

Mass Change Definition

Description

1

OMRBT-INTFC

Insert into INTFC_BI from RBTOM_INTFC_TMP, where TRANS_TYPE_BI in ('Line', NOTE', 'AHDR').

2

OMRBT-INTFC-AE

Insert into INTFC_BI_AEDS from RBTOM_INTFC_TMP where TRANS_TYPE_BI in ('AE', 'DS').

Click to jump to parent topicAdding Mass Change Definitions in PeopleSoft Order Management

Use the Mass Change pages to add or modify the processes that use mass change in PeopleSoft Order Management.

The section discusses how to:

Click to jump to top of pageClick to jump to parent topicPages Used to Add Mass Change Definitions

Page Name

Definition Name

Navigation

Usage

Mass Change Definition - Description

MC_DEFN_00

Set Up Financials/Supply Chain, Product Related, Order Management Foundation, Mass Change Definition, Description

Enter a description for the mass change definition.

Mass Change Definition - Criteria and Defaults

MC_DEFN_01

Set Up Financials/Supply Chain, Product Related, Order Management Foundation, Mass Change Definition, Criteria and Defaults

Create a default value to appear in a field without user intervention.

Mass Change Definition - OM Specific Fields page

MC_DEFN_OM

Set Up Financials/Supply Chain, Product Related, Order Management Foundation, Mass Change Definition, OM Specific Fields

View additional parameters for the Mass Change Definition.

Mass Change Definition - Generate SQL

MC_DEFN_02

Set Up Financials /Supply Chain, Product Related, Order Management Foundation, Mass Change Definition, Generate SQL

Synchronize the mass change SQL with any new table changes that are in the PeopleSoft Order Management system. This may be needed when modifications are made or if fields are added for bug fixes or product upgrades.

Mass Change Definition - Execution History

MC_DEFN_03

Set Up Financials/Supply Chain, Product Related, Order Management Foundation, Mass Change Definition, Execution History

Displays history for the Mass Change Definition.

Click to jump to top of pageClick to jump to parent topicAdding Mass Change Definition Criteria and Defaults

Access the Mass Change Definition - Criteria and Defaults page (Set Up Financials/Supply Chain, Product Related, Order Management Foundation, Mass Change Definition, Criteria and Defaults).

Field

Select values from the available options. Select any filtering or qualifying symbol (that is, between, =, >, or <); depending on the selection, enter the value (that is, between 1 and 100, or > 100).

Click to jump to top of pageClick to jump to parent topicGenerating Mass Change Definition SQL

Access the Mass Change Definition - Generate SQL page (Set Up Financials /Supply Chain, Product Related, Order Management Foundation, Mass Change Definition, Generate SQL).

Count

The button runs against the database and determines the total number of rows that are to be processed with the SQL component.

Click to jump to parent topicRegenerating Mass Change Definitions

If the record structures that are used by the PeopleSoft Order Management processes that include Mass Change are modified, the mass change definitions need to be regenerated. This is required because the mass change creates SQL statements from tables by matching field names field by field. If, for example, you add a column to a table that is used in an insert select statement in the Mass Change process, you must rebuild the statement to include this column. Execution of the old statement fails because the number of columns that are specified in the statement does not match the number of columns that is in the database.

For example, you add a field to the intermediate table OM_SCN_TMP to pass buying agreement information to the sales order. The modification requires changes to the mass change definitions because it affects information that is passed from the Buying Agreement to the order tables by the Create Sales Order process (OM_CNTRCT).

To Regenerate Mass Change Definitions:

  1. Review the Mass Change Types that are defined for the process to determine which of them reference the altered record on the Records and Join Fields page.

    You need to generate new SQL statements for any Mass Change Definitions that are built on these types. In this example, you must generate new SQL statements for any mass change definitions in Create Sales Order (OMCNTRCT) that use OM_SCN_TMP. For instance, OMSCN-1.

    Note. Review the Mass Change Types for other Order Management processes to ensure that they do not contain the altered records. If they do, you need to regenerate the Mass Change Definitions based on those types as well.

  2. Determine the Mass Change Definitions that use the Mass Change Type by using the Generate SQL page in Update/Display mode. If you do not specify the selection criteria, a list box appears showing all the Order Management Mass Change Definitions.

    Note. Currently, the Mass Change Definitions and Mass Change Types in Order Management match exactly; this may not always be the case.

  3. Select the first one that uses the Mass Change Type containing the altered record.

  4. Click the Clear SQL button.

  5. Click the Generate SQL button.

    Note. Generating the SQL takes some time.

  6. Click Save.

  7. Repeat Steps 3 through 6 for each of the mass change definitions containing altered records.