This chapter covers the following topics:
Creates Accrual offer for a customer of type organization. Creates the accruals for a certain period of time on a certain set of products for the designated customer for a legit order placed. Offer will be applied on a placed order only after the offer is activated. This flow uses single data in the creation of Accrual Offer and creates a single Accrual Offer.
PLSQL
Create_Accrual_Offer_Activate_PLSQL
The following are the prerequisites for executing the flows:
Customers and Contacts.
Products
Budget
The following profile options must be set:
| Profile | Value |
|---|---|
| OZF: Global Flag for Pricing Related Objects | Yes |
| QP: Security Control | ON |
The following predefined data must be used:
| Entity | Field Name | Field Value |
|---|---|---|
| FND_GLOB_APPS_INITIALIZE | User Id | 1002795 |
| Resp Id | 22371 | |
| Resp Appl Id | 682 |
The following data must be set up:
| Interface | Field Name | Field Value1 | Field Value2 |
|---|---|---|---|
| OZF_OFFER_PUB_MODIFIER_LIST_Rec | Offer TYPE | ACCRUAL_OFFER | |
| Budget Source Id | 11283 | ||
| Reusable | N | ||
| User Status ID | 1600 | ||
| Offer Code | l_offer | ||
| Status Name | DRAFT | ||
| Status Date | SYSDATE(0) | ||
| Modifier Level Code | Line | ||
| Custom Setup Id | 121 | ||
| Offer Amount | 100I | ||
| Budget Amount Tc | 100 | ||
| Budget Amount Fc | 100 | ||
| Transaction Currency Code | USD | ||
| Functional Currency Code | USD | ||
| Start Date Active | SYSDATE(0) | DD-MM-YYYY | |
| End Date Active | SYSDATE(1) | DD-MM-YYYY | |
| List Type Code | PRO | ||
| Ql Qualifier Id | 1290 | ||
| Name | API_CKM_ACC_OFFR | ||
| Description | API_CKM_ACC_OFFR | ||
| Ask For Flag | N | ||
| Budget Source Type | FUND | ||
| Ql Qualifier Type | CUSTOMER | ||
| Offer Operation | CREATE | ||
| Modifier Operation | CREATE | ||
| Currency Code | USD | ||
| Committed Amount Eq Max | Y | ||
| Global Flag | N | ||
| Orig Org id | 204 |
Following are the details of the scenarios in the flow:
| Scenario | Objective | Artifact Method | Component Set | Main Component |
|---|---|---|---|---|
| Create_Accrual_Offer_Activate | This scenario creates a an Accrual Offer for a customer | OZF_OFFER_PUB.Create_Accrual_Offer | OZF_OFFER_PUB_PROCESS_MODIFIERS | OZF_OFFER_PUB_PROCESS_MODIFIERS_Main |
| Activate_Offer | This scenario Activated the created Accrual Offer for a customer | OZF_OFFER_PUB.Activate_Accrual_Offer | OZF_OFFER_PUB_PROCESS_MODIFIERS | OZF_OFFER_PUB_PROCESS_MODIFIERS_Main |
| Verification | This scenario validates components used in the flow | - | VERIFICATION_COMPONENT |