My Oracle Support Banner

OBJECT_VERSION_NUMBER Does Not Get Incremented In ar_payment_schedules_all Table (Doc ID 2674661.1)

Last updated on SEPTEMBER 30, 2020

Applies to:

Oracle Fusion Receivables Cloud Service - Version 11.13.20.01.0 and later
Information in this document applies to any platform.

Goal

OBJECT_VERSION_NUMBER does not get incremented in table ar_payment_schedules_all when amount is applied to an invoice using Lockbox.

When a receipt is created manually in UI and applied against an invoice, OBJECT_VERSION_NUMBER is incremented but same does not happen when using Lockbox.

This has significant impact on the custom queries built, documentation also states that OBJECT_VERSION_NUMBER should be incremented.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.