Best Of
Re: Xml Publisher - That was a bad request!
Working OK again in test after apply October's CPU.
Re: Guidance on what program to use to upload payroll journal entries from an external program.
Thank you for posting your thread question.
the most common enterprise approach is to use the General Ledger (GL) Batch Journal Import functionality.
Here’s how it typically works:
1. Standard Import Programs
1.1. Standard Batch Journal Import (P09110Z1 / R09110Z)
- Table: F0911Z1 (Batch Journal Entry - External table)
- Upload: Load your journal entries from the external program into the F0911Z1 table, usually with a flat file or an integration tool (such as Oracle Integration Cloud, or via SQL scripting if permitted).
- Process: Run the Journal Entry Batch Processor (R09110Z) to process entries from F0911Z1 into the main GL tables (F0911) and create the corresponding journal entry batches.
- Access: Application P09110Z is used for managing and reviewing imported entries.
1.2. Payroll-Specific Integration
- If your external payroll system can output files in the format expected by the F0911Z1 table, or you can map your payroll data accordingly, this is the preferred method.
2. Payroll Close - Create Journal Entries (R072902)
- If payroll journal entries are generated within JDE (i.e., you are running payroll inside JDE), the standard process is to run the Payroll Close process (R072902), which moves the payroll entries into the GL.
- Note: This is not designed for importing external payroll entries, but only for payrolls run in JDE.
3. Custom Integrations
- Some organizations develop custom UBE (Universal Batch Engine) or Orchestration routines to import payroll journal entries if the source system does not match JDE’s import format.
- E1: Can 3rd Party Payroll Journal Entries (JEs's), T1-T7, be brought into JDE Summarized in Same Manner as Final Update? (Doc ID 3091612.1) is another option as well.
In summary:
The standard approach is to load data into F0911Z1 and use R09110Z (Batch Journal Import) to create GL batches, regardless of the external source.
Important:
- Always validate the data structure and mapping in F0911Z1.
- Test thoroughly in a non-production environment.
- Ensure compliance with your organization’s security and data governance protocols when moving data into JDE.
Regards,
TanyaM - Oracle
Guidance on what program to use to upload payroll journal entries from an external program.
Hi,
The agency is in the early stage of transitioning to Dayforce for payroll processing but still need to upload payroll journal entries into JDE EnterpriseOne 9.2. Can anyone advise whether this integration is possible and what considerations, steps and/or configurations are required?
I've reviewed Document 3091612.1 - E1: Can 3rd Party Payroll Journal Entries (JEs's), T1-T7, be brought into JDE Summarized in Same Manner as Final Update?
Re: Can Forms be removed from a Reports installation
Oracle would not recommend removing any files under the ORACLE_HOME, unless the intent is of a specific nature. Since you don't need forms, I would say, the impact of removing the files you listed has not been studied or documented. So, it would be a subject of thorough testing from your side before deleting those files.
Re: All good things come to an end
Hey, we are going to miss you here for sure!
Hope you enjoy your well deserved retirement, but whenever you get bored there is always a chance that there is a question here to keep you busy for a while 😉
Best Wishes,
Lisandro
Re: All good things come to an end
Enjoy retirement Mark. Thank you for your contributions!
Re: All good things come to an end
Hi Mark,
It’s been our pleasure to have you around the community. You are really valuable asset to oracle community who contributes consistently with extraordinary knowledge which helped manu people. Its true honor for getting chance to work with you in community. Certainly many people including me learned so many things from you no doubt in that. Appreciate your support throughout the journey.All the best for your retirement. You are such an amazing person.
We all missing you. Thank you.
Regards,
murugan s
Re: What is the most common way in which you enter the My Oracle Support Community?
I have a bookmark bookmarked/saved URL or shortcut on my computer
Re: What is the most common way in which you enter the My Oracle Support Community?
clicking on the saved bookmarks




