Understanding Of Technical Components
 |
| Oracle Projects-Project Type |
Name Enter Project Type Name, which is unique
Class Select Indirect, Capital or Contract from the list.
Effective From Enter start date, from which project type will be effective
Service Type Select appropriate service type from list.
A service type is a custom reporting attribute that you assign to each financial task to represent activities that you want to track for financial purposes. You can use service types to group tasks for custom reporting
Work Type Select appropriate work type to represent a classification of work from list
- Administrative Use this box to identify administrative indirect projects on which that you can create administrative assignments in Oracle Project Resource Management
- Unassigned Time Enable this option if you want to track available resource time in utilization reporting
- Inter company Billing Choose this box if you want to use this project type for inter company billing projects
- Organization Planning Define a unique project type to identify organization projects used in organization forecasting. Define project type for organization forecasting projects with a class of indirect and then enable the Organization Planning check box.
Hi Buddy,
ReplyDeleteFully agree on this. We’re seeing a lot of projects tackle big complex problems but few seem to have taken into consideration and in particular reasons to adopt.
I have below kind of data
Transaction | Debit | Credit | Begening Balance | Ending balance
INV1 | 100 | | 300 | 400
INV2 | | 200 | |
INV3 | 130 | | |
INV4 | | 150 | |
This is above data , and we need to calculate begening balance and ending balance.
Begening balance of INV2 will be ending balance of INV1, and begening balance of INV3
will be ending balance of INV2, … goes on..
And ending balance will be calculated as begening balance + debit_amount or begening_balance - credit_amount. but how can i put ending balance of current row to begening_balance of next row.
Note - First row of begening balance and ending balance will come through gl_balances itself, but need to calculated values from 2nd row.
Very useful post !everyone should learn and use it during their learning path.
MuchasGracias,
Hi Buddy,
ReplyDeleteFully agree on PLSQL. We’re seeing a lot of projects tackle big complex problems but few seem to have taken into consideration and in particular reasons to adopt.
I have below kind of data
Transaction | Debit | Credit | Begening Balance | Ending balance
INV1 | 100 | | 300 | 400
INV2 | | 200 | |
INV3 | 130 | | |
INV4 | | 150 | |
This is above data , and we need to calculate begening balance and ending balance.
Begening balance of INV2 will be ending balance of INV1, and begening balance of INV3
will be ending balance of INV2, … goes on..
And ending balance will be calculated as begening balance + debit_amount or begening_balance - credit_amount. but how can i put ending balance of current row to begening_balance of next row.
Note - First row of begening balance and ending balance will come through gl_balances itself, but need to calculated values from 2nd row.
Very useful post !everyone should learn and use it during their learning path.
MuchasGracias
Ajeeth