BICC - Set Extract Date for Individual PVO in a JOB

Question

Hi All,

We have a job for data extracts which extracts data from Around 100 PVOs. In our initial extract some pvos were erroring out due to timeout issue. So we separately ran them in different jobs . Now our data is extracted but would like to move those PVOs back to the original job with the last extract date. how can we do that?

Regards,

Siddharth Dang

AnkitR Gupta · Answer

or you can use update PVO with where clause to restrict data as well.

Dimple-Nagesh-Support-Oracle · Answer

Hi  SiddharthDang-Oracle ,

Can you try the following and let me know if that helps

* Navigate to Advanced Extract Configuration option for an individual PVO.
* Setup the Initial Extract Date .. to the desired Last Extract date.
* Reset the individual PVO to Full Extact.

Thanks

Dimple N

SiddharthDang-Oracle · Answer

Hi @AnkitR Gupta ,

I could not find any option to set the last extract date for individual PVO in a job. I can either set the last extract date at the whole job level or set the initial extract date of a PVO. In the later case, it filters on the basis of the created date rather than the last update date. So there may be chances of a data loss.

Are you aware of any other method to set the last extract date?

Regards,

Siddharth Dang