My Oracle Support Banner

R11i AP: APPRVL: Invoice Validation Program Performance (Doc ID 416189.1)

Last updated on JANUARY 16, 2018

Applies to:

Oracle Payables - Version to [Release 11.5]
Information in this document applies to any platform.
***Checked for relevance on 25-Dec-2015***


On in Production:
When attempting to run 'Invoice Validation'  program (APPRVL)
the following error occurs.


Validating specified invoice : 518742
ORA-01555: snapshot too old: rollback segment number 35 with name "_SYSSMU35$" too small occurred in
AP_FUNDS_CONTROL_PKG.Funds_Reserve<-AP_APPROVAL_PKG.Approval<-APXAPRVLUpdate the Dist Base Amounts


The issue can be reproduced at will with the following steps:
1. Run invoice validation program for invoices matched to po's
2. Program ends in error


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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.