My Oracle Support Banner

Troubleshoot Performance Issue Opening a Purchase Order with a Large Number of Lines and the Maximum Number of Lines for a Purchase Order (Doc ID 1323231.1)

Last updated on JANUARY 24, 2020

Applies to:

PeopleSoft Enterprise SCM Purchasing - Version 8.8 SP1 to 9.1 [Release 8.8 to 9]
Information in this document applies to any platform.

Purpose

Purchase Orders (PO) can take a long time to open when they have a very large number of lines. The more lines that are on the PO the longer it takes to open the PO. Since PO's can have up to 99,999 lines (LINE_NBR field is 5 digits in length) , this could lead to longer periods of time to open the PO. This document will help you to workaround the performance issues you may experience when opening PO's with a large number of lines.

Troubleshooting Steps

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
Purpose
Troubleshooting Steps

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