Enterprise Asset Management - EBS (MOSC)

MOSC Banner

Physical Inventory

edited Apr 4, 2014 12:00PM in Enterprise Asset Management - EBS (MOSC) 1 commentAnswered

Why I got this error "

Create-Intfc-Entries

e:\fs92dev\sqr\ampi1000.sqr: AMIF1000 - SQL Statement =

Create-Intfc-Entries-Location: INSERT INTO PS_INTFC_PHY_A

SQL Status = 2601, SQL Error = [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.PS_INTFC_PHY_A' with unique index 'PS_INTFC_PHY_A'. The duplicate key value is (10000016, 4, PUCMM, 000000000095, Mar 27 2014 2:36PM, , 0, 0, PHY, ).

" when I execute the process "Generate Transactions" at Load/Match/Reconcile PI Info page?


I checked and analyzed the ampi1000.sqr, but I found that when the functions  (Create-Intfc-Entries-Location & Create-Intfc-Entries-Custodian) execute, both do the same Insert to the INTFC_PHY_A table.

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center