Category 337-2
Discussion List
-
Journal creator should not approve his/her own journalSummary: Journal approval created by user should not approve journal Content (required): Business requirement is to Journal creator should not approve his/her own journa…Kumar 57 81 views 5 comments 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
Changes or new journals not reflecting immediately in OTBI reportWe have OTBI GL drill down report built on General Ledger - Journals Real Time subject area. But any new journals are not reflecting in this report immediately. How we c…Narasimha Raju 21 views 4 comments 0 points Most recent by Narasimha Raju General Ledger & Intercompany -
What are all the impacted areas that we should promote a Legal Entity name change?Summary: Legal Entity name change in General Ledger enterprise configuration Content (please ensure you mask any confidential information): We have a requirement to chan…ramesh.sivapalan 155 views 1 comment 0 points Most recent by SauravS-Oracle General Ledger & Intercompany -
Alias tables in SmartviewSummary: How are these created / where are they coming from? Can additional Alias Tables be created? Content (required): In SmartView (Essbase) when switching between Al…Delaney Wastler 43 views 4 comments 0 points Most recent by Bala Murali SV General Ledger & Intercompany -
The primary and secondary ledgers share a common chart of accounts.The primary (UK GBP) and secondary ledger (UK local) share a common chart of accounts. i can't perform "Review and Submit Accounting Configuration" due to the reason: "Y…Yftach Paschur-Oracle 187 views 5 comments 0 points Most recent by User_WRB3Z General Ledger & Intercompany -
Hierarchy update and reuploadOur current process of adding a New Fund or Department is to download the current hierarchy in a spreadsheet, update it, and reupload it. Is there an additional way to a…Badripalli Archana-Oracle 31 views 5 comments 0 points Most recent by Badripalli Archana-Oracle General Ledger & Intercompany -
how to remove Create Subledger Journal from general accounting manager seeded roleSummary: We have requirement to remove 'Create Subledger Journal and Create Subledger Journals in Spreadsheet' from General Accounting Manager. Because we are using jour… -
General Ledger journal reportsSummary: As per below oracle link, we are supposed to have a seeded report called Journal Reports that allows us to run and view journals by selecting specific journal b… -
Chart of accounts mapping tables - can't find the table or column name for "condition"Summary: Need to know the table name and column name for the field "condition" in Manage Chart of Accounts Mapping form. I was able to build a sql query with all the col… -
SQL to find the link between Intercompany transaction in AR and AP ?Summary: SQL to find the link between Intercompany transaction in AR and AP ? Content (please ensure you mask any confidential information): Hello I have the following S…Cesar Saveedra 511 views 2 comments 0 points Most recent by Gabriela Patrascu-Oracle General Ledger & Intercompany -
getting duplicate seniority dates in OTBI report FusionSummary: Oracle Fusion OTBI report is there giving duplicate records for one of the employee. It showing two seniority date records out of it we need earliest seniority … -
Active and Inactive Users reportSummary: Hi Team, We are looking for and Oracle seeded report where the report contains the list of users who are currently active into the system and and inactive into …MihirS 355 views 1 comment 0 points Most recent by Razvan Paduraru-Oracle General Ledger & Intercompany -
Multiple currencies are visible in SmartviewSummary: On test instance, we see the currencies outside of USD and STAT are disabled under Manage Currencies and are also not listed in Manage Reporting Currencies and … -
privilege required to run Synchronize Transaction Workflow Status ESS jobSummary: Hi, Could you please suggest on what privilege is required to run Synchronize Transaction Workflow Status ess job Content (please ensure you mask any confidenti… -
Action Taken Table/Field under Manage Accounting ErrorsSummary: Hello Colleagues, Good day! With regards to Manage Accounting Errors, do we have a table/field that contains the Action taken? I tried to search all tables and …Ralph Aldrich Magno 72 views 4 comments 0 points Most recent by Ralph Aldrich Magno General Ledger & Intercompany -
Process to add GL Segments in OTBI which are not inbuildHi, I would like to add GL Segments in OTBI other than the below-mentioned Segment Labels. I have gone through some oracle documents which doesn't worked to me.…Varalakshmi 11 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany -
Auto reject manual journals for REHas anyone used journal entry rules to auto-reject manual journals that include a retained earnings account?Colleen Marie 31 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
Tree Version Start and End DateSummary: Purpose of Tree Version Start and End Date Content (please ensure you mask any confidential information): Can someone please help me to understand the purpose/o…ramesh.sivapalan 73 views 4 comments 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany -
How we can get Journal approver/assigned detail in OTBISummary: We do have a business requirement to create an OTBI report which provides below below-mentioned details. 1# Basic Journal header information (which we can get f…YogeshJain 95 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
How to connect to Oracle Cloud ERP in Smartview using HS Functions?Hi, We are trying to connect to Essbase cube of Oracle Cloud ERP via Smartview. Specifically, we are trying to use HS functions (Example: HSGet, HSset). But when we try …Guntuka VenkataKrishna 31 views 2 comments 0 points Most recent by Guntuka VenkataKrishna General Ledger & Intercompany -
account monitor how to make only a group of users view some accounts in account monitorSummary: how to make only a group of users view some accounts in monitor accounts Content (please ensure you mask any confidential information): Is it possible in Accoun… -
Is it possible to force GL Segment Values to always be the max length?Summary: We've found users are not required to enter the max number of characters when creating a new segment value in GL. We want to ensure all segment values are alway… -
How to apply restriction in custom job roles for users to access some particular LE's in Oracle ERPSummary: How to apply restriction in custom job roles for users to access some particular LE's in Oracle ERP Content (please ensure you mask any confidential information… -
Once Generic question on Unearned RevenueSummary: While doing the unearned invoice in AR requirement is Unearned revenue invoice (Foreign currency) is creating for 10 years but the invoice has to be consider th…Taraka Ram-Oracle 42 views 1 comment 0 points Most recent by Daniel S.-Oracle Receivables & Collections -
Restrict Ledger security with regard to certain COA valuesHello, We are looking for a way to restrict the use of one of our COA segments/values (Operating Unit) to just one of the 3 ledgers we have. Does anyone know a good way …Scott Dellabella 74 views 8 comments 0 points Most recent by Scott Dellabella General Ledger & Intercompany -
How to restrict User Access from Viewing the Attachments made for journals in GLSummary: Content (How to restrict specific User from Accessing or Viewing the Attachments made for journals in GL): Version (Oracle Fusion Applications): Code Snippet (a…Nalsoft Pvt Ltd 18 views 1 comment 0 points Most recent by Cezar M-Oracle General Ledger & Intercompany -
Segment Security Rules - Oracle FusionSummary: Hi Team, We have a requirement to create security rules to restrict certain account codes while processing AP invoices. As per that we have created a security r…Sesha Sailini 62 views 4 comments 0 points Most recent by Lakshmi Alagappan-Oracle General Ledger & Intercompany -
ability to secure Budget ScenariosSummary: Is it possible to secure a specific Budget Scenario? Content (please ensure you mask any confidential information): We have a budget scenario that is specific b… -
How to Revalue Balance every nth Workday/Business day of the Month?Is there a way to run the Revalue Balances ess job every 2nd Working day/Business Day of the month? There is no option in Scheduled Process to classify the day/date as a…Ilona Jean P. 31 views 2 comments 0 points Most recent by Ilona Jean P. General Ledger & Intercompany