My Oracle Support Banner

EGL 9.2: Spreadsheet Journal Import Getting "Invalid Document Type Value" Post Pum Update 35 (Doc ID 2828360.1)

Last updated on SEPTEMBER 26, 2022

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 and later
Information in this document applies to any platform.


 When header BU doesn't have the document sequencing enabled and for line BU document sequencing is enabled, then journals are not getting imported via online process.

Steps to replicate:
1) Please Navigate to Installation page using below navigation
   Main Menu -> Set Up Financials/Supply Chain -> Install -> Installation Options
   a) Select InterUnit Method as Direct
   b) Check Use Legal Entity for InterUnit.
   c) Enable Document Sequencing.
2) Please navigate to General Ledger Definition Page using below navigation and ensure that Doc Seq is disabled for Header BU and enabled for Line BU.
   Main Menu -> Set Up Financials/Supply Chain -> Business Unit Related -> General Ledger -> General Ledger Definition
3) Sample InterUnit Template used are mentioned below. To verify this please open Inter/Intra Unit tab after completing step 2.
   a) For Header BU it's US001.
   b) For Line BU it's CORP.
3) Create new Journal Type, Journal Code and Document Type with Sample Setid as US003.
   a) Document Type : ONL-TST
   b) Journal Code : ONLINE
   c) Journal Type : FS
4) Changed setid of record group FS_42 for set control value Line BU to US003. Please use below navigation.
    Main Menu -> PeopleTools -> Utilities -> Administration -> TableSet Control
    a) Search for Line BU set control value.
    b) Search for Recording group F_42 and kindly replace the setid mapped to it by US003.
5) Please navigate to Ledgers for a Unit page using below navigation and Open Journal Edit Options tab to change the Document Type mapped to the recoding group for which we will be creating journal entries in next step.
    Main Menu -> Set Up Financials/Supply Chain -> Business Unit Related -> General Ledger -> Ledgers For A Unit
    a) New Document Type mapped is ONL-TST.
6) Populate the Header and Line details of Journal in Spreadsheet and generate a text file using write to file functionality of Spreadsheet.
7) Run GL_ECXL_BATC AE to import journal using the text file created in above step.
 Navigation to run AE  Main Menu -> General Ledger -> Journals -> Import Journals -> Spreadsheet Journals.




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

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