Category 129
Discussion List
-
OTBI report timed out for specific Period onward even data count is similarWe are facing issue with a OTBI report that's part of a dashboard. The user runs the report exclusively through this dashboard. It has been working fine since last one y…Abhishek_Kumar_DTV 8 views 0 comments 0 points Started by Abhishek_Kumar_DTV Reporting and Analytics for ERP -
Trying to add new custom font in BIP getting errorSummary: I am Trying to add new custom font in BIP getting below error. Path : Admisnstartion→Runtime Configuration→Font Mapping When i click on Font mapping then gettin…Basavaraj Navalagi 77 views 6 comments 1 point Most recent by Bhaskar Konar Reporting and Analytics for ERP -
How to viiew Package - gl_flexfields_pkg.get_description_sqlHi, I was able to fetch the description based on the package /* select gl_flexfields_pkg.get_description_sql(23,23,7) from dual*/. However; I would like to see the entir…
-
Need table name storing reporting period and status after "Finalize Transactions for Tax".We need to retrieve the final reporting status and reporting period in Oracle Fusion tables after running the "Finalize Transactions for Tax Reporting" ESS job. This ESS…Sanender SP 44 views 7 comments 0 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP
-
segregation of dutiesIs there a report for segregation of duties for Finance?
-
Data Security not being applied to OTBIWe have a report created using the Subject Area- Expenses - Expense Transactions Real Time. As per Oracle documentation, this subject area access requires, Expense Trans…
-
difference balances xla_ae_lines and xla_ac_balancesSummary: difference balances xla_ae_lines and xla_ac_balances Content (please ensure you mask any confidential information): We created an OTBI report in the "Subledger …Francesca1 10 views 1 comment 0 points Most recent by Daniel Martin Subledger Accounting & Accounting Hub
-
Assistance Required: Identifying Primary Keys and Table Relationships in Oracle ERP BackendHi Team, We require information on the primary keys and relationships between Oracle ERP backend tables. We are currently retrieving primary key details from the "FND_PR… -
Is there any base table for privilege master along with table to map privilege table with roles?Summary: Hello experts, We are trying to create a BIP query to map the user to role and role to privilege. Previously we were using the "ASE" tables for this purpose, bu…
-
R13.x FSCM BI Cloud Adapter BI View Object to Database Lineage Mapping SpreadsheetSummary This posting includes R13 FSCM BI Cloud Adapter BI view object to database lineage mapping. Content This spreadsheet is published by Oracle BI Cloud Adapter Deve…Rashmi M-Oracle 54K views 137 comments 30 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
What is the default size of calculated columns in BICC extracts, and is any documentation available?While generating metadata using BICC R13.x FSCM BI Cloud Adapter BI View Object to Database Lineage Mapping Spreadsheet (Rel13_25C_BICC_FSCM_Database_Mapping_with_ViewOb…
-
proxy bidding functionality in auction negotiations, proxy decrement as a percentageSummary: We are using the proxy bidding functionality in auction negotiations, but the system only allows us to specify a fixed amount for the proxy decrement. However, …
-
Can't inquire into Invoices in the system using Action Link in OTBISummary: Hi. I'm trying to create OTBI Report that will show outstanding Invoices (Unpaid after Due Date is already Due). I'd like to add Action Link, so user will be ab…Yftach Paschur-Oracle 7 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
Find employee job application source in fusion hcmSummary: Find employee job application source in fusion hcm Content (please ensure you mask any confidential information): Our requirement is to get employee job applica…SUDIPTA KODALI 2 views 1 comment 0 points Most recent by Sunder.Velagala-Oracle Recruiting, Opportunity Marketplace
-
convert period to a number and use in formulaI need to convert the period to a number (e.g. Oct = 1, Nov = 2, etc…) and then use that number in a formula to divide one of the amounts by that number. I was able to c… -
Redwood Time Card Change History Errors "We couldn't find any audited data for this time card"Summary: Log in as user to HCM Me > Existing Time Card or My Client Groups > Time Management Search for and Modify an existing time card Change the hours, select a chang…
-
OTBI Analysis: How to format Person Number as 6 digits with leading zeros?Summary: Hi experts, I have a business need that requires me to extract data from an OTBI analysis and format all Person Numbers as 6 digits with leading zeros when need…
-
Replace SQL Server Reporting DB with Paas DBWe currently have a daily extract (GL to subledger drill down) that gets loaded into a SQL Server DB and the business interrogate via an Excel SQL Server add in. We are …
-
A SQL query of privileged resources in the role FSD sectionSummary: Hi All, Can anyone share a SQL query on how to retrieve privileged resources? inside the role of the FSD section oracle provides information about the privilege…Eliran Hadad 31 views 6 comments 0 points Most recent by Eliran Hadad Reporting and Analytics for ERP
-
Budgetary Control Balances OTBI with Deep Link Sample ReportSummary: Content (required): The Budget Balances OTBI with Deep Link Sample Report Kit contains a sample report embedded with a deep link to Review Budgetary Control Tra…Anne Wong -Oracle 1.1K views 15 comments 5 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP -
[FTPProcessor]Delivery to SFTP completed with failure oracle.xdo.delivery.ssh2.SshException: TimeoutSummary: [FTPProcessor]Delivery to SFTP completed with failure oracle.xdo.delivery.ssh2.SshException: Timeout waiting for response from server. Content (please ensure yo…
-
How to get PVO path for custom (Non-Seeded) object?Summary: Unable to find out the the non seeded path for the custom object PVO. Content (please ensure you mask any confidential information): We created a new custom obj…Shiva Kumar Bandaru 225 views 9 comments 0 points Most recent by Shiva Kumar Bandaru Order Management
-
Tracking bounced back emails Print Receivables TransactionsAR invoices need to be delivered through email to customer email ID. Is there any tracking mechanism to monitor the bounce back? So that, a valid email address can be ob… -
Does Oracle Fusion Cloud have any standard report/Localization for FTA VAT Audit File, (FAF)Hi Experts, The United Arab Emirates tax authority, Federal Tax Authority (FTA), audits businesses at its discretion to ensure accurate and timely tax declarations. As p…
-
Geeting issue "business unit is out of report range" in Payable to Ledger Reconciliation reportSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Range Function in Accounting Period is not working when adding another columnHello, I'm creating Trial Balance in FRS, and i need to use the range function in accounting period dimension, However, when I only have one column its working fine but …Mohammad Hussein 12 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
BPM Approval Group tables to fetch the approval informationWe are trying to fetch the approval group for which an approval task is triggered. We are able to fetch the approver name and task details in the table - FA_FUSION_SOAIN…Anishka Agarwal 13 views 1 comment 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management
-
Query to get composite key - learnerLearningRecordsUniqIDSummary: How do i retrieve the learnerLearningRecordsUniqID to get the information of the learnerLearningrecords information. {{baseurl}}/hcmRestApi/resources/11.13.18.0…
-
Smartview Essbase Error [1020098]: Duplicate name found in Grid, unable to resolve.Summary: I get the following Smartview error in report that used to work fine, adjusting the Account dimension values fails to resolve the issue, Essbase Error [1020098]…RichardChan 45 views 2 comments 0 points Most recent by Jeelan Banglewale-Oracle Reporting and Analytics for ERP -
Number format in oracle reportHello, when in a report we have #missingData, if i export the report in excel, we have 0 but not in number format. How can fix this, to have always number format? Thanks