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
-
General Ledger Journal Entry Database InquiryHi Oracle Experts, I have a question regarding the General Ledger Journal Entry report. Could you please clarify if the field JRNL_Effective_Date refers to the journal c… -
Fusion Consolidation_Challenges_need suggestionSummary: Fusion Consolidation_Challenges_need suggestion Content (please ensure you mask any confidential information): Business operates across the world and created 20… -
How to generate intercompany balancing lines with same accounting combination on debit and creditSummary: We have a scenario: End user creates a GL journal where debit and credit are not balance by BSV. In this case, intercompany balancing lines should not be genera…
-
Change in BU assignment to LedgerWe have a requirement from out client that they want to change the calendar of the ledger from Jan-Dec to Apr-Mar. They are currently have 15 BUs assigned to this ledger…
-
REST API to query reporting currency ledgersSummary: REST API to query reporting currency ledgers Content (please ensure you mask any confidential information): Hi, We have ledgers defined and then we have reporti…
-
Why are we getting special characters in GL journal line description when exported?Summary: We have identified that the below journal line description in Fusion prod has special characters appearing in the excel file when the journal lines are exported…
-
How to print previous period in smart view reportsHello All, I need to print the account value for current period and previous period. In FRS we have the relative period function that helps us print the pervious period.…
-
intercompany agreementSummary: Hello Experts, I would like to understand more about new feature Intercompany agreement, what are the limitations of it. has anyone tried using the same, please…
-
How to create intercompany approval rules using receivables transaction typeSummary: Unable to Find Receivables transaction Type in the "IF Condition" under FinFunTransactionApproval Rules Content (please ensure you mask any confidential informa…
-
ADFDI Journal Currency ConversionWe are seeing an issue when uploading Journals via Spreadsheets where the entered credits and debits do not match following a currency conversion to GBP. For example, we…
-
The accounting sequance is not working for sublegerSummary: After creating Accounting sequence fro GL and sub ledger and assign it to ledger for all sources and all categories i am facing this error on subleger journals …
-
n/a123
-
Setting up Secondary Ledger without COA MappingWe have several ledgers defined in different countries. All Primary ledgers have Corporate COA, Corporate Calendar, Corporate Accounting Method (US GAAP) and the local c…
-
FRS Report Accounting Period : Range & MatchOur FRS (FRWS) Report Income Statement Report has two Grids in it. Grid1 runs for the Accounting Period. Grid2 needs to always has to return the ending balances for DEC …
-
Is the expand all functionality in Financial Reporting Studio being removed in the future?Summary: We have setup the Expand all feature for our client as they wanted to see the entirety of the account rollups on the Balance Sheet and P&L statement in Financia…
-
Custom BI ReportsSummary: Content (please ensure you mask any confidential information): Hi Team, I am currently working on creating a custom BI query, and I have come across an issue. W…
-
Account Segment value missing in Enterprise Structure Setup ReportSummary: Content (please ensure you mask any confidential information): We created few new accounts segment values, but they are missing from the Enterprise Structure Se…
-
How to allow override full account in Expense Item from Spreadsheet?Summary: How to allow override full account in Expense Item from Spreadsheet? Content (please ensure you mask any confidential information): When i create Expense in Exp…
-
retained earning calculation during data migrationSummary: Hi We are moving from legacy to Oracle and want to maintain balances for the last 2 years in Oracle. Suppose YTD for retained earnings for Dec-23 is 1000.. The …
-
Is there an API to reject GL Journal batches?Is there an API to reject GL Journal batches?
-
General Ledger: DFF at Journal Line - GL_JE_LINES vs GL_CAPTURED_INFOSummary: Is there any reason to use GL_JE_LINES vs GL_CAPTURED_INFO at DFF at journal line level? Content (required): Or is it just ability to have 2 DFF structures and …
-
Combo graph (bar and line) values are showing inverted for Expense Account TypeThe actual data stored in the application is in negative because Expense Accounts normal balance are credit and credit has negative sign in the system. How can I configu…
-
Is it possible to control or consult transactions that have suffered an "override account "?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Moved: Cross Validation between Tax Classification and Project Expenditure TypeThis discussion has been moved. -
GL period cannot be opened with partition issueSummary: We have calendar with 13 periods and 2 adjustment period at year end. (I have added log file as well) Subledger periods are opened for AP and AR, however unable… -
Is there a technical note to communicate the JE_FROM_SLA_FLAG?Fusion GL_JE_HEADERS has JE_FROM_SLA_FLAG. This flag is know to be Y for JEs once they are picked up from Create accounting. Client uses FBDI to import large volumes of …
-
Job/Supervisory Hierarchy->skip lower levelFor example: A is the journal submitter . A reports to B, B reports to C and C reports to D B has approval limit of 0-250K C has approval limit upto 500k D has unlimited…
-
Is it mandatory to reverse the revaluation journals every month?Summary: Is it mandatory to reverse the revaluation journals every month? Content (please ensure you mask any confidential information): Version (include the version you…
-
Is it possible to configuring User Access to Specific Legal Entities in a Shared LedgerSummary: We currently have a single ledger and single BU containing 6 Legal Entities (LE), but we need to restrict access to certain entities based on user roles. Specif…
-
Are there any options available to pull the GST tax code/classification into the report?”Summary: In GL Custom Report, we require GST Tax Code and Classification information from the Payable Line level. Kindly advise on the feasibility. Content (please ensur…