My Oracle Support Banner

EGL: Spreadsheet Journal Import (JRNL1_WS) Template Buttons on Journal Sheet Missing. (Doc ID 3002196.1)

Last updated on FEBRUARY 04, 2024

Applies to:

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


For one user, when creating a new journal using Spreadsheet Journal Import (JRNL1_WS), the buttons on the journal sheet are missing/not available.
This issue is isolated to one specific user.

Implemented solution per Document 1954596.1 but it did not resolve it.

Steps to replicate:

1.  Open JRNL1_WS.
2.  Verify Trust Center Settings are selected for user (one in 'Add-ins' selected).
3.  Verify Macro Settings are correct for user (select 'Enable all macros').
4.  Add JRNLMCRO_WS add-in for user.
5.  Click on Setup & Defaults button to ensure setup is correct and click on New Sheet
6.  User opens new sheet, however, the buttons are not available for journal sheet.




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.