EAM9.2: Department (DEPTID) and Project (PROJECT_ID) in PS_INTFC_FIN Record Have Blank Prompt Table Edit Resulting to Edit Error. (Doc ID 2887104.1)

Last updated on MARCH 15, 2023

Applies to:

Symptoms

Department (DEPTID) and Project (PROJECT_ID) in PS_INTFC_FIN Record have blank prompt table edit resulting to edit error.
There are prompt table edits on all other chartfields on INTFC_FIN record, however, there is none for DEPTID and PROJECT_ID fields.
Without the prompt/edit, invalid departments and project can flow into the PS_COST record and cause problems when accounting entries are edited.

Steps to replicate:

- DeptID and Project_ID in PS_INTFC_FIN record have blank Prompt Table.
- DeptID and Project_ID in PS_COST record have populated Prompt Table.

Due to this, invalid value can flow thru General Ledger, and that's when it will be recognized.

 1.  Verify that the Department Chartfields.  For this test, will use Dept ID 10201 which is not in the list of valid values.
     (Set Up Financials/Supply Chain > Common Definitions > Design ChartFields > Define Chartfield Value – Department)
 2.  Using ExcelToCI template, upload an Asset with invalid DeptID = 10201.
 3.  After upload, check the Interface ID in Review Interface Transaction page.
     (Asset Management > Send/Receive Information > Interface Transactions > Review Interface Transactions)
 4.  Run Load into AM (AMIF1000).
     (Asset Management > Send/Receive Information > Interface Transactions > Load into AM)
 5.  Review Interface Transaction
     (Asset Management > Send/Receive Information > Interface Transactions > Review Interface Transactions)
 6.  Run Depreciation Calculation (AM_DEPR_CALC/AMDPCALC) processes.
     (Asset Management > Depreciation > Processing > Calculate Depreciation)
 7.  Run Close Depreciation (AM_DPCLOSE) process.
     (Asset Management > Accounting Entries > Close Depreciation)
 8.  Create Accounting Entries (AM_AMAEDIST) process.
     (Asset Management > Accounting Entries > Create Accounting Entries)
 9.  Run Generate Journals Request (FS_JGEN) process with Edit option on.
     (General Ledger > Journals > Subsystem Journals > Generate Jrnl from Subsystem)
10.  Check generated journal.  Journal in Status = E (Error) due to invalid DeptID.
     (General Ledger > Journals > Journal Entry > Create/Update Journal Entries)

See replication here.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.