Journals
Discussion List
-
BI Publisher - Object_version_number column in gl_je_headers tableDear All, After creating a journal manually, the object_version_number in gl_je_headers is set directly to the value 3. Can anyone tell me what the purpose of this colum…George Mattar 13 views 1 comment 0 points Most recent by Uddipta Bhaumik-Oracle General Ledger & Intercompany -
Purge GL interface tableSummary: Is there a way to automatically purge GL interface for journals which are successfully processed ? Version (include the version you are using, if applicable): 2… -
Can we Display Rejection reason via Notification to user if Journal is auto rejectedHi Team, We have configured the Journal auto-rejection rule if the Attachment or Journal description is missing at the Journal Header level. When a journal is rejected, …Ashwini Naik 334 views 4 comments 0 points Most recent by Ravi Kanth Vuddagiri General Ledger & Intercompany -
Assets FX revaluationSummary: Client would like to see Assets journals reflected in GL Reporting Currency Ledger as FX entered and Functional currency Accounted in Reporting Currency Ledger.… -
How to prevent Manual journal entry in the secondary ledgerSummary: Our secondary ledger is for reporting purposes only. We want to prevent the user from entering journals directly into the secondary ledger. How can this be achi…Malcah Netzer 58 views 3 comments 0 points Most recent by Malcah Netzer General Ledger & Intercompany -
Does the system allow to add attachments when Journal is under approval process?If yes, please share how. if not, is there any workaround? Thank youVictor Chrabieh 12 views 1 comment 1 point Most recent by Antima Rai-Oracle General Ledger & Intercompany
-
How to hide or remove approve button in the journal entry page?Summary: How to hide or remove approve button in the journal entry page? users can still see Approve/ Reject button even if they are not the approver. Content (please en… -
Incorrect FX rate entered by userWhile working to reconcile Intercompany balances, client identified that they have made an error with the CAD/USD Exchange rate loaded into Fusion. They loaded .07434 in…Pooja Parikh 11 views 2 comments 0 points Most recent by CA Nitesh Sharma General Ledger & Intercompany -
General Ledger Allocation Rule for DepreciationSummary: How to create Allocation Rules for Depreciation on Capital Stock (converted from Revenue stock) on Oracle Cloud? Content (please ensure you mask any confidentia… -
Can Revaluation be rerun in a prior period?Summary: Revaluation has run for the current period (JUN-24). The journal has been posted and the GL period has been closed. New accounting period has been opened (JUL-2… -
Third Party Control Account Per Ledger/Primary Balancing SegmentSummary: Is there a possibility to enable the enable third party control account per ledger or primary balancing segment value? Note: we have multiple ledgers sharing th…Ahmed Maher Kadeh 12 views 1 comment 0 points Most recent by Sharada Beleramane-Oracle General Ledger & Intercompany -
Where can I find the lookup related to ADFDIWhere can I find the lookup related to ADFDI? please share me the navigation. Also when trying to search using the user module under Common Lookups, its not returning an…D Mandal 31 views 3 comments 0 points Most recent by Lakshmi Alagappan-Oracle General Ledger & Intercompany -
How to get rid of warning 'Manage Journals give warning too many matching records found'Manage Journals give warning: Too many matching records found. Specify additional criteria to limit the number of records. I open SR for this but no solution provided. T… -
Revaluation Reversal Journal to be generated laterSummary: 1. Specify Ledger Options - Run AutoReverse after open period is checked 2. Manage Journal Reversal Criteria Set Category - Revaluation Reversal period - Next N… -
Sandbox default value from LOVHi, is there a way to default the Category field on the Create Subledger Journal Entry screen (General Accounting > Journals > Create Subledger Journal Entry) Currently,…Suhailah Raza 23 views 2 comments 0 points Most recent by Suhailah Raza General Ledger & Intercompany -
One Journal category transaction should not flow to Secondary and reporting ledgerSummary: The business case is they wanted one Journal category to be created for which any GL journals created with that category should not flow to Secondary ledger and…chetan bachani 22 views 2 comments 0 points Most recent by Lakshmi Alagappan-Oracle General Ledger & Intercompany -
Error in loading Journals/batches attachments using ERPObjectAttachment ServiceSummary: Hi Team, We are trying to load journal attachments using ERPAttachment SOAP service, but getting below errors, any pointers to what roles are needed, seeded Gen…raban 49 views 1 comment 0 points Most recent by Lakshmi Alagappan-Oracle General Ledger & Intercompany -
Journal Upload - ADFDI-05559Hello, I have a user that is trying to upload an ADFDI journal that has aprox 20,000 lines on it. During the submit phase they are getting the following error: Row cache…BenSayers 158 views 1 comment 0 points Most recent by Antima Rai-Oracle General Ledger & Intercompany -
All the Manual JV created accounting date is getting defaulted to End of MonthSummary: Hi Experts Can you please advise while creating Manual Journals, Accounting date is getting defaulted to End of Month. Why the JV is created with System Date (1… -
Auto transfer of debtors having credit balance and creditors having debit balance to another accountSummary: How can debtors having credit balance and creditors having debit balance be transferred automatically to another account in order to show the same separately fr…Jiten Jataniya 12 views 1 comment 0 points Most recent by CristinaV1-Oracle General Ledger & Intercompany -
Transfer of amount from Retained Earning account to a separate GL accountCustomer wants to schedule an automatic transfer of 20% of the amount transferred in retained earning account during the year to a separate GL a/c at year end. How this …Jiten Jataniya 2 views 1 comment 0 points Most recent by CristinaV1-Oracle General Ledger & Intercompany -
Must the revaluation journal reversal be triggered by opening a new GL Period?Summary: Good Afternoon everyone, Could you please assist me with the following two questions (happy to log them separately if required): As I understand it, the journal… -
GL Journal Lines reporting for Mexico's Electronic Invoice UUIDSummary: I have a requirement to store Mexico's electronic invoice number (aka UUID) at the GL Journal Lines level. The UUID is being passed from Oracle Cloud Payables t…NancyR_Bravo 100 views 2 comments 0 points Most recent by NancyR_Bravo General Ledger & Intercompany -
How to update GL Journal category (on Journal Header) for Unposted Batch in bulk or using REST APISummary: We need to update journal category for some of the Journal Entry at header , is there any Rest or SOAP API? Journal Header / Batch is unposted and Approval stat…Gaurav Godbole 13 views 2 comments 0 points Most recent by Gaurav Godbole General Ledger & Intercompany -
Has anyone ever come across this particular error when uploading CVRs via Spreadsheet?I am updating a Production environment with the latest batch of CVRs and there are quite a lot of condition filter values(less than 500). When I go to submit, I am getti…Eoin O'Neill 12 views 1 comment 0 points Most recent by Razvan Paduraru-Oracle General Ledger & Intercompany -
Can we Create General Ledger Account Sequences for Branch wise in Oracle fusionHI We have Branch Segment in Chart of Accounts, So Business Will select the Branch values in Code Combination in while Journal Creation, So based on that Can we create G…Gujjari Raju 11 views 5 comments 0 points Most recent by Razvan Paduraru-Oracle General Ledger & Intercompany -
journal interfaceSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
Why does the User currency rate 1 requires a pre defined Exchange Rate?Summary: Why does the User Rate 1 requires a pre defined Exchange Rate Content (please ensure you mask any confidential information): When we do a foreign currency journ…ramesh.sivapalan 5 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
Can Journal source LOV be restricted through a specific custom role while spreadsheeupload?Summary: Can Journal source LOV in subledger journal entry be restricted through personalization for a specific custom role while spreadsheet upload? Requirement is to r…Neha_Naringrekar 14 views 1 comment 0 points Most recent by Andreea Brem-Oracle Subledger Accounting & Accounting Hub -
What is the maximum number of supporting documents that can be attached to a Journal BatchSummary: What is the maximum number of supporting documents that can be attached to a Journal Batch ? What should be the maximum size of each attachment. (The informatio…Jayendra Sreekar Kurali 22 views 2 comments 0 points Most recent by Jayendra Sreekar Kurali General Ledger & Intercompany