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.
Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
General Ledger & Intercompany
Discussion List
-
Need oracle api for fxratesSummary: Need oracle api for fxrates to import fxrates into oracle erp from integration platform Content (please ensure you mask any confidential information): Version (… -
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_…
-
Ability to Select multiple dimension members in a single column/row in SmartView Ad-Hoc ReportingWhen creating a SmartView Ad-hoc report. When we choose members from a dimension right now, we are only able to push them across columns / down rows , but we want to pla…
-
Is there any API to validate the input value against a SaaS value setSummary: Looking for an API to validate the input value against SaaS value sets Content (please ensure you mask any confidential information): We are building an extensi…
-
where are segment member aliases stored in the oracle financials database?Summary: Where can I find the aliases for individual segment members in the oracle financials database tables? Content (please ensure you mask any confidential informati…
-
What is the impact of General Ledger Segment Security on OTBI reportsOracle document 2486655.1 refers to a document which state in Page 26 he operator "Is last descendant of" is not currently supported for Segment Security Conditions in O…
-
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… -
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…
-
Transaction tax should not be applicable based on Intercompany Transaction typeSummary: Transaction tax should not be applicable based on Intercompany Transaction type Content (required): There is a requirement where tax should not be applicable or…
-
Moved: Sweep cash management transactions accounting dateThis discussion has been moved. -
How to route the Intercompany Batch for APproval based on User who submitted the Intercompany BatchBusiness Requirement: Any Intercompany Batches submitted by "User A" should go to "User B" for approval. We have to create the above in the Provider Organization that if…
-
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… -
How can you limit transaction amounts to two decimal placesSummary: Client has a requirement to limit transaction amounts to two decimal places to avoid rounding issues Content (please ensure you mask any confidential informatio…
-
Can we create separate setup and maintenance for manage daily ratesCan we create separate setup and maintenance for manage daily rates -
Trying to retrieve number from AccountingPeriod to use in Formulas in Financial Reporting Web StudioSummary: We are facing a challenge where we need to calculate a specific value using the AccountingPeriod number. However, the AccountingPeriod in the GL cube is represe… -
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…
-
Can I delete or disable a currency conversion rate type created by a user?Summary: It is required to be able to disable a currency conversion rate type that the user created, so that only one in particular can be used in transactions carried o…
-
best way to retain cost centre account code hierarchy at the end of each financial year?What is the best way to retain a snapshot of the cost centre account code hierarchy at the end of each financial year? Would I be best to explore the option of versions …
-
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…
-
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…
-
Search/filter/report on transactions by company and cost centerSummary: Is there a way to search/filter/report on transactions by company and cost center which are two segments in the chart of accounts structure? Content (please ens…
-
How to remove "Post" action from General Accountant roleMy client has a requirement for journal creation. They have three people (GL preparer, GL reviewer, GL approver) with three different duties to process a manual journal.…
-
Moved: subledger entries not getting into the secondary ledgerThis discussion has been moved.
-
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… -
How to design a ledger for a head office with multiple overseas branchesSummary: Having problem with designing a ledger for a head office with multiple overseas branches Content (please ensure you mask any confidential information): We need …
-
BI report to extract GL Daily Rates table data for a range of corporate ratesSummary: Is there a report that can be schedules to export the GL Daily Rates table data out of Oracle Fusion? Content (please ensure you mask any confidential informati…
-
How to enter many-to-many intercompany transactionTypically, intercompany transactions involve one provider organization and multiple receiver organization within a single batch number. There have been discussions and r…
-
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 …
-
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…