My Oracle Support Banner

EGL9.2: Spreadsheet Journal import(JRNL1_WS) Getting "Errored: Document type is required for Business Unit" Error Even If Document Sequencing Is Disabled In Installation Options (Doc ID 2431824.1)

Last updated on MARCH 13, 2020

Applies to:

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


Getting the error “Document Type is required for Business Unit XXXXX.” when tried to import the journal through spreadsheet.

Steps to Replicate:
1. Navigate to: Set up Financials > Install > Installation Options > Overall > Disable Document Sequencing
2. Navigate to: Set Up Financials/Supply Chain > Business Unit Related > General Ledger > General Ledger Definition. Search for any Business Unit.
Verify the Checkbox “Enable Document Sequencing” is grayed.
3. Open the new spreadsheet import template (JRNL1_WS.xlsm). Click on the Setups & Defaults button.
4. Create a new journal sheet.
5. Enter the journal header details.
6. Enter the journal Line details.
7. Import the journal using the online import button

Please follow the replication screenshots for more details.


Errored: Document type is required for Business Unit xxxxx.







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.