My Oracle Support Banner

EGL9.2:Spreadsheet Journal Import Loading 0 Journals with SSL Connection. (Doc ID 2862862.1)

Last updated on JULY 07, 2023

Applies to:

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


Spreadsheet journal import not loading the Journals for SSL connection, JRNL1_WS imports 0 journals.
No messages in IB Service Monitor and no data in Journal Header staging tables and other staging tables.

It was found out that Load Balancer is used in front of the IB gateway and SSL is terminated at the LB.
In Service Operation GL_JRNL_IMP, Req. Verification is set to 'SSL'.

Steps to replicate:

1.  Using JRNL1_WS template, populate required fields.
2.  Then, Import Now.

Note:  Site is using Load balancer.




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.