EGL9.2 : Journals Created Via Spread Sheet Journal Import(JRNL1) And Flat File Import Process Do Not Appear On WorkCenter Journal Ready For Processing Pagelet (Doc ID 1922640.1)

Last updated on APRIL 17, 2017

Applies to:

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

Symptoms

Issue:
-------

GL WorkCenter, Journal Ready For Processing Pagelet, is not fetching journals from created via Spread Sheet Import / Flat File Import Process since they do not have fiscal year and accounting date populated in JRNL_HEADER record until they are edited by Journal Edit process.

Steps to Replicate:
---------------------
1. Create a Journal via Spread Sheet Journal Import tool or journal flat file import process.
2. Do not edit the journal. Bring the journal online. Notice fiscal year and accouting date is not populated yet.
3. Go to GL Workcente > My Work > Journal Ready For Processing Pagelet. Notice the journal created via spread sheet journal import tool or flat file process does not appear.
4. Edit the filters for Journal Ready For Processing Pagelet. Remove the fiscal year and hit ok.


Actual Behavior:
------------------

An error message will pop up stating, "A value is required for FISCAL_YEAR". No option to edit the filters as well, as a result, journal cannot be searched.

Expected Behavior:
---------------------

Journals coming from spread sheet import or flat file process should have fiscal year and accouting date populated, so that they can be made on Journal Ready For Processing Pagelet.

Cause

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 hundreds of Community platforms