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