My Oracle Support Banner

Purchase Order Summary Folder Is Not Displaying All Operating Unit (OU) Records During the Sort (Doc ID 2100374.1)

Last updated on JULY 03, 2018

Applies to:

Oracle Purchasing - Version 12.1.3 to 12.2 [Release 12.1 to 12.2]
Information in this document applies to any platform.


Purchase Order Summary folder is not displaying all Operating Unit (OU) records after Data Sort.
Find the sorted data is for the operating unit of the order where the cursor is when selecting data sort.
Therefore lose many purchase order that were retrieved from "Find purchase order".

Expect the data sort to sort all orders retrieved from "Find purchase order" and listed at "Purchase OrderHheaders" form

The issue can be reproduced at will with the following steps:
1. Find purchase order form
  - no fields entered to restrict selection; including Operating unit = blank

2. Purchase Order headers form
  see 10 rows PO numbers included

3. Folder > Sort Data
  Sort Data window
  Number: ascending
  Release:No ordering
  Rev: No ordering
  x Run Query

4. Purchase order history form
  all orders are 10100005 - 101000014
  at bottom of form FRM-40341: Last record of query retrieved
  Record 10/14

  Do not see purchase orders in 1500016 in returned list


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

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

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