Introduction/ Issue: Organizations operating across multiple countries and currencies require accurate financial reporting in more than one currency. In Oracle Fusion Financials, finance teams often face confusion between Reporting Currency…
Read MoreIntroduction/ Issue: In Oracle Fusion Cloud General Ledger, users previously experienced the ability to create a single journal entry with multiple currencies. However, this behaviour has changed, and the system…
Read MoreIntroduction/ Issue: How to define Auto reversal journal setup Purpose of Auto Reversal: Auto Reversal in Oracle Fusion is used to automatically reverse journal entries that need to be cancelled…
Read MoreSELECT gjjlv.period_name “Period Name”, gjb.name “Batch Name”, gjjlv.header_name “Journal Entry”, gjjlv.je_source “Source”, glcc.concatenated_segments “Accounts”, gjjlv.line_entered_dr “Entered Debit”, gjjlv.line_entered_cr “Entered Credit”, gjjlv.line_accounted_dr “Accounted Debit”, gjjlv.line_accounted_cr “Accounted Credit”, gjjlv.currency_code “Currency”, arm.name “Payment…
Read MoreAuto 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 Source as per the Auto Reversal Setup. here below we will…
Read Morecustom-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 listed all the required setup details with screen shot to…
Read MoreIntroduction This will displays the journal entry details SELECT DISTINCT –LEG_ENT.COUNTRY, (select DISTINCT HRL.COUNTRY from apps.XLE_ENTITY_PROFILES LEP, apps.XLE_REGISTRATIONS REG, apps.HR_LOCATIONS_ALL HRL, apps.gl_ledgers gl, apps.HR_OPERATING_UNITS HRO where LEP.TRANSACTING_ENTITY_FLAG = ‘Y’ and…
Read MoreCREATE OR REPLACE PROCEDURE XX_GL_EXTRACT_ENABLE_ACCOUNT AS v_set_id number; v_position_account_type number:=3; v_acc_flex_value_set varchar2(240):=’XXX_COA_ACCOUNT’; /**Pass the COA name/ flex_value_exeception EXCEPTION; v_upd_count number:=0; BEGIN SELECT …
Read MoreThis 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. This is mandatory in…
Read More