My Oracle Support Banner

E1: 09: Add the DGL (G/L Date) to the Key Field of F0018 (Taxes File) (Doc ID 2847758.1)

Last updated on FEBRUARY 08, 2022

Applies to:

JD Edwards EnterpriseOne General Ledger - Version XE and later
Information in this document applies to any platform.


The DGL (G/L date) field in F0018 (Taxes File) is not a key field in the current design of the system.
Following are the key fields in F0018:

 - Order Number (DOCO)
 - Or Ty (DCTO)
 - Ord Suf (SFXO)
 - Line Number (LNID)
 - Order Co(KCOO)
 - Date Updated (UPMJ)
 - Time Updated (UPMT)

Due to this, if you create F0911Z1 (Journal Entry Transactions - Batch File) records with multiple DGJs (G/L Date) in one EDTN (EDI - Transaction Number) and run the R09110Z (Journal Entry Batch Processor), an 'ORA-00001' error may happen and record insertion into F0911 (Account Ledger File) / F0018 may fail.
The customer is requesting to add the DGL (G/L Date) to the key field of F0018.




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.