Clarity

Expand all | Collapse all

CA Clarity Tuesday Tip: How to find the Post to WIP timing of a  particular transaction

  • 1.  CA Clarity Tuesday Tip: How to find the Post to WIP timing of a  particular transaction

    Posted 11-03-2014 06:04 PM

    There has been discussions going around to find the exact time when a particular transaction was Posted to WIP - basically, what was the exact time a transaction hit the PPA_WIP table?

    Here is the answer to it!

    PPA_POSTINGBATCH would be the table you should go to for finding the Post to WIP timing. This table will have the POSTDATE column with the posted date.

    The batchno is the column which joins ppa_wip and ppa_postingbatch tables. For more info on the table columns, please check the Tech Ref guide.

    The below query can be used to find the posting timing of a particular transaction. Replace '12345' with the actual PPA_WIP.TRANSNO value.

    SELECT * FROM PPA_POSTINGBATCH WHERE BATCHNO IN (SELECT BATCHNO FROM PPA_WIP WHERE TRANSNO = 12345)


    A TEC doc is also written for this 

    http://www.ca.com/us/support/ca-support-online/product-content/knowledgebase-articles/tec1254703.aspx



  • 2.  Re: CA Clarity Tuesday Tip: How to find the Post to WIP timing of a  particular transaction

    Posted 11-04-2014 12:45 AM

    This will be so helpful at times....Thanks a lot Jerin

     

    Regards,

    Georgy



  • 3.  Re: CA Clarity Tuesday Tip: How to find the Post to WIP timing of a  particular transaction

    Posted 11-04-2014 04:55 AM

    Thanks for sharing this, Jerin

     

    NJ



  • 4.  Re: CA Clarity Tuesday Tip: How to find the Post to WIP timing of a  particular transaction

    Posted 11-04-2014 05:44 PM

    Thanks for the tip Jerin!

    Jerin Sebastian wrote:

     

    There has been discussions going around to find the exact time when a particular transaction was Posted to WIP - basically, what was the exact time a transaction hit the PPA_WIP table?

    Here is the answer to it!

    PPA_POSTINGBATCH would be the table you should go to for finding the Post to WIP timing. This table will have the POSTDATE column with the posted date.

    The batchno is the column which joins ppa_wip and ppa_postingbatch tables. For more info on the table columns, please check the Tech Ref guide.

    The below query can be used to find the posting timing of a particular transaction. Replace '12345' with the actual PPA_WIP.TRANSNO value.

    SELECT * FROM PPA_POSTINGBATCH WHERE BATCHNO IN (SELECT BATCHNO FROM PPA_WIP WHERE TRANSNO = 12345)


    A TEC doc is also written for this

    http://www.ca.com/us/support/ca-support-online/product-content/knowledgebase-articles/tec1254703.aspx



  • 5.  Re: CA Clarity Tuesday Tip: How to find the Post to WIP timing of a  particular transaction

    Posted 08-11-2016 12:11 PM

    Hi Jerin_Sebastian,

     

    Today only I hit through this post !! sorry for being late in comment.

    curious that PPA_WIP.ENTRYDATE date serves the same purpose ? or its for different meaning. Just want to clear my understanding.



  • 6.  Re: CA Clarity Tuesday Tip: How to find the Post to WIP timing of a  particular transaction

    Posted 08-11-2016 10:37 PM

    Hi KP,

    Ideally EIP.ENTRYDATE should help figure out the WIP timing but I have seen many community posts stating this field is not completely reliable and have seen discrepancies in the timings which made me to use the  PPA_POSTINGBATCH  table instead of entrydate in WIP.

    Hope this helps.

     

    Thanks,

    Jerin