Financial - JDE1 (MOSC)

MOSC Banner

Duplicate Key Error for F20111 (Log only error)

edited Mar 17, 2014 12:00PM in Financial - JDE1 (MOSC) 6 commentsAnswered


Hello,

There seems to be an issue, when ever someone makes an Expense Report and deletes a line in that report (before submidting)

that generates this error in the JDE log, but no error on the application screen. Can this error be ignored? I did not find any ESU pertaining to this either..

Line: 6285

Message: 07 Mar 2014 10:59:59,649 [SEVERE] - [JDBJ] SQLException occured
in the SQLPhysicalConnection.insert(): | Vendor code = 2627, SQL state = 23000
| Table or View Name = F20111 | Data Source = Business Data - PROD
com.microsoft.sqlserver.jdbc.SQLServerException: Violation of
PRIMARY KEY constraint 'F20111_PK'. Cannot insert duplicate key in object
'PRODDTA.F20111'. The duplicate key value is (T, 9009 , 1.4157e+006, PD-APP35 ,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

E1 Financial Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center