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
-
Multitier Intercompany Transaction ApprovalFor multitier transaction the enable approval field is getting grayed out. Why is oracle not proving approval for multitier transactions? -
Need to create Approval depends on Journal Category and Journal Amount on same BPM RuleHi All, Please I tried to create a BPM Rule that says If Journal Category is "XXXXX", And Journal Debit Accounted Amount is "XXXXX" However, the Journal Category conditi…
-
SmartView on Mac for FusionSummary: Hi, We have a request to set up Smart View on a MacBook for use with Oracle Fusion ERP Cloud. We've been successfully using the Windows version of Smart View fo…
-
Can I add non-qualified custom Segment Label to existing COA Segment which is already in use?Summary: We have requirement to create OTBI Report to fetch data for a particular COA Segment. The segment is not visible in Subject Areas. We have already tested it in …
-
Not able to select Ledgers in the Create Opening Balance Journals in Reporting Currency or SecondarySummary: We are not able to select Ledgers in the Create Opening Balance Journals in Reporting Currency or Secondary Ledger Schedule process, which setup must be missing…
-
How INTRACOMPANY Transaction has been Created in Oracle Cloud GLSummary: We have a requirement to manually create an intracompany transaction in Oracle GL. According to the current enterprise structure, each ledger is associated with…
-
Can I create custom financial categories values for the chart of accounts segment?Summary: We are interested in creating some custom values for the Financial Category column on our account segment. Is it possible to customize this drop down list of va… -
Migrating foreign currency balancesSummary: Hello, We are migration balances from r12 to cloud. We have both functional and foreign currency balances in our extract. The issue is when we will load the for…
-
RESTAPI for audit reportSummary: We've Audit reports to identify/track the changes happened in the application. As part of MCA India audit, its required to keep a daily backup of audit reports.…
-
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…
-
Joining GL with subledger, description repeatingI have the below SQL query and it runs and amounts are as expected. My issue is that when looking at a project journal the line description is repeating and it's not dis…
-
How to create advanced rule in Workflow spreadsheet with condition 'Each' or 'None'?Summary: In BPM it was possible to use expressions like EACH and NONE in Advanced Mode. In the workflow spradsheets it is not present. At least it seems that way. How ca…
-
Impact Of Changing the Account Type of Natural Account segment value from Revenue to ExpenseSummary: In the current landscape of our client's environment, COA values and related information will flow from EDMCS to Fusion ERP. Now there is a requirement from Cli…
-
SQL query to retrieve the approval history dataSummary: I wanted to create an SQL query to retrieve the approval history data which is in Transaction Console for process name 'Journal Approval' Content (please ensure…
-
Overlaps with updating GL tables and BIP executionSummary: Overlaps with updating GL tables and BIP execution Content (please ensure you mask any confidential information): I am developing a BIP that outputs balances fr… -
Create a sequence for a specific Journal Source and CategorySummary: Hello, For our migration we have the requirement to create a specific journal source and category for the migrated entries of GL. The requirement also specifies…
-
Modifying the Revaluation criteria doesn't work even if the Journal is not posted and deletedUser ran revaluation based on a wrong criteria, But didn't post the journal and deleted it. After which he modified the criteria and rerun the process but the new criter… -
Segment Value Set Security Control for Ledger SetWe have enabled Segment Security control by ledger-wise and have also a ledger set. When we assign the ledger set to a user and they select a ledger from the LOV while m…
-
Recon Reference for Balancing Journal LinesSummary: When a Subledger Journal is unbalanced, Intercompany and Additional Intercompany Balancing rules create journal lines. How can i setup accounting so we can capt…
-
Documentation on ERP Audit OptionsSummary: Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Amica Mutual Insurance Compa…
-
How can I change segments in an existing chart of accounts structure?Summary: The Customer wants to changue the order of the. segments in the char of account structure, in this moment we already did the configuration but they have no made…
-
Delete journal interface by 'Purge Interface Tables', but import errors repord still thereSummary: Delete journal interface data by process'Purge Interface Tables', but import errors repord still there Content (please ensure you mask any confidential informat…
-
Excel Add-ins to export TB directly from Fusion applications to Excel directly.Summary: Excel Add-ins to export TB directly from Fusion applications to Excel directly. Content (please ensure you mask any confidential information): Business would to… -
Journal Approval_Grade LevelSummary: Journal Approval_Grade Level Content (please ensure you mask any confidential information): Journal Approval_Grade Level, Business is requesting us to implement…
-
How to fetch Timezone defined in Legal Entity Address through Groovy ScriptSummary: Need a way to fetch Timezone details from Legal Entity Address setup through Groovy Script Code. Please confirm if there is any function available to fetch thes…
-
How to prevent changing a segment value when an Alias is being used?Summary: We are trying to figure out a way, that an alias could be used to enter some (not all segments) of the GL Code combination (when entering transactions), and whe…
-
Cross Validation rules works differently when using the FBDI for import JournalsSummary: The Cross Validation rule configured in the environment is not correctly picked up / works differently when using the Journal Import FBDI The CVR rule is set-up…
-
DATE_CREATED_IN_GL field on the GL_INTERFACE tableHow does the DATE_CREATED_IN_GL field on the GL_INTERFACE table gets populated? As per the tables and views description: Oracle internal use only. Date journal import cr…
-
What's the best practice to limit revaluation journals cannot be modifiedHi team, We are a global company and APAC users request to have their revaluation journals cannot be updated after generation under audit requirements. We know that we c…
-
What roles are required to complete the IC transactionSummary: Provided Receiver and provider in IC transaction, Receiver is not available in Provider list, Not able to transfer the IC Transaction to payables. Is that true?…