This chapter covers the following topics:
This flow will help user to create requirement for a project.
PLSQL Flow
PJR_Create_Requirement_PLSQL
The following are the prerequisites for executing the flows:
This flow assumes that all mandatory setups required for creating requirement for a project are already done and that the user is licensed to use Oracle Project Resource Management.
The user and responsibility used must have all required security functions needed to create and manage project requirements.
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) |
| PA: Availability Duration | 0 |
| PA: Availability / Over commitment Calculation Period | Daily |
| PA: Starting Requirement Status | Open |
The following predefined data must be used:
| Entity | Field Name | Field Value |
|---|---|---|
| PA_SET_GLOBAL_INFO | Version Number | 1 |
| User Id | 1319 | |
| Resp Id | 53321 |
The following data must be set up:
| Entity | Field Name | Field Value |
|---|---|---|
| PA_RES_MANAGEMENT_AMG_PUB_REQUIREMENT_IN_Rec | ||
| Requirement Name | ?DBA | |
| Number of Requirements | 1 | |
| Project Role Id | 1042 | |
| Project Role Name | DBA | |
| Project Id | 18044 | |
| Project Name | AP-PJR-DEMO | |
| Project Number | AP-PJR-DEMO | |
| Staffing Owner Person Id | 4385 | |
| Location Country Code | US | |
| Location Country Name | United States | |
| Location Region | MA | |
| Location City | Boston | |
| Min Resource Job Level | 8 | |
| Max Resource Job Level | 47 | |
| Description | Demo Requirement | |
| Start Date | 01-JAN-2006(dd-MON-YYYY) | |
| End Date | 31-DEC-2018(dd-MON-YYYY) | |
| Status Code | 101 | |
| Status Name | Open | |
| Calendar Type | Project | |
| Calendar Id | 550 | |
| Calendar Name | East Standard | |
| Start Adv Action Set Flag | Y | |
| Adv Action Set Name | Publish to Everyone | |
| Search Min Availability | 0 | |
| Search Min Candidate Score | 0 | |
| Expenditure Type Class | ST | |
| Expenditure Type | Professional | |
| FCST Job Group Id | 2 | |
| FCST Job Id | 17 |
Following are the details of the scenarios in the flow:
| Scenario | Objective | Artifact/Method | Component Set | Main Component |
|---|---|---|---|---|
| PJR_Create_Requirement | Create requirement for a project. | PLSQL | PA_RES_MANAGEMENT_AMG_PUB_CREATE_REQUIREMENTS | PA_RES_MANAGEMENT_AMG_PUB_CREATE_REQUIREMENTS_Main |