E1: 42: JDESOCHG3 Workflow Credit Hold Not Applied
Last updated on NOVEMBER 27, 2017
Applies to:JD Edwards EnterpriseOne Sales Order Processing - Version 9.1 and later
Information in this document applies to any platform.
On : 9.1 version, Sales
When using P4210 with Audit Logging and JDESOCHG3 workflow with Credit Checking, the order does not go back on credit hold if the price was increased and the workflow approver approves the change to the order. The order total exceeds the customer credit limit after the change.
The sales order should go back on C1 hold code after the AH hold code was approved if the price was changed on the order and the order total is over the customers credit limit.
The issue can be reproduced at will with the following steps:
1) P01012/P0111. Define a valid e-mail address for your E1 sign on user ID. Form Who’s Who take the Email/Internet Revisions row exit and define a valid e-mail.
2) P42090. Define you user ID on the AH hold code.
3) P42090. Verify C1 hold code is setup correctly and that another user is defined as the person responsible. In this instance there is one person to approve the order change and another to approve the credit hold.
4) P03013. Define a credit limit of $1 for a customer so that the order will go on hold.
5) P98800. Log on to an Admin or Web Dev client and activate JDESOCHG3.
6) P4210. In the Audit Log tab activate all 3 options by setting to 1.Define a C1 credit hold.
7) P4210. Log out of E1 and back in using another user ID unrelated to the AH or C1 credit holds. Enter a sales order and note it goes on C1 hold code.
8) P43070. Release the order.
9) P4210. Inquire on the order and increase the price and enter USR in the reason code. Click OK to save the order. The message “Your changes have been submitted for approval and are pending review” will pop up. Click OK.
10) P4210. Inquire on the order and it is now on AH hold code.
11) Log out of E1.
12) Verify an e-mail was sent to your Inbox with a link to approve the order change. Click on the Workflow Approval link.
13) P98805. Log on with your user ID and Accept the change.
14) P4210. Log back into E1 and inquire on the order. Note the AH hold code was removed and the change applied. However the order did not go back on C1 credit hold. The user that changed the order and the user that approved the order do not have authority to bypass the credit checking process.
15) P4210. Disable all Audit Log tab processing options.
16) P4210. Log on with your user ID and enter a new order. Note it goes on C1 hold.
17) P43070. Release the order and it goes off hold.
18) P4210. Re-inquire on the order and increase the price and save. The order will go back on C1 hold.
The issue has the following business impact:
Due to this issue, orders that should be going back on credit hold are bypassed.
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 hundreds of Community platforms