Regenerating 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.