Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Oracle tables for when a payment schedule has been changed from the default

edited Mar 8, 2021 7:39AM in Receivables & Collections 1 comment

Summary

Trying to write sql to find any payment schedules for receivables invoices that have been altered from the initial default values

Content

Hi,

 

I have some experience writing sql against Oracle Financials but I have come to a total brickwall in trying to find a way to find out which receivables invoices have had their payment schedules altered from their initial defaulted values, other than enabling auditing, which I do not want to do due to the data volumes involved, is there any way to achieve this?

 

thanks for any input,

 

Robert.

Version

21a
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!