Blog / Category
GL
10 articles in this category
Reporting Currency Vs Translation In Oracle Fusion
Introduction/ Issue: Organizations operating across multiple countries and currencies require accurate financial reporting in more than one currency. In Oracle…
Unable to Enter a Journal with Multiple Currencies in Oracle Fusion General Ledger
Introduction/ Issue: In Oracle Fusion Cloud General Ledger, users previously experienced the ability to create a single journal entry with multiple currencies.…
Auto Reversal Journals Setup -Fusion
Introduction/ Issue: How to define Auto reversal journal setup Purpose of Auto Reversal: Auto Reversal in Oracle Fusion is used to automatically reverse journal…
Query to get the subledger transfer to GL details by period wise
SELECT gjjlv.period_name “Period Name”, gjb.name “Batch Name”, gjjlv.header_name “Journal Entry”, gjjlv.je_source “Source”, glcc.concatenated_segments “Accounts…
R12 Oracle General Ledger Setup
r12-oracle-general-ledger-setup
Auto Reversal Journal Setup
Auto reversal in oracle means , We will create some rules and setups for some GL journal source which will automatically reverses the GL journals for that Sourc…
Custom Role and Custom lookup Creation in Fusion
custom-role-and-custom-lookup-creation-in-fusion This document describes how create a custom role and custom lookup in Oracle Fusion. In this document we have l…
Journal Entry Report for Audit purpose
Introduction This will displays the journal entry details SELECT DISTINCT –LEG_ENT.COUNTRY, (select DISTINCT HRL.COUNTRY from apps.XLE_ENTITY_PROFILES LEP, apps…
Script to update natural account
CREATE OR REPLACE PROCEDURE XX_GL_EXTRACT_ENABLE_ACCOUNT AS v_set_id number; v_position_account_type number:=3; v_acc_flex_value_set &…
Third Party Process – Colombia
This page explains the steps involved in generating the Colombia Third party report balances. This process ensures the passage of the third party details to GL.…