General Ledger
Discussion List
-
Unable to fetch GL Budget Balances from GL_BALANCES table even though the documentation states itNeed to develop an Oracle BIP report to include the three types of GL Balances (Actual, Budget, Encumbrance). Although Actual Balances are available in GL_BALANCES table… -
Can we send email of Create accounting Execution report details in PDF format o/p as scheduled dailySummary: Can we send email of Create accounting Execution report details in PDF format output as scheduled daily We would like to schedule create accounting report and g…Niki 215 views 9 comments 1 point Most recent by Gergana Radoutcheva-Oracle General Ledger & Intercompany -
Recording payment deductions through intercompany transactionsSummary: BU1 has made a payment of 1200 to the supplier Google using its own credit card, but this payment was actually on behalf of its related company, BU2. Meanwhile,…Supriya devi 3 views 0 comments 0 points Started by Supriya devi Payables, Payments & Cash Management -
Is it mandatory to disable the U.S. Federal Financials option for journal import through ADFDiSummary: The U.S Federal Financials offering is enabled. The journal import through ADFDi are however failing due to EG01 pre validation error. The ledger and CoA used f…Kavita Shah 61 views 4 comments 0 points Most recent by Narottam Singh Chauhan General Ledger & Intercompany -
How to create journal approval using DFF and use the same in approval spreadsheetSummary:We are in the process of setting up journal approval using Descriptive Flexfields (DFF). We have created a DFF and assigned a value set to it. However, when crea… -
Costing Period Open / Close from General Ledger Period areaIs it possible to open or close "Costing" periods from general ledger period closing area -
Can we enter segment value range in Cross validation Combination setSummary: Want to know is it possible to enter segment value range in cross validation combination set and what is the maximum row counts that can be entered for combinat…Khalida Raffath 1 view 2 comments 0 points Most recent by Khalida Raffath General Ledger & Intercompany -
Requirement for New COA and Legal Entity Mapping to Existing Calendar and LedgerHi Team, We have a requirement to create a new Chart of Accounts (COA) and new Legal Entity, maping and using an existing Accounting Calendar and existing Ledger. Kindly…Prasanna002 12 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
Account hierarchy with Parent4, Parent1 and Child Value (Parent2 and Parent3 being blank)Hi Community, I need expert help on hierarchy. Summary: Right now we have account hierarchy for revenue and expense accounts. Parent4, Parent3, Parent2, Parent1 and Chil…Jakee_Agarwal-Oracle 12 views 2 comments 0 points Most recent by Jakee_Agarwal-Oracle General Ledger & Intercompany -
Legal Entity Rename and ImpactSummary: Currently, We have a legal entity 'ABC LTD' associated with Ledger and Employee master in HCM. We wanted to define new ledgers with new COA to move away from cu…Praveen T 148 views 1 comment 0 points Most recent by Jeremy Miller-Oracle Payroll and Global Payroll Interface (GPI) -
revaluation jobsetHi team, We have configured a job set to run Revaluation process for different revaluation templates by following the steps mentioned in attachment of below oracle docum… -
Delete Translation balancesSummary Delete translation balancesContent Hi All - I have ran the delete the translation balances for period and ran the refresh balance cubes as per the process to cha…User_2025-02-04-22-23-29-164 76 views 3 comments 0 points Most recent by Altaf A Shaikh General Ledger & Intercompany -
Is there anything automated for currency upload besides Manage Daily rate?Summary: Automate currency upload instead of only integrated excel workbook. Maybe web service? Content (please ensure you mask any confidential information): Client alr…Patrick.Coffey-Oracle 2 views 2 comments 0 points Most recent by Patrick.Coffey-Oracle General Ledger & Intercompany -
Report and analytics icon is not visible on GL, EXPENSES, CASH MANAGEMENTWe want to know if it is possible to see the icon "report and analytics" displayed on the Invoice screen under Payables, On GL, EXP, and CM modules. Please let us know i…Juan Carlos Bobadilla-AA 41 views 1 comment 0 points Most recent by MiaM-Oracle Reporting and Analytics for ERP -
Steps to Rename Secondary LedgerWe have renamed the Secondary Ledger in the Specify Ledger Options as per the below KB article. And ran the 'Create Ledger Dimension Members' job. Is there anything else…Swapnil_Mangnalikar 25 views 3 comments 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
In Specify ledger options, does the "sequencing by" option control the journal accounting sequence?Summary: We don't want document sequencing for Payables and Receivables. However, we need to have accounting sequencing for GL journals. Are the controls for GL and AP/A…Shannon Tse 9 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
Data Access Set not displaying tree code for parent valueSummary: We have a requirement to create a data access set by primary balancing segment parent value. After selecting the option parent value, the tree code is null but …Suzette Dixon 26 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
Journal Approval Rule is not getting triggered for the condition based on Category and Acct SegSummary: Journal Approval Rule is not getting triggered for the following conditions: If Conditions Journal Category.Journal Category Name is "AXXX Departmental" and Jou… -
I need to input a GL journal amount with 20 characters does profile GL_JE_LINES_MAX_LENGTH existSummary: I need to input a GL journal amount with 20 characters does profile GL_JE_LINES_MAX_LENGTH exist in Fusion? Content (please ensure you mask any confidential inf… -
ADFDI Plug-In doesn't workOnce the user enters in "Reconcile Clearing Accounts Manually" and tries to donwloand the spreadsheet to do it by Excel, the template downloaded is empty as I show you i… -
Setting up Document SequencesI would like to inquire about document sequences in General Ledger Configuration. Could you please let me know whether document sequences are reset annually at the start…kyoka.ando-Oracle 11 views 1 comment 0 points Most recent by Chandra Sekhar Kadali-Oracle General Ledger & Intercompany -
Hierarchy for Legal entitiesSummary Hierarchy for Legal entitiesContent Hi Have a couple of questions on Legal entity creation in Fusion 1.We have a requirement where we want to define a tree for l… -
The Impact of Increasing Value Set Maximum Length Assigned to Segment in Deployed COAWe’ve created a chart of accounts containing a segment for projects and these segment is being linked to a value set with a maximum length of 11 digits. The chart has be… -
Assign alternate account manage Accounting errorsLot of transactions have errored in Manage Accounting Error Screen. Could you please let me know if we are able to correct the account in that screen and push the transa… -
How to refresh data in GL_FRC_REPORTS_BWe have requirement to fetch all the report details from given instance. Table Name : GL_FRC_REPORTS_B ( this table doesn't contain the updated data) What are the steps … -
Manage Journal approval rules base on converted maximum journal line amountSummary: We have a lot of ledgers with different primary currency. But as we are a global company and center is in NA, so our users are requesting to define journal appr… -
Cross validation rule with 'decendant of' and hierarchy with range not workingWe have a Cross-Validation Rule with a '(last) descendant of' operator + a hierarchy with ranges- for the child values. All of this is seeded functionality, however the …Berwout J.R. Toonen 23 views 2 comments 0 points Most recent by Berwout J.R. Toonen General Ledger & Intercompany -
missing journal in currency report in oracle fusionSummary: We created our foreign currency reporting book after there were already entries created in the primary book, and these do not exist today in the reporting book.… -
Post Cloning Task ListSummary What are all the tasks that need to be complete after a PROD to DEV Cloning?Content Hello Gurus! We are all quite familiar with environment refreshes and cloning…Félix B. 643 views 8 comments 6 points Most recent by FaizulNazrilDzulkifli General Ledger & Intercompany -
How to Find Table with Approver Details for General Ledger Lines.Summary I am trying to create a audit report for GL entries however i need to retrieve the journal approver details. Please advise which table would have this informatio…Dave Sherrard 533 views 9 comments 1 point Most recent by Deepak Kumar Dev-Oracle General Ledger & Intercompany