My Oracle Support Banner

EGL: After Applying Fix for Bug 35240806, Create Accounting Entry (AMAEDIST) Results to Unique Constraint Error. (Doc ID 2991189.1)

Last updated on DECEMBER 11, 2023

Applies to:

PeopleSoft Enterprise FIN Asset Management - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Running Create Accounting Entries (AMAEDIST) process after the AM Spreadsheet Upload (IUT Transfers) results to unique constraint error.  This was initially reported in <Bug 35240806>,
fixed in Image 48, however the issue could still be replicated in Image 48 demo.

Error/s:

File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1851 Error Position: 0 Return: 805 - ORA-00001: unique constraint (PRFS.PS_DSTLN_IU_TAO5) violated Failed SQL stmt: INSERT INTO PS_DSTLN_IU_TAO5 (PROCESS_INSTANCE, BUSINESS_UNIT, ASSET_ID, BOOK, DTTM _STAMP, CF_SEQNO, ACCOUNT, ALTACCT, DEPTID, DISTRIBUTION_TYPE, TRANS_TYPE, ACCOUNTING_DT, IU_MAP_KEY , OPERATING_UNIT, PRODUCT, FUND_CODE, CLASS_FLD, PROGRAM_CODE, BUDGET_REF, AFFILIATE, AFFILIATE_INTR A1, AFFILIATE_INTRA2, CHARTFIELD1, CHARTFIELD2, CHARTFIELD3, BUSINESS_UNIT_PC, ACTIVITY_ID, RESOURCE _TYPE, RESOURCE_CATEGORY, RESOURCE_SUB_CAT, ANALYSIS_TYPE, PROJECT_ID, CATEGORY, COST_TYPE, TRANS_IN _OUT, TRANS_CODE, APPL_JRNL_ID, AMOUNT, JOURNAL_ID, JOURNAL_DATE, JOURNAL_LINE, GL_DISTRIB_STATUS, O PRID, LEDGER_GROUP, LEDGER, FISCAL_YEAR, ACCOUNTING_PERIOD, BUSINESS_UNIT_GL, PC_DISTRIB_STATUS, CUR


Steps to replicate:

  1.  Add an Asset with multiple cost rows for different DeptIDs in each Books.
       Example:
         - For Book CORP:
             DeptID 10000 = 800,000.00
             DeptID 15000 = 200,00.00
         - For Book FEDERAL:
             DeptID 10000 = 800,000.00
             DeptID 15000 = 200,00.00    
      (Asset Management > Asset Transaction > Owned Assets > Basic Add)

  2.  Run Depreciation Calculation.    
      (Asset Management > Depreciation > Processing > Calculate Depreciation)

  3.  Generate an IUT AM Spreadsheet Template.
      (Set Up Financials/Supply Chain > Product Related > Asset Management > Import Spreadsheet Setup > Define AM Spreadsheet Template)

  4.  Open the generated csv file and populate the template with Asset details.

  5.  Upload Spreadsheet Data.  AM_LOAD goes to Success and note the Interface ID.
       (Asset Management > Send/Receive Information > Import Data via Spreadsheet > Upload Spreadsheet Data)

  6.  Load Interface ID into AM.  AMIF1000 goes to Success.    
       (Asset Management > Send/Receive Information > Interface Transactions > Load into AM)

  7.  Review Interface Transactions.
      (Asset Management > Send/Receive Information > Interface Transactions > Review Interface Transactions)

  8.  Run Depreciation Calculation.
 
10.  Create Accounting Entries (No Success).
      (Asset Management > Accounting Entries > Create Accounting Entries)

See replication here.

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