Category 337-2
Discussion List
-
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 477 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 313 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 65 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 12 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 86 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 43 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 14 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. 32 views 2 comments 0 points Most recent by Ilona Jean P. General Ledger & Intercompany
-
Segment related PVOs not visible in BICCSummary: There are segments created in Fusion (GL#) and all the required jobs to extend the OTBI are executed. However after the execution it is visible in OTBI for repo…Vedasubramanian Muthuswamy 42 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
When trying to approve multiple invoices in BPM, error appears and approval does not happen.Summary: When trying to approve multiple invoices in BPM at the same time, comment box appears, after entering the comment an error appears and approval does not happen.…Christina O 12 views 1 comment 0 points Most recent by Antima Rai-Oracle General Ledger & Intercompany
-
Chart of Account Deployment ErrorSummary: Retained Earning Field is disabled in 'Specify ledger Options' setup. As per Doc ID 2258914.1, this is due to chart of accounts having being deployed to the san…Neha Barnawal1 390 views 3 comments 0 points Most recent by Cezar M-Oracle General Ledger & Intercompany
-
Create extensible flexfields for journal.Hello, I have to create extensible flexfields for sales tax journal. Is is possible because I can only see DFF for sales tax journal. Please help.
-
Is there a way to bulk enabling DFFs instead of one by oneSummary:We have many DFF that will need to enable for BI. Looking for a faster way to enable all at once instead of doing it one by one. Content (please ensure you mask …
-
Account Inquiry screen similar to EBSSummary: Account Inquiry screen similar to EBS Content (please ensure you mask any confidential information): User checking account inquiry in EBS system and they need s…
-
Restricting the data access to Journal source onlyHi Team, We need to provide access to a user for "Manage Journal Sources", can we have any limited access role available for this ? or do we have any possibility to crea…Bhanuchander Pulipati 41 views 3 comments 0 points Most recent by Bhanuchander Pulipati General Ledger & Intercompany