That's really odd.
PWXPC CDC would show a DTL__CAPXACTION of I, U, or D.
PWX ODBC CDC (which should only exist in really old environments that were never converted to PWXPC) would show a DTL__CAPXACTION of T, U, or D.
To be more specific: PWX doesn't put an F in DTL__CAPXACTION.
This implies one of three things:
1) The mapping updated DTL__CAPXACTION
2) Somehow, the record layout that you are using doesn't match the data
3) You have encountered a bug that I haven't seen in 9 years of working on PWX CDC.
The most likely of those would seem to be 1).
Thanks for looking into the issue. I found that the answer corresponds to you option #1.
The mapping value was updated manually to F therefore this is the value we encountered on the records.
Thanks a lot!
Glad you found it