This chapter covers the following topics:
The objective of this flow is to create an Agreement and add multiple funding lines to it in Oracle projects. This flow has been stitched leveraging the excel feature of the Oracle flow builder for entering multiple data.
PLSQL Flow
PJB_Cr_Agmt_Mul_Funding_PLSQL
This flow assumes that two contract projects with same customer have been already created.
The following profile options must be set:
| Profile | Value |
|---|---|
| HR: Business Group | Vision Corporation |
| HR: Security Profile | Vision Corporation |
| MO: Operating Unit | Vision Services |
| MO: Security Profile | Vision Corporation |
| MO: Default Operating Unit | Vision Services |
| GL Ledger Name | Vision Services (USA) |
The following predefined data must be used:
| Entity | Field Name | Field Value |
|---|---|---|
| PA_SET_GLOBAL_INFO | User Id | 1319 |
| Resp Id | 50604 | |
| Resp Appln ID | 275 | |
| Operating Unit ID | 458 |
The following data must be set up:
| Entity | Field Name | Field Value |
|---|---|---|
| PA_AGREEMENT_PUB_AGREEMENT_REC_IN_TYPE_Rec | Pm Agreement Reference | API_AGREEMENT_001 |
| Agreement Rec In Type | Input | |
| Customer Id | 1004 | |
| Customer Num | 1004 | |
| Agreement type | Purchase Orders | |
| Amount | 20000 | |
| Term Id | 4 | |
| Revenue Limit Flag | N | |
| Owned by Peron Id | 53 | |
| Template Flag | N | |
| Owning Organization | 458 | |
| Agreement Currency | USD | |
| PA_AGREEMENT_PUB_FUNDING_REC_IN_TYPE_Rec | Script Iterator | 1 |
| Pm Funding Reference | API_FUNDING_001 | |
| Project Id | 1009 | |
| Task Id | #NULL | |
| Allocated amount | 5000 | |
| Date Allocated | (DD-MON-YYYY) | |
| Funding Category | Original | |
| Script Iterator | 1 | |
| PM Funding Reference | API_FUNDING_002 | |
| Project ID | 1027 | |
| Task ID | #NULL | |
| Allocated Amount | 5000 | |
| Date Allocated | (DD-MON-YYYY) | |
| Funding Category | Original | |
| PA_AGREEMENT_PUB_FUNDING_REC_OUT_TYPE_Rec | Script Iterator | 1 |
| Funding Rec Out Type | OUTPUT | |
| Project Funding ID | YES | |
| Return Status | YES | |
| Script Iterator | 1 | |
| Funding Rec Out Type | OUTPUT | |
| Project Funding ID | YES | |
| Return Status | YES | |
| PA_AGREEMENT_PUB_AGREEMENT_REC_OUT_TYPE_Rec | Agreement Rec Out Type | OUTPUT |
| Agreement Id | YES | |
| Customer Id | YES | |
| Return Status | YES | |
| PA_AGREEMENT_PUB_CREATE_AGREEMENT_Main | API Version Number | 1 |
| Commit | F | |
| Init Msg List | T | |
| PM Product Code | MSPROJECT |
Following are the details of the scenarios in the flow:
| Scenario | Objective | Artifact Method | Component Set | Main Component |
|---|---|---|---|---|
| PJB_Cr_Agmt | This scenario creates an agreement with multiple funding lines | PA_AGREEMENT_PUB.CREATE_AGREEMENT | PA_AGREEMENT_PUB_CREATE_AGREEMENT | PA_AGREEMENT_PUB_CREATE_AGREEMENT_Main |