Total Project Costs = (Committed Costs + Actual Costs)
You can report the flow of committed costs through Oracle Purchasing and
Oracle Payables, which can include the following buckets of committed costs:
2. PA_COMMITMENT_TXNS - This table is updated when you run Project SUmmarization program
http://docs.oracle.com/cd/A60725_05/html/comnls/us/pa/appo09.htm
AP_INVOICE_DISTRIBUTIONS_ALL - TABLE IMP FLAGS
After Invoice is accounted “ACCRUAL_POSTED_FLAG” and “POSTED_FLAG” Is set to “Y”
After AP invoice is Interface to PA “PA_ADDITION_FLAG” is set to “Y”
You can report the flow of committed costs through Oracle Purchasing and
Oracle Payables, which can include the following buckets of committed costs:
- Open Requisitions (approved, unpurchased requisitions)
- Open Purchase Orders (approved, uninvoiced purchase orders)
- Pending Invoices (supplier invoices not yet interfaced to Oracle Projects to
be included in project costs) - Select
PPA.segment1,
PPA.project_id,
PCT.transaction_source,
PCT.CMT_number,
PCT.expenditure_item_date,
PCT.cmt_approved_flag,
PCT.expenditure_type,
PCT.acct_burdened_cost
from
apps.PA_COMMITMENT_TXNS PCT,
apps.PA_PROJECTS_ALL PPA
where PPA.Project_id
= PCT.Project_id
--and PPA.segment1 = '202490'
and
PPA.project_id='18019'
2. PA_COMMITMENT_TXNS - This table is updated when you run Project SUmmarization program
http://docs.oracle.com/cd/A60725_05/html/comnls/us/pa/appo09.htm
AP_INVOICE_DISTRIBUTIONS_ALL - TABLE IMP FLAGS
After Invoice is accounted “ACCRUAL_POSTED_FLAG” and “POSTED_FLAG” Is set to “Y”
After AP invoice is Interface to PA “PA_ADDITION_FLAG” is set to “Y”