Clarity

Hi Team,

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.

Thanks

sid

Hello Sid,

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 ?

NJ

NJ,

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??

Thanks

sid

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.

Regards

Suman

Hi suman,

But will that be enough for this issue. Are there any other appproach to look into , other than commenting it as a portlet issue. ??

Thanks

sid

Other approach is to know which tables are used to pull the data

Regards

Suman

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.

tanch10

thanks for the reply. It was really helpful, but i have another specific answer , that i have uploaded as a reply to NJ.

Thanks

sid

No problem with the transaction flow.

Here is the4 first page from

https://communities.ca.com/message/47274771#47274771

Another view to that is in

CA PPM Financial Management Community Webcast 8-18-2016

Slide 22.

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.

NJ