Skip to Main Content

E-Business Suite

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

"Transaction Processing Details"."Last Update Date" is null for millions of rows

User_Z8Y6MJun 19 2022

Hi,
I'd like incrementally pull data from "Incentive Compensation - Payments Real Time",
but "Transaction Processing Details"."Last Update Date" is null for millions of rows.
This situation causes me not to trust the content of the oracle seeded "Transaction Processing Details"."Last Update Date".
Does it make sense that
SELECT count("Transaction Processing Details"."Transaction Id") count_of_Transaction_Id
FROM "Incentive Compensation - Payments Real Time"
WHERE "Transaction Processing Details"."Last Update Date" is null
returns millions instead of ZERO?

Thanks,
Arkady

Comments
Post Details
Added on Jun 19 2022
0 comments
132 views