Best Of
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
Re: What is the most common way in which you enter the My Oracle Support Community?
I have been landing upto this page via all the above mentioned method's.
Re: How do we identify the Shipments which are Write-Off by Receipt write-off batch?
The ReIM operations guide indicaties that RWO records are written to IM_FINANCIALS_STAGE.
The point at which these write offs are actions is when open receipts are closed either in RMS or from ReIM.
It indicates the accounting records written are to debit unmatched receipts (UNR) and credit receipt write off (RWO) with value. It also writes a zero record to Trade Accounts Payalble (TAP). It does not indicate the full record that is written but possibly you can ask someone in IT to view that table after reimreceiptwriteoff batch has run and before any integration which passes that to finance.
Looking at the table constraints on IM_FINANCIAL_STAGE in the data model docs, at least one of the following ID fields needs to be provided
RECEIPT_ID, PARENT_ID or DOC_ID.
That should mean RECEIPT_ID is the shipment ID for the receipt write off - but this needs validating against data on a test system or production in between the batch and any integration jobs that transfer data to Financials.
See also
What are the Scenarios in Which IM_FINANCIALS_STAGE Table Gets Populated? (Doc ID 2160334.1)
FAQ: Receiptwriteoff Functionality (Doc ID 1543167.1)
According to the data model document, the same status of C for Closed is used for those posted to AP and those closed by the batch.
Status of the shipments invoice matching. Valid values are U for unmatched, P for partially matched, M for matched and C for closed (posted to AP or closed out by batch). This column will only be populated for PO shipments.
Doesnt directly answer the question but hope it helps.
