General Ledger - EBS (MOSC)

MOSC Banner

Journal import in error

edited Jan 18, 2020 4:02AM in General Ledger - EBS (MOSC) 1 commentAnswered

Hi, we found this note "Doc ID 99779.1"

but we dont find the next the path, where can we find it?

Solution Description

--------------------

1. Navigate to Setup-> System-> Control.

2. Verify "Number of Accounts in Memory" and "Number of

   Journal Lines to Process at Once" fields.

   The values in those fields should not be excessive.

To Bottom

 Problem Description ------------------- Journal Import ends with:  ORA-1455: converting column overflows integer datatype  Navigation path: Journals-> Import-> Run   Solution Description -------------------- 1. Navigate to Setup-> System-> Control. 2. Verify "Number of Accounts in Memory" and "Number of Journal Lines to Process at Once" fields. The values in those fields should not be excessive.  In this case, they were set to 999,999,999,999. They changed the values to 2500 and 5000 and Journal Import ran successfully.   Explanation ------------ Those parameters determine the amount of memory allocated to Journal Import program.  References ---------- Bug:1155094   Additional Search Words ----------------------- Journal import GLLEZL ORA-1455  

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center