My Oracle Support Banner

EGL9.2: Spreadsheet Journal Import(JRNL1_WS) Imported Journal gets Updated even if 'After successful import' Option in set up Chosen as 'Change import status to Do Not Import' (Doc ID 2624871.1)

Last updated on DECEMBER 31, 2019

Applies to:

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

Symptoms

JRNL1_WS - 'After successful import' Option "Change import status to Do Not Import" not working as expected. This will reload all journal rows instead of only the modified rows.


Steps to replicate:


1. Import Jounrals GM1, GM2, GM3:
Imported  3 journals - System ID (Unit, Journal ID, Date) Reference,
Description:
  1241 (US001, 0000000644, 01.01.2019) -, GM3 --Imported
  1242 (US001, 0000000645, 01.01.2019) -, GM1 --Imported
  1243 (US001, 0000000646, 01.01.2019) -, GM2 --Imported;
2. Check the "Change import status to Do Not Import";
3. Import again the journal header and change the amount for the second
journal
Change the Amount for the second journal Sys ID 1242 from 300/-300 to 500/-500 USD amount;
4. Imported  0 journals - System ID (Unit, Journal ID, Date) Reference,
Description:
Updated  3 journals - System ID (Unit, Journal ID, Date) Reference,
Description:
  1241 (US001, 0000000644, 01.01.2019) -, GM3 --Updated
  1242 (US001, 0000000645, 01.01.2019) -, GM1 --Updated
  1243 (US001, 0000000646, 01.01.2019) -, GM2 --Updated
As per the log file all 3 journals are Updated even only for one I changed the amount.



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.