General Ledger
Discussion List
-
PATD, QATD and YATD calculation from the GL_DAILY_BALANCES tableWe need to develop an extract for EPM with fields PERIOD,COMP(segment1),ACCT(segment2),TRD PTNR(segment5),PRODUCT(segment6),ACCT ACT(segment8),TRANS TYPE(segment7), MTD_…Liya-Oracle 14 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
How can we check the list of GL accounts which are not mapped under any hierarchy?How can we check List of GL accounts which are not mapped under any hierarchy of "GL Account Segment"? for eg: if there are 100 GL accounts out of those only 80 GL accou…Jiten Jataniya 14 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
Journal SequencingSummary: Can I create a Sequence by prefix characters other than Numbers Content (please ensure you mask any confidential information): We are trying to create a Journal…RajibPramanik 2 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Manual reconciliation screen are typically derived fromHi Team I would like to know how the options below are appearing on the manual reconciliation screen and why other segments are not shown. If we need other segments to b…Aswani Buddiga-Oracle 2 views 1 comment 0 points Most recent by Julien_Dubouis General Ledger & Intercompany -
Reference Date in GL Journal HeaderSummary: Hi do you know, if it's possible to use Reference Date in the Journal Header level to recalculate value from Primary Ledger to Secondary Ledger with exchange ra…
-
How to reorder the Journal category selection list?Summary: Some of the seeded journal category will not be used in our requirement. How can we put them at the last of the journal category selection list? Content (please…Alfred Choi 11 views 3 comments 0 points Most recent by Julien_Dubouis General Ledger & Intercompany
-
Need to clarification on Journals amount roundingSummary: When Journals are posted to the GL, we need to know whether the system rounds the amount up or down during calculations Content (please ensure you mask any conf…Kannaki Pugalenthi 17 views 1 comment 0 points Most recent by Sharada Beleramane-Oracle General Ledger & Intercompany
-
Validating Intercompany Elimination Allocation Rule ImplementationSummary: Hi everyone, I'm working on implementing an intercompany elimination allocation rule in our General Ledger with a specific organization structure. I'd like to v…Patrick Chrabieh 44 views 3 comments 2 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany -
7 Legal entities - Suggestion from community - one ledger or multiple LedgersCustomer has 7 legal entities of same country and Same Currency - what would be recommendation ? would be one ledger or multiple ledgers by legal entity wise What would …Sandeep Nihalani 52 views 4 comments 0 points Most recent by Jakeeagarwal General Ledger & Intercompany
-
Can some bsv's create journals in a closed period?Summary: The requirement is to allow some BSV's in a ledger to allow journals created in a closed period. Content (please ensure you mask any confidential information): …
-
General Ledger - A report that includes all prior periods opened during the past 4 weeksWe are looking for a report to accomplish the following : A report from Oracle that includes all prior periods opened during the past 4 weeks, must be generated and revi…Wilson Chelakadan 11 views 1 comment 0 points Most recent by Wilson Chelakadan General Ledger & Intercompany -
Is there any way to segregate the lease asset and post two different liability accounts every year?Is there any way to segregate the leased assets into short term and long-term liability and post it into respective liability accounts every year by the system?Aishwarya gannoji 17 views 6 comments 0 points Most recent by VINAY K SINGH General Ledger & Intercompany
-
Create Balance Cube is failingSummary: Content (please ensure you mask any confidential information): Create Balances Cubes: Transfer General Ledger Balances is ending up error. The log file is sugge…RajibPramanik 263 views 1 comment 0 points Most recent by Antima Rai-Oracle General Ledger & Intercompany
-
How to Reconciling General Ledger and Budget with Different Conversion Rate Types in OracleSummary: Budget Control: Set Default Rate Type: BOT Selling Transaction:Create a Transaction AP Invoice by specifying Coversion rate type as user rate. Compare Amount be…
-
Allocation Rule(Formula) Deployment errorHi, We got a requirement for year end allocation rule where ending balance should go to equity and non equity account. Please help with the Run time variable selection a…D Mandal 2 views 1 comment 0 points Most recent by Sharada Beleramane-Oracle General Ledger & Intercompany
-
Can we create Mass allocation for VATSo we have a business requirement where they are expecting Mass Allocation for VAT. E.g. We have VAT Receivables 100$ VAT Payables 20$ VAT Clearing Account 80$ (So Mass …Hemanth Buccapatnam Tirumala 21 views 3 comments 0 points Most recent by Hemanth Buccapatnam Tirumala General Ledger & Intercompany
-
Improve GL error message for related value setWhen a journal is imported into the General Ledger (GL) and fails due to incorrect related values (when the related value set is activated at the value set level), the e…Thibault Dufnerr 167 views 3 comments 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
How to convert Assets using Historical Rate in Reporting CurrencySummary: We plan to create a new Reporting Currency Ledger with the Conversion Layer as Journal, currently their is an existing Reporting Currency tied to PL with Conver…
-
How to modify Journal batch name for all journals and add period and created by objectsSummary: Our client is using EBS R12 as their legacy system and currently they have to automate the journal batch name user need not provide the details automatically sy…Basant Parihar 43 views 2 comments 0 points Most recent by Basant Parihar General Ledger & Intercompany
-
What are the 'archive tables' of feature 'ACCOUNTING DATA ARCHIVE AND PURGE'Hi All, As we know, there is a new feature named 'ACCOUNTING DATA ARCHIVE AND PURGE' in 24B. Ref: It says 'This action will move the data from the transaction tables int…
-
General Ledger Journal and Subledger Transaction Mapping ReportIt looks like Oracle has provided this report for China localization only, we have a similar requirement for US operations, is it possible to run this report for Non Chi…
-
Is it possible to batch create allocation rulesSummary: Currently, we create allocation under General Ledger → Create Allocation Rules, and all the rules can only be edit and created one by one at a time. We are goin…
-
Revaluation Journal- Forex account balance and Asset Account balance needs to be nullifiedSummary: An incorrect revaluation journal was posted in Nov-19 to the unrealised Forex and Asset account, during Data migration, while conversion from AUD to USD. which …Saumyashri 12 views 5 comments 0 points Most recent by Karun_Jain-Oracle General Ledger & Intercompany
-
How to change Amount Masking Per Millions in Oracle Fusion?Summary: Right now, the amount masking format is 1,000,000 but we need to change the format to 10,00,000 at the instance level. Content (please ensure you mask any confi…
-
Create a sandbox without any PersonlizationSummary: We want to create a sandox without any Personalization. How to create a Sandbox without any persolization Content (please ensure you mask any confidential infor…RajibPramanik 13 views 1 comment 0 points Most recent by Andreea Brem-Oracle Fusion Applications Administration
-
Stat Journal Auto Approval Rule Not WorkingSummary: Stat Journal Auto Approval Rule not working Below is what has been created By Oracle. Can you Assist by Reviewing and seeing what is incorrect?
-
How to remove Journal Import errors after Purge Inteface Tables has been run?Summary: We have four journals that are no longer in table GL_INTERFACE, but the errors still exist in table GL_JI_ERROR_CODES. We have run the Purge Interface Tables pr…
-
Restrict User RateSummary: Is there a way to warn/restrict user if the User rate enter deviates from the threshold or by reference rate type by certain percentage? Content (please ensure …Jason-Citadel 2 views 1 comment 0 points Most recent by Sharada Beleramane-Oracle General Ledger & Intercompany
-
is possible to bring the DFF value to the auto-reversed journal from the source Journal in fusion GLIt is feasible to transfer the Descriptive Flexfield (DFF) value to the auto-reversed journal from the originating Journal in Fusion General Ledger. -
Why allocation formula don't get transferred during a clone?Summary: Why allocation formula don't get transferred during a clone? Content (please ensure you mask any confidential information): We cloned our PROD environment to ou…ramesh.sivapalan 3 views 2 comments 0 points Most recent by ramesh.sivapalan General Ledger & Intercompany