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
-
Oracle base table to store journals created from rules or rule sets for a given accounting periodIs there any designated table storing rules or rule sets with relation to the journals. When it comes to constructing a way to track down journals created from specific … -
Create a FRS report with code combination rowsSummary: I need to create an FRS report, in rows, instead of account it should be the code combiantion and have to display the custom text value instead of the account/c… -
Multiple COA mapping from source to targetSummary: Hello, We have a situation where our primary ledger COA source is our Global COA and the secondary ledger is our statutory book that has its own COA. The primar…
-
Getting error when trying process Reverse multiple Journal Batches using REST ( Doc ID 2739516.1 )Summary: Getting error when trying to process Reverse multiple Journal Batches using REST ( Doc ID 2739516.1 ) Content (please ensure you mask any confidential informati… -
FSG to FRS reportHow can an FRS report be created using all of the logic from an FSG report? My goal is to create an FRS report in Fusion that is identical to the FSG report that is avai…
-
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…
-
Unable to create allocation rule between 2 balance cubesSummary: I am not able create allocation rule between 2 different balance cubes. Is it possible to select source from 1 balance cube and target from another balance cube…
-
can we read the data by placing cursor on the value for segments like as EBS unable to find the spacIn EBS we can place cursor the chart of Account segment values. in fusion we are unable to do so and also not able to find the space. attached the above screen capture t…
-
FBDI - importBulkData REST API to trigger multiple import jobs with different parametersSummary: We are using importBulkData operation of "/fscmRestApi/resources/11.13.18.05/erpintegrations" REST API (non OIC as middleware) to import journals data into orac…
-
How can I populate LEDGER_SUM columns similar to the standard General Ledger and Subled Account Rep?Does anyone know where we can take the values to populate or calculate these columns in a report? LEDGER_SUM_PR_DR LEDGER_SUM_PR_CR LEDGER_SUM_BAL_DR LEDGER_SUM_BAL_CR W…MARIA EUGENIA VICTORIA LOPEZ-Oracle 7 views 2 comments 0 points Most recent by MARIA EUGENIA VICTORIA LOPEZ-Oracle
-
Segregate access of Transfer to Payables / Receivables in IntercompanySummary: Hello. I don't want one user to be able to access both Tranfer to Payables and Transfer to Receivables in Intercompany. Is there any way or privilage to acheive…
-
How to active Primary to Secondary Ledger Mapping status?Summary: We created a new secondary Ledger but we are not able to activate its conversion status. How to enable it? Content (please ensure you mask any confidential info…
-
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:https://www.oracle.com/webfolder/technetwork/tutorials/tutorial/cloud/r1…
-
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…
-
Our business requirement is to have two different Avg rates and Period-end Rates for one ledgerOur business requirement is to have two different Avg rates and Period-end Rates for consolidation and FRS reporting. But in Oracle we have only one type of Avg and peri…
-
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…
-
Unable to create the new employee number under the Employee segment due to Child Values are ExhaustSummary: Unable to create the new employee number under the Employee segment due to Child Values are Exhausted Content (please ensure you mask any confidential informati…
-
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 …
-
Changing our FY to match CY, was creating new business units necessary?My company is considering changing our FY to match CY, for anyone who has gone through this, was creating new business units necessary? I reviewed existing threads on th…
-
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…
-
Healthcare LLP & Chart of Accounts StructureWe are a Healthcare LLP currently in the discovery process for an upcoming HCM (Oracle) project that will have impacts to our COA (Oracle ERP), and are looking to connec… -
FX Revaluation - Conversion from Transaction Currency (Non-USD) to Functional Currency (USD)Hi, It is required to achieve conversion from Transaction Currency (Non-USD) to Functional Currency (USD) In a third party tool (Non-Oracle system), for all those transa…
-
Report for Unused Natural AccountSummary: We would like to find list of unused natural accounts (if a account was not used for booking/journal entry in any entity for a certain period of time). Is there…
-
How can we solve the issue of only one parent value showing in member id selection in SmartviewHello Experts, We have noticed that when selecting the member ID in Smartview, only one parent value is shown on the "All Department" member ID, while the other parents …
-
Absortion companyHi gurus: We need to merge two companies into 1, and we would need to know if there is any process (automatic or manual workflow) in Oracle Fusion Cloud that allows us t…
-
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 …
-
Mix of STAT and normal currency journal batch is getting autoapprovedSummary: Mix of STAT and normal currency journal batch is getting autoapproved. Our expectation is that, journal batch or journal should get autoapproved only if it has …
-
journalentries callback serviceSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…