Siebel Consumer Goods Guide > Trade Funds > About Configuring Trade Funds >

About the Consumer Goods Payment Business Service


The CG Payment Business Service uses the CPG Plan business object and the following business components:

  • CPG Plan Account Promotion
  • CS CG MDF Promotion Category Allocation
  • CG MDF Promotion Allocation
  • CS CG Promotion Category Deal Payment
  • CPG Promo Deal Payment
  • CPG Plan Account Promotion Product
  • CS CG Plan Account Promotion Category
  • CPG MDF Allocation
  • CG Promo Product Fund Payment
  • CPG Check Payment via MDF

The business service performs the following primary steps:

  • Copies the Amount field into Paid Amount in the Paid bucket.
  • Rolls up the Paid Amount to the Payments Paid field in the Parent.
  • Rolls up Paid payments in the allocation to the Actual Total Spend field in the parent promotion.

When the workflow process in About Rolling Up Paid Payments invokes the CG Payment business service, the same business service executes the following actions:

  1. The CG Payment business service gets the ROW_ID of the payment record with a status of Paid.
  2. Gets the Fund Allocation Id, which is the Allocation Id of the payment record.
  3. Gets the CPG Plan business object and the CG MDF Promotion Allocation business component.
  4. Runs through the records in the CG MDF Promotion Allocation business component and positions to the record with the ROW_ID of the Fund Allocation Id.
  5. Finds the values of the Fund Promotion Id, Plan Account Promo Prod Id, and Plan Account Promotion Cat Id fields from the positioned record so as to determine the deal type as seen in the following Table 21:
    Table 21. Deal type as per field value
    Deal Type
    Fund Promotion Id
    Plan Account Promo Prod Id
    Plan Account Promotion Cat Id

    Promotion Deal

    NOT Empty

    Empty

    Empty

    Promoted Category Deal

    NOT Empty

    Empty

    NOT Empty

    Promoted Product Deal

    NOT Empty

    NOT Empty

    NOT Empty

  6. Based on the deal type, the business service instantiates the following business components from the CPG Plan business object as seen in Table 22:
    Table 22. Instantiated business components of a deal for CPG Plan
    Deal Type
    Business Component
     
    Parent BC
    Child BC
    Grand Child BC

    Promotion Deal

    CPG Plan Account Promotion

    CG MDF Promotion Allocation

    CPG Promo Deal Payment

    Promoted Category Deal

    CS CG Plan Account Promotion Category

    CS CG MDF Promotion Catetgory Allocation

    CS CG Promotion Category Deal Payment

    Promoted Product Deal

    CPG Plan Account Promotion Product

    CPG MDF Allocation

    CG Promo Product Fund Payment

  7. The CG Payment business service then executes the Parent business component.
  8. The CG Payment business service positions the Parent BC of the deal on the following Id field as seen in Table 23:
    Table 23. Id of the Parent business component based on deal type
    Deal Type
    ROW_ID

    Promotion Deal

    Fund Promotion Id

    Promoted Category Deal

    Plan Account Promo Prod Cat Id

    Promoted Product Deal

    Plan Account Promo Prod Id

  9. Next, it positions the Child business component with Fund Allocation Id.
  10. Finally, it positions the Grand Child business component with ROW_ID as in Step 1.
  11. After the Grand Child is positioned, it sets the following values for this business component:
    • Paid Amount = Trade Fund Amount
    • Submitted Amount = 0
    • Pending Amount = 0
  12. After the values are set, it saves the record with updated values and forces the Rollup.
Siebel Consumer Goods Guide Copyright © 2018, Oracle and/or its affiliates. All rights reserved. Legal Notices.