My Oracle Support Banner

EGL9.2: Analysis Types Not Updating on Journals Loaded via Spreadsheet Import. (Doc ID 2413608.1)

Last updated on JUNE 22, 2018

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
PeopleSoft Enterprise FIN Project Costing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Issue:

The General Ledger Analysis Types are set up on the Installation Options/Project Costing Integration.
Online, the Analysis Types for Expenditures and Revenue are being updated correctly.  
When using the spreadsheet import utility (JRNL_WS), the Analysis Types are only being updated for the visible rows when the journal is saved online.  
Is there a way that the Analysis Types for all the journal lines can be updated at once?

Steps to replicate :

1.  GL Analysis Types are set up on the Installation Options/Project Costing Integration
2.  Load journal thru Spreadsheet Journal Import (JRNL1_WS) where An Type values were left blank.
3.  Upon upload, check the journal online, and all 32 lines do not have An Type populated.
4.  Run online edit journal, and only 10 lines in the 1st page are populated with An Type, while for 11-32 lines, An Type fields remain blank.

Changes

 

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!


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