What is the transaction flow in Clarity PPM13.3 ?
From where it starts, which database table it goes to , how it comes to the POST to WIP transactions - the full work flow of a transaction.
Request ur help at the earliest.
Its little difficult to provide the transaction work flow completely. But here is the brief information :
1)Timesheet transacition - Post Timesheet - IMP_TRANSACTIONIMPORT table - shown as new transactions under invalid transactions.
Via XOG/Scheduler - directly into IMP_TRANSACTIONIMPORT table.
2)If Project/resource financially enabled, Post transactions to financials will move the transactions from IMP_TRANSACTIONIMPORT to PPA_TRANSCONTROL and PPA_TRANSACTION_VALUES if timesheet and project fulfil all requirements.
3)Transaction Entry function - Directly to to PPA_TRANSCONTROL and PPA_TRANSACTION_VALUES.
4)POST to WIP - Moves data from PPA_TRANSCONTROL and PPA_TRANSACTION_VALUES to PPA_WIP and PPA_WIP_VALUES. (Future transactions will be left back)
5)Import financial actuals - Copies transaction data from PPA_WIP and PPA_WIP_VALUES to assignments.
Hope this information helps.
The way tanch10 has mentioned is the way the transaction flow occurs in Clarity. Is there anything specific you are looking for ?
Yes i am looking for a specific answer, if any portlet does not show data/actuals that a user say has already submitted, what can be the possible causes behind that issue. What should be the troubleshooting approach for this kind of an issue??
Most probably the jobs which are dependent like timeslice. So we need to know what portlet you are taking about and then we can look in further.
But will that be enough for this issue. Are there any other appproach to look into , other than commenting it as a portlet issue. ??
Other approach is to know which tables are used to pull the data
The troubleshooting process is to start from identifiable timeentries and follow the data and verify after every step that it is there until you get to the point or place which is the source for you portlet.
thanks for the reply. It was really helpful, but i have another specific answer , that i have uploaded as a reply to NJ.
No problem with the transaction flow.
Here is the4 first page from
Another view to that is in
CA PPM Financial Management Community Webcast 8-18-2016
As "urmas" has mentioned, "The troubleshooting process is to start from identifiable timeentries and follow the data and verify after every step that it is there until you get to the point or place which is the source for you portlet"
Follow the steps in the data flow and check for the tables in which the data is supposed to be filled.
Retrieving data ...