Creating Change Map Templates
To define change map templates, use the Change Request Mapping component (CHNG_MAP_TEMPLATE).
This section provides an overview of change map templates and discusses how to create change map templates.
|
Page Name |
Definition Name |
Usage |
|---|---|---|
|
CHNG_MAP_TEMPLATE |
Create templates that are used to compare staged purchase order acknowledgement record fields and field values with target purchase order system record fields and field values. If a difference exists, change request records are created by the Change Load process. |
When you dispatch a purchase order to a supplier, the supplier acknowledges receipt of that purchase order. Sometimes the acknowledgement includes information that requires you to change the purchase order; for example, the supplier may not have the wanted quantity of an item or may not be able to deliver the items at the purchase order price. If you are using EDX with the suppliers, these acknowledgements may arrive electronically directly into the PeopleSoft Purchasing system.
When supplier acknowledgements arrive in the system by using EDX, you can run a multiprocess job (XML Inbound process) that enables you to extract purchase order data from supplier acknowledgements and stages it into the following temporary tables for different parts of purchase order transactions:
PO_HDR_EC
PO_LINE_EC
PO_LINE_SHIP_EC
The Change Load process loads data from the previous EC tables. Based on the change map template, the process compares staged source record fields and field values (PO_HDR_EC, PO_LINE_EC, PO_LINE_SHIP_EC) with target system record fields and field values (PO_HDR, PO_LINE, PO_LINE_SHIP). If a difference exists, the Change Load process creates change requests (CHNG_RSQT, CHNG_RQST_DTL).
Based on the Change Order template, the Change Purchase Order process (PO_POCHNG) creates the necessary change orders from these change requests. The Change Purchase Order process takes the change order information and creates change history records (PO_CHNG_HDR, PO_CHNG_LINE, PO_CHNG_SHIP), and then updates target system records with the changes.
Use the Change Request Mapping page (CHNG_MAP_TEMPLATE) to create templates that are used to compare staged purchase order acknowledgement record fields and field values with target purchase order system record fields and field values.
If a difference exists, change request records are created by the Change Load process.
Navigation:
Field or Control |
Description |
|---|---|
Source |
Identifies the change request source for the template. |
Record
Field or Control |
Description |
|---|---|
Target Recname (target record group name) |
Displays the target record group name. The target record is the system record that is updated with data from the source record. Individual target system record fields are updated with data from individual source record fields. |
Fields
Field or Control |
Description |
|---|---|
Source Recname (source record table name) |
Enter the source record name. Values include: PO_HDR_EC: EDX record for purchase order header data. PO_LINE_EC: EDX record for purchase order line data. PO_LINE_SHIP_EC: EDX record for purchase order schedule data. |
Source Transaction Fieldname |
Displays the source field name. This individual field in the source record contains data to be transferred to a target system record. |
Target Fieldname |
Displays the target system field name. The source data is transferred to this individual field in the target system record. |