My Oracle Support Banner

E1: ORCH: QBE Filter on Subform Grid column return all records in Power Edit Form (Doc ID 2633548.1)

Last updated on APRIL 10, 2020

Applies to:

JD Edwards EnterpriseOne Tools - Version 9.2 and later
Information in this document applies to any platform.


Form service request created in Power Edit P41500 with :
• Filter on Company in form header
• QBE Filter on subform QBE grid columns ( DocumentNumber, Document Type ).

Orchestration running form service request returns ALL rows with filter on Company, ignoring QBE filter on grid columns.

Steps to duplicate :

• Fastpath P41500

• Start Process Recorder

• Type entry :
   00001 in FC_Company
   204 in qbe(GC_DocumentNumber)
   OV in qbe(GC_Document Type)

• Click Find

• Return Values:
  Controls: Company
  Columns: DocumentNumber, DocumentType

• Stop

• Save service request as "PowerEdit_P41500_with_QBE"

• Create Orchestration with service request "PowerEdit_P41500_with_QBE"
   Add Orchestration Inputs: Input_KCO, Input_DOC, Input_DCT

• Run Orchestration which returns 682 rows (including OV 204)




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.