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 entries that need to be cancelled…
Read MoreQuery 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”, 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 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 Source as per the Auto Reversal Setup. here below we will…
Read MoreCustom 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 listed all the required setup details with screen shot to…
Read MoreJournal 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.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 MoreScript 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 varchar2(240):=’XXX_COA_ACCOUNT’; /**Pass the COA name/ flex_value_exeception EXCEPTION; v_upd_count number:=0; BEGIN SELECT …
Read MoreThird 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. This is mandatory in…
Read More