Clarity

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

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

Regards,

Georgy

Thanks for sharing this, Jerin

NJ

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

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.

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