Jerin_Sebastian

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

Discussion created by Jerin_Sebastian Employee on Nov 3, 2014
Latest reply on Aug 12, 2016 by Jerin_Sebastian

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

Outcomes