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 11.5.10.2 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.
***Checked for relevance on 25-Dec-2015***

Symptoms

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

ERROR


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


STEPS

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


Cause

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
Symptoms
Cause
Solution
References


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.