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 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