General Ledger & Intercompany
Discussion List
-
How to update Chart of Account Segment Values and GL Account Hierarchy in bulk easily1. Update Chart of Account Value Set Values Sometimes there is a requirement to update COA value set values in bulk e.g. Value Description, Enable flag, Segment Value At…
-
Context Sensitive Segments Are Not Appearing For Lookup Values Descriptive FlexfieldHi, I have defined a common lookup code and would like to populate the DFF for lookup values. But, context is not showing at lookup line level. Do i need to run addition…
-
can we include other fields apart from POV dimensions in the SmartView report.Summary: inclusion of additional fields in Smartview reports apart from POV Dimensions like journal source and category in SAAS. Content (please ensure you mask any conf…
-
How to save number format in ATTRIBUTE columns in DFFHi, I have enabled DFF on lookup codes and lookup code tables do not have number format columns hence it's showing as ATTRIBUTE1, ATTRIBUTE2, etc in the list Table colum…
-
Why does revaluation take place when balance is zeroSummary: Revaluation takes place when balance is zero Content (required): I've read note - GLCRVL Revaluation is Taking Place Even When Balance is Zero (Doc ID 294991.1)…
-
How do the intercompany transaction approval works together with the FinFunEnterDistRequestForActionSummary: It is unclear from the documentation how the intercompany transaction approval workflow works together with the FinFunEnterDistRequestForAction workflow. Conten…
-
Is there a way we can use Static Amount instead of Period Activity ?We are trying to create Recurring journals using Calculation manager and as of now we are using Period activity on natural account. Is there a way we can use Static Amou…
-
How to set-up Recurring Journal in Oracle Cloud?How to select particular analysis code for the source and target Natural Account which will not violate the CVR Rule? In this case, Analysis code of source and target na…
-
Audit trail for data access setSummary: Hi all, i would like to ask is there any way to keep audit trail for Data Access assignment/Security context value Content (required): Version (include the vers…
-
How to default standard bip report output to excel?Summary: How to default standard bip report output to excel? Content (required): How to default standard bip report output to excel? Version (include the version you are…
-
Financial Reporting Studio - how to add the prompt selected information to the title of the reportHello, I'm building a new FRS report. The accounting period is selected at the prompt. I would like to have my report title to show the accounting period selected at the…
-
Is there a way to update 'Control Account' value on code combination level without using the 'InheriSummary: The page 'Manage Account Combinations' does not allow us to update 'Control Account' value, the field is read-only. Is there any possibility to update this fiel…
-
Manual Journal Reversal - How to post automatically or prevent users to editSummary: Context: This is only for cases of Manual Journal Reversal. Is there a way I can set it up that when I do manual reversal, the "Post" process goes automatically…
-
Taxable Journals in Oracle CloudSummary Taxable Journals in Oracle CloudContent We are looking to create Manual journals where tax is calculated. ( This functionality was available in EBS). Is the same…
-
can we merge two values in certain value set?Hello Oracle Customer Connect community, We recently implemented a new hierarchy for our departments, and we'd like to find a way to merge the old department values with…
-
Requirement to default Current Period in the FRS ReportCurrently Trial Balance Report in Financial Reporting center showing Oct 2022 as default accounting Period which is very old period and client expressed their concern to…
-
MISSING values IN FRCSummary: MISSING values do not work well in FRC reports. For example, I have a column that has to add two columns, however one of them has a value of MISSING and when …
-
Reporting Currencies with Conversion Level - JournalSummary: Content (required): Hi Experts, Here is the scenario: Primary Ledger: with Global COA, Global CAL, CLP (Chile Peso), IFRS accounting method Secondary Ledger: wi…
-
Related Valueset Values upload any API or WebserviceSummary: Is there any API or Web-service for Related Value-set Values upload Content (required): We are maintaining the Related Value-set Values. For automation/integrat…
-
Time Zone (UTC to EST) issues during BPM Journal Approvals.Summary: Requirement: 1. Any Journal recorded for the previous month till the 4th Business day of Current month will route to Manager Approval. 2. Any Journal entered on…
-
Is it feasible to use or enable future segment as Intercompany SegmentSummary: Hi Experts Current we have 8 Segment in Prod COA as below 1. Company 2.Line of Business 3. Activity 4. Location 5. Department 6. Natural Account 7.Future1 8. Fu…
-
Unable create DFF based on the GL Account Segment ValuesDear team, As per my client requirement we need to create DFF based on the GL Account Segment Values. If user select Specific GL Account Value, then system need to displ…
-
GL Approval Workflow Rule for Specific Set of Users?Summary: Is there a way to build a rule which is focused on a specific set of users so that if they input a GL journal it goes to the team's manager first to be approved…
-
How to upload Fixed Daily Rates in Oracle CloudSummary: Hi All, can anyone please guide me how we can get Daily Rates of Fixed Rate Type in Oracle Fusion? Content (required): I am navigating to Setup & Maintenance - …
-
Chart of accounts BI Object MappingSummary: We used the RI spread sheet to setup our COA structure and other items in our fusion sandbox instance. We want to use these in OTBI so I when I checked the BI o…
-
Auto Reversal of accrual journal entries to first day of next quarter?Requirement is to have auto reversal of the accrual journal entries to first day of next quarter. Not able to setup the same in Journal Reversal Criteria Set setup. Is t…
-
GL Allocations- creating new hierarchy trees for the accounts and departmentsSummary: GL Allocations- creating new hierarchy trees for the accounts and departments participating in the process Content (required): GL Allocations- creating new hier…
-
Revaluation calculation SQLSummary: I am looking for a piece of SQL that I can run to assist with revaluation troubleshooting. Content (required): I am looking for two pieces of SQL that I can run…
-
After Posting JV "Reconciliation Reference" is not updatableSummary: Hi Experts We have requirement to update the "Reconciliation Reference" after posting JV where we can insert reference number which we receive from bank in the …
-
Error when loading journals via spreadsheetSummary: Hi I am getting the following error when loading some journal in the ADFDI template : You're using an account that's either disabled for posting or a control ac…