E1: 90CA Changing the Expiry Date on a Commission Code Throws an Insert Failure Error on the F90CA003 Table in the Jde.log

(Doc ID 1569177.1)

Last updated on JUNE 10, 2016

Applies to:

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

Symptoms

Using P03013/Customer Master Revisions. When selecting a customer and changing the expiration date on the commission records, it doesn't error on the application, however, it adds the following error in the jde.log:

 
Steps to duplicate:

1)Search for a customer in P03013 and select it, make sure the Sales Team Override (STOF) is checked on.
2)Form Exit , Billing Information
3)Form Exit , Commission Codes
4)Adding a Sales Rep and let the dates be defaulted to the Effective Date of Today and Expiration Date to 12/31/2040
5)Saving all the way back to Customer Master Revisions and going back to Work With Customer Master
6)Selecting the same Customer, Form Exit Billing Information, Form Exit Commission Codes
7)Changing the Expiration Date from 12/31/2040 to 12/31/2015
8)Saving all the way back to customer master Revision
9)At this point we see the insert failure errors in the logs.

Cause

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