My Oracle Support Banner

E1: 42: P42270 When User Queries by Order Company and Sold To Number, the Records Are Not Fetched at All. (Doc ID 2218073.1)

Last updated on DECEMBER 27, 2016

Applies to:

JD Edwards EnterpriseOne Sales Order Entry - Version 9.1 and later
Information in this document applies to any platform.


On : 9.1 version, Sales
P42770 One View Open Sales Inquiry

In P42270 when user queries by Order Company and Sold To Number, the records are not fetched at all.

1.In P03013 query for address book number 132 and we find that it belongs to companies 00000, 00001 and 00200.
2.In P4210 customer service inquiry, query for the same Sold To Address Number and system retrieves two SO records belonging to different companies 00001 and 00200.
3.However in P42270 query by the Order Company and Sold To Number and no records are being fetched.


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

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