E1:42: After upgrading to 9.2 Release 22 and 64 Bit applications SO Entry (P42101) Fails To Insert Record In Held Orders Table (F4209) (Doc ID 2914432.1)

Last updated on AUGUST 24, 2023

Applies to:

Symptoms

After upgrading to 9.2 Release 22 and 64 Bit applications, one of the order holds is updated on the Sales Header table (F4201.HOLD) but is not getting a record inserted into the Held Orders Table (F4209) so it cannot be released using the Release Held Orders (P43070) program.

Steps to Reproduce:

1. Create a new Customer (P03013)
   1. Put “AA” in Hold Orders Code in Customer Billing Instructions
   2. Put $1.00 in Credit Limit on Customer Master Credit Tab
2. Create a new Hold Code “HA” in Order Hold Constants (P42090)
3. Create a Version of SO Entry (P4210) with Order Process Hold = “XX” and Customer Credit Check = “C1” in Order Holds tab.
4. Create a version of Powerforms SO Entry (P42101) version that calls the P4210 version.
5. Create a Powerforms Sales Order (P42101) with the specific customer. The “AA” hold defaults into the hold code field in the order header.
6. Change the Hold Code in the Header from “AA” to “HA” and go to the detail line and enter a quantity and item that will cause the order to go over the credit limit. Click the “Submit and Close” button.
7. Warning appears that the order is going on three holds
   1. HA (CSR Hold)
   2. C1 (Credit Hold)
   3. XX (Administrative Hold)
   4. Click Submit and close again.
8. The Sales Order Inquiry (P42101) shows a 4th hold “AA” from the Customer Billing Instructions
9. Check the Held Orders Inquiry (P43070).
   1. HA, C1 and XX hold codes appear
   2. AA hold which appears on the Sales Order Inquiry (P42101) does not appear on the Held Orders Inquiry (P43070).
   3. The AA hold code is stuck and cannot be released.

Changes

 The issue first appeared after upgrading to 9.2 Release 22 and 64 Bit applications.

Cause

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