OTBI
Discussion List
-
Need subject area for Bank return number to add column in OTBISummary: Hi Experts, I am looking for subject area for bank return number to add in OTBI report. Task: Payments—> Manage bank Returns —> search with invoice number— Retu…Mahindra reddy-Oracle 8 views 0 comments 0 points Started by Mahindra reddy-Oracle General Ledger & Intercompany -
Finding corresponding entity§ion of an intercompany transaction that hits an entity & sectionHow to find the originating entity and section number of a transation that ends up in another entity and section in the General Ledger. Currently our ERP COA has Entity,…
-
Impact on Application behavior if we change the FUTURE1 Segment of COA Structure to ZONESummary Impact on Application behavior if we change the FUTURE1 Segment of COA Structure to ZONEContent Hi All, Greetings. Customer is live on Cloud Applications, having…Subramanyam Tumarada-Oracle 113 views 8 comments 1 point Most recent by PratikL General Ledger & Intercompany
-
Data Not Visible in OTBI Dashboard for the userSummary: We have create a custom OTBI dashboard to show Item Information, Inventory Information , Purchasing Information, Sales order Information, Price List Information…Santosh Vaidya 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
Natural Account (SEGMENT2) Description on a custom reportSummary: Hello, We have built a custom report to compare the FA SLA balances to GL which contains an account column but which GL table do we use to include the account d… -
Is it possible to fetch ledger id in OTBI?Summary: Hi, I want to add a column that shows the Ledger ID in OTBI for reporting. I have checked in all the Subject areas as shown in the image below but I have not go…Gautam Buragohain 11 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Is there an ability of showing on the UI the date of the last time an account combination was used ?Hi Team, I was informed that on prem Oracle used to have the ability of showing on the UI the date of the last time an account combination was used, similarly is this po…Baskara Sateesh-Oracle 1 view 1 comment 0 points Most recent by Baskara Sateesh-Oracle General Ledger & Intercompany
-
Deeplink to Inquire on Detail BalancesSummary: We want to link from a BI Publisher and OTBI Report directly on the Inquire on Detail Balances Page with filled out parameters. It should be the same like it is…Yves Chassein 25 views 1 comment 0 points Most recent by Julien_Dubouis General Ledger & Intercompany -
Data Not Visible in OTBI Dashboard for the userSummary: We have created one custom OTBI dashboard. When we give access to the user, he can access the dashboard but data is blank. What roles are requried? Content (ple…Santosh Vaidya 12 views 3 comments 0 points Most recent by Santosh Vaidya General Ledger & Intercompany
-
How to get detail of Data Access Security Policies applied at role level using sql querySummary: I need to get details of Data Access Security Policies attached at role level. I am using below query to get detail, but it seems its returning data which is en…rahul.gupta.scm 26 views 4 comments 0 points Most recent by rahul.gupta.scm General Ledger & Intercompany -
24C New BIP report Journal and Transaction Details Report Unable to Select From & To Period ParameteSummary: 24C New BIP Report: Journal and Transaction Details Report: Unable to Select From & To Period Parameters Content (please ensure you mask any confidential inform…
-
BI Publisher - Object_version_number column in gl_je_headers tableDear All, After creating a journal manually, the object_version_number in gl_je_headers is set directly to the value 3. Can anyone tell me what the purpose of this colum…George Mattar 11 views 1 comment 0 points Most recent by Uddipta Bhaumik-Oracle General Ledger & Intercompany
-
OTBI report/Dashboard on User ,Roles, Sox ViolationSummary: Do we have any reports/dashboards on User, Roles and Sox (Sarbanes-Oxley Act compliance) violation available in Customer Connect or in Oracle Thanks in Advance …
-
GL Revaluation sources - report to show the invoices/payment (sub-ledger) transactionsSummary: Hello All, We have a requirement where business wants to verify the source transactions (AP invoices/payments) that are considered for the revaluation process d…Subhasish-OC 21 views 1 comment 0 points Most recent by Lakshmi Alagappan-Oracle General Ledger & Intercompany
-
Does anyone have the SQL tables that define the BPM Journal Approval Workflows?Summary: We're trying to track the setting within the Journal Approval Workflow that disallows the JE creator from being an approver to support SOX audit controls Conten…Patrick Bonahoom 73 views 5 comments 0 points Most recent by Patrick Bonahoom General Ledger & Intercompany -
Lineage document comparing PeopleSoft tables with Oracle Fusion tablesSummary: We need to migrate PeopleSoft Finance and HCM tables/fields to Oracle Fusion Financials and HCM. Could you please provide the lineage document comparing PeopleS…
-
How can I populate LEDGER_SUM columns similar to the standard General Ledger and Subled Account Rep?Does anyone know where we can take the values to populate or calculate these columns in a report? LEDGER_SUM_PR_DR LEDGER_SUM_PR_CR LEDGER_SUM_BAL_DR LEDGER_SUM_BAL_CR W…MARIA EUGENIA VICTORIA LOPEZ-Oracle 1 view 2 comments 0 points Most recent by MARIA EUGENIA VICTORIA LOPEZ-Oracle General Ledger & Intercompany
-
General Ledger Journal and Subledger Transaction Mapping ReportIt looks like Oracle has provided this report for China localization only, we have a similar requirement for US operations, is it possible to run this report for Non Chi… -
OTBI report for FND LOOKUPSSummary: I need to create an OTBI analysis for FND LOOKUPs. Through OTBI Lineage document I found there is a View object for fnd lookup. "FscmTopModelAM.AnalyticsService…
-
GL segments not visible in OTBISummary: Hi all, I have an issue where some GL segments aren´t visible in OTBI. I tracked down some issues for why it was not visible and followed this note: https://sup…Daniel Lundsteen Minke 333 views 2 comments 1 point Most recent by Julien_Dubouis General Ledger & Intercompany -
General ledger Schedule process is not visible to all usersDear All, I am writing to inform you that the scheduled process to extract general ledger data is currently not visible to all users. Anyone can give me the privilege to…George Mattar 11 views 3 comments 0 points Most recent by George Mattar General Ledger & Intercompany
-
Supplier: In which Table to find the "Use Witholding Tax" (Site Assignments) field at Site levelSummary: In which table can be found the "Use Witholding Tax" field at Site level (Site Assignment) Content (please ensure you mask any confidential information): Versio…Christian Flegler 1 view 2 comments 0 points Most recent by Christian Flegler General Ledger & Intercompany
-
Report of 'Corrected Import Journals Errors'?Summary: We're looking for a report that shows us all interfaced journals that have been manually 'corrected' - is there a seeded Scheduled Process or OTBI report in Ora… -
Default the accounting period parameter to adjusting period when running create income statement cloOur client is looking for an official response from SR Engineer, so please reply and do not tag it as CCC. Is there a standard functionality in the system to default the…Butch Melvin 2 views 1 comment 0 points Most recent by Lakshmi Alagappan-Oracle General Ledger & Intercompany
-
How to Extract Chart of Accounts Values and HierarchiesSummary How to Extract Chart of Accounts Values and HierarchiesContent Hi I would just like to inquire if there is a standard report (OTBI), program or an API that can e…JOHANN CHRISTIAN MORDENO 743 views 9 comments 4 points Most recent by Truptesh Solanki 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 23 views 4 comments 0 points Most recent by Narasimha Raju General Ledger & Intercompany
-
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 181 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 …
-
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 -
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 76 views 4 comments 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany