Clarity

Expand all | Collapse all

Transaction tree

Jump to Best Answer
  • 1.  Transaction tree

    Posted 11-13-2014 05:18 PM

    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



  • 2.  Re: Transaction tree
    Best Answer

    Posted 11-14-2014 02:13 AM

    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.



  • 3.  Re: Transaction tree

    Posted 11-14-2014 05:22 AM

    The way tanch10  has mentioned is the way the transaction flow occurs in Clarity. Is there anything specific you are looking for ?

     

    NJ



  • 4.  Re: Transaction tree

    Posted 11-14-2014 10:17 AM

    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



  • 5.  Re: Transaction tree

    Posted 11-14-2014 10:20 AM

    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



  • 6.  Re: Transaction tree

    Posted 11-14-2014 10:26 AM

    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



  • 7.  Re: Transaction tree

    Posted 11-14-2014 10:48 AM

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

     

    Regards

    Suman



  • 8.  Re: Transaction tree

    Posted 11-14-2014 12:49 PM

    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.



  • 9.  Re: Transaction tree

    Posted 11-14-2014 10:18 AM

    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



  • 10.  Re: Transaction tree

    Posted 11-14-2014 10:45 AM

    No problem with the transaction flow.

    Here is the4 first page from

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



  • 11.  Re: Transaction tree

    Posted 08-24-2016 01:27 AM

    Another view to that is in

    CA PPM Financial Management Community Webcast 8-18-2016

    Slide 22.



  • 12.  Re: Transaction tree

    Posted 11-17-2014 11:50 PM

    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