My Oracle Support Banner

E1: 42: Repost Active Sales Orders (R42995) Resets Opportunity ID (F4211.OPID) to Zero (Doc ID 2836270.1)

Last updated on JANUARY 28, 2022

Applies to:

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

Symptoms

Opportunity Number (F4211.OPID) is reset to zero after changing Branch Commitment Days and running Sales Repost (R42995).

The client reproduced the issue with the following steps:

  1. Client setup Sales Price Based On Date Advanced Preference (18) to set the Price Effective Date = 3 (Promised Ship Date).
  2. The client has modified the Sales Order Entry (P4210) program to copy the value in the Based on Date field (F4211.DBTS) into the Opportunity ID (F4211.OPPID) field.
  3. Set Branch Plant Constants (P41001) to commitment days of 10.
  4. With the Sales Price Based On Date Advanced Preference (18) activated the client creates a sales order with a Requested Date > 10 days in the future causing the order to be future committed.
  5. Save the sales order.
  6. Sales Price Based On Date Advanced Preference (18) is applied so the Price Effective Date = Promised Ship Date. Also customized SO Entry (P4210) program copied the based on date value of 3 into the Opportunity Number field.
  7. Now change the Branch Plant Constants (P41001) to commitment days of 30.
  8. Now Run Repost Active Sales Orders (R42995).
  9. Check the Opportunity ID after running Repost. The Opportunity ID was changed from 3 to 0.

Changes

 

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
Changes
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.