My Oracle Support Banner

E1: 37: Certificate of Analysis (COA) Extract (R37900) and Certificate of Analysis (R37460) Option to Print Only Ship Confirm Test Results and Not Old Tests Created During the Completion of the WO (Doc ID 2725813.1)

Last updated on NOVEMBER 04, 2020

Applies to:

JD Edwards EnterpriseOne Quality Management - Version 9.2 to 9.2 [Release 9.2]
Information in this document applies to any platform.


Test results are entered at Ship Confirm (P4205). If the test results are not entered in Ship Confirm when Certificate of Analysis (COA) Extract (R37900) is run some old test results are printed. The old test results were entered when the lot was created during the completion of the Work Order (WO) with different WO completions but to the same blank lot and generic location.

If no lot is used (blank lot) and the completion and shipping location is always the same, for example a generic location such as A1 is used, then all the past test results for that item and location will be printed.  This can result in a large pdf. Also wrong test results may be handled to a customer since the specific ones were not entered at ship confirm P4205.

A processing option behind R37900 should be provided to limit the test results selection from F3711 (Test Results) to allow uses to select only the ones specific to the particular sales order (SO) that is being shipped. If there are no specific records in F3711, then print a blank Certificate of Analysis. With a new processing option the F3711 records specific to the lot and item will not be selected even if they refer to that lot (be it blank or otherwise), location, Branch and item. Only the ones specific to the SO (item and lot/location) will be used.




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.