My Oracle Support Banner

E1: 13: 17: JAS_MSG346 Error in Work with Work Orders - Self Service (P48201/P17714) After Adding a Field with Form Extension (Doc ID 2799425.1)

Last updated on NOVEMBER 29, 2021

Applies to:

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

Symptoms

Add a new field using Form Extension Manager in P17714 application, then create a new self service work order from P48201 which calls P17714. After the work order is generated, when closing the application P17714 and going back to P48201, a JAS error is encountered. Close the error window and inquiry on the newly created work order. Nothing returned in the grid. But if searching the work order in P48201 version ZJDE0001, the work order is displayed in the grid, including the value entered for Assigned To.

Note the JAS error occurs in TR 9.2.5.1 and 9.2.5.2 and when adding a new field using Form Extension Manager. In TR 9.2.4.4 no errors occur.


The issue can be reproduced at will with the following steps:

  1. Add Address Number - Assigned To (F4801.ANP) field to P17714 form W17714F (G1316 -> Work Order Entry - Self Service) using Form Extension Manager.
  2. Add a work order via P48201 ZJDE0006 form W48201F which calls Work Order Entry - Self Service (P17714 ZJDE0004 form W17714F) to add a new work order (G1316 -> View Work Orders - Self Service).
  3. Add data in P17714 and click save. A work order number was generated.
  4. Close P17714 and note the error JAS_MSG346: JAS database failure: [N0_SET_CLAUSE_FOR_UPDATE] Update cannot be executed without a set clause.

Cause

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
Symptoms
Cause
Solution
References


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