E1: 09: General Ledger Interoperability Line Number Limitation in P0911Z1 (Store & Forward Journal Entry - Revisions), P0911 (Journal Entries) and F0911Z4 (F0911 Interoperability Table) (Doc ID 2824384.1)

Last updated on NOVEMBER 29, 2021

Applies to:

Symptoms

P0911 (Journal Entries) allows you to enter 999999 lines into the table. However when interoperability is activated to create journals entries in F0911Z4 (F0911 Interoperability Table) only 9999 lines can be created due to EDLN constraints.
EDLN (EDI - Line Number) is defined in Data Dictionary with 7 characters from which 3 are decimals. JELN (Journal Entry Line Number) is defined in Data Dictionary with 7 characters from which 1 is decimal.
In the same time only 9999 lines can be created via P0911Z1 (Store & Forward Journal Entry - Revisions) when there is a need to import more than 10000 lines for a single transaction.

Steps to replicate:

Option 1

a. Add a journal entry with more than 10000 lines using P0911. It will be possible as F0911 (Account Ledger) line counter is based on JELN field which has size of 7 but with only 1 decimal what allows 999999 lines.
b. After that go to P0911 version with interoperability on and try to copy the transaction created in the previous step. To activate interoperability check P0900049 (Journal Entry MBF Processing Options) for the interoperability version used and P0900160 (F0911 Interoperability Processing Options) to make sure that Processing Option 1 for the Transaction Type= JDEJE.
c. Journal entry will not be saved because of the inconsistency between EDLN and JELN formats:
• EDLN – 7 with 3 decimals
• JELN – 7 with 1 decimal

Option 2

a. In P0911Z1 (application based on F0911Z1 table with the same structure as F0911Z4) try to add more than 10000 lines to one transaction and save the transaction
b. There will be an error like below: JAS MSG317: Duplicate key not allowed. Please correct the duplicate key field.

When the customer tries to import the transaction in P0911Z1 with more than 9999 lines the interoperability does not work as it cannot store all records in F0911Z1 table and also in F0046 because of the size of EDLN field. The size of the field is 7 with 3 decimals which limits the number of lines to 9999 as standard insert processing does not use decimals at all.

Cause

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