To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
General Ledger & Intercompany
Discussion List
-
Can you create a journal entry with a parent segment valueSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
GL Clearing Account reconciliationSummary: Can anyone clarify what data autoreconciliation of GL Clearing Account is reconciling to? It is not sub-ledgers or Banks. It looks to me like it is just an open…
-
Mass Update Account HierarchyIs there a method for mass updating General Ledger hierarchies? Currently, we are required to manually execute changes within the 'Manage Account Hierarchies' task. Alth…
-
How to apply restriction in custom job roles for users to access some particular LE's in Oracle ERPSummary: How to apply restriction in custom job roles for users to access some particular LE's in Oracle ERP Content (please ensure you mask any confidential information…
-
Allocation journal description other than the default oneSummary: Need to append accounting period to the journal description generated through allocation rules. Is there any option to customize journal description other than …
-
Has anyone been able to open a future period, close it and return statues to Future Enterable?Summary: We had 13 periods as Future Enterable, We opened the Periods to Post Allocated Overhead that is expensed at the budgeted amount. We then closed the periods and …
-
SQL to find the link between Intercompany transaction in AR and AP ?Summary: SQL to find the link between Intercompany transaction in AR and AP ? Content (please ensure you mask any confidential information): Hello I have the following S…
-
Best Practise for Disabling certain COA Value Set Values and use another existing VSV in its placeSummary: We are looking to understand the impact of Disabling certain Value Set Values (Locations) and use another existing Value Set Value in its place. No change to th…
-
Cross Validation Rules ReportSummary: Is it possible to get the cross validation rules in a BI Report? Can you please share the query. Thanks and Regards Content (please ensure you mask any confiden…
-
COA for Fuel / EV ChargingIs anyone have recommended COA for Fuel station/ EV Charging station entities? Thanks
-
GL Retained Earnings Balance Update incorrect amountSummary: We noticed that one of the retain earnings account with one of the entered currency has a negative ending balance and the ledger currency has a positive balance…
-
Currency Code - Extended PrecisionSummary: Currently ‘USD’ currency code is configured with Precision as 2 and Extended Precision as 5. We’re planning to revise Extended Precision as 4. Let us know what …
-
24A Spreadsheet JE's - Errors when Blank lines contained within the JESummary: Testing the 24A update, our GL processors are unable to submit Spreadsheet JE's using the new Oracle JE template Content (please ensure you mask any confidentia…
-
How to display if amount is Zero then need to be displayed zero valueSummary: How to display if amount is #ZERO then need to be displayed zero value. Content (please ensure you mask any confidential information): I need to make 'IF(K6=0,0…
-
How to add between condition in SRC (Spreadsheet approval template)Summary: Hi Team, We have a requirement in Journal Approvals saying that if Journal Line.Account Segment 2 value is in between 222 and 777 then it should get autorejecte…
-
Single Business unit for Multiple Legal entities which are having a separate Inventory OrganizationSummary: Hi Team, Can we implement single Business unit structure where it can be used by multiple legal entities for the transactions. In this the Legal entities are ha…
-
How to upload DFF values in bulkHi, I have created a DFF name "Supplier name" at journal lines level, Validation type=independent, Display type: List of values I want to add values in that DFF means su…
-
sql query to find link between Intercompany Accounting and GLI want to know the tables and link between intercompany accounting and general ledger. I want to pick intercompany data in query. -
Client needs to confirm that how accounting date for a journal is handled in fusion.Summary: Their requirement is that any direct posting to GL, the accounting date should be the accounting date that is indicated in the data entry, spreadsheet, or in th…
-
what roles are required for ERP use to load chart of account values and hierarchy from EDMCS to ERPSummary: Hi Team, As per EDMCS Setup, we have shared user details for EDMCS to establish connectivity with ERP Financials, so the standard capability of EDMCS can be use…
-
India localizationSummary: Hello, my company is using the Primary Ledger for global reporting, hence we have Jan-Dec calendar setup in the PL. We need to implement Oracle fusion in India.…
-
How to create advanced rule in SRC with condition 'Each' or 'None'Summary: Hi Team, we understand that the SRC template creates the approval rules in advanced mode by default. When we export the workflow rules report we notice that by …
-
Revaluation of previous day Daily GL BalancesSummary: In Fusion Cloud GL, client wants to revalue daily foreign currency balances. The Revalue Balances process is submitted in Fusion Cloud GL on a daily basis at en…
-
how to delete primary ledger which is just created by mistakenly in productionSummary: By mistake I have created Legal Entity and Primary ledger only those 2 steps in production. How can I delete both of them and the DOC no. shared is not opening …
-
Creating BPM workflow rule for GL - Condition Browser/Expression Builder lookup valuesSummary: I was wondering if anyone had any specific information about the names of the BPM task configuration workflow Condition Browser/Expression Builder lookup list v…
-
Segment Report with Creation DateHello Oracle Experts, Is there any seeded available report that would list out specific segment with the creation date? I tried looking into the subject area for OTBI bu…
-
Rest or Soap API to enabled or disabled GL code combinationsDear , We need API to enabled or disabled GL Code Combinations Means through api we can enabled or disabled GL code combinations is there any API for that Thanks -
Do we need separate License for BICC ? Is there any additional cost associated with it ?Hi Team, We are planning to use BICC for bulk data extraction purpose. Could you please confirm if we need separate License for BICC ? Is there any additional cost assoc…
-
Some Prepayment transaction not transfer of Journals from Primary Ledger to Secondary LedgerSummary: Some Prepayment transaction not transfer of Journals from Primary Ledger to Secondary Ledger Content (please ensure you mask any confidential information): We c…
-
Create Budgets in Spreadsheet and Correct Budget Import Errors in Quick ActionsI have been asked if it's possible to add "Create Budgets in Spreadsheet" and "Correct Budget Import Errors" to the General Accounting 'Quick Actions' area to make it mo…