Category 129
Discussion List
-
Comprehensive SQL to Retrieve Contracts with Lines, Fulfillment, Deliverables, Risks & Attached DocSummary: This post shares a comprehensive SQL query that retrieves detailed Contract information from Oracle Fusion ERP Cloud, especially for ECM_BUY contracts. It conso… -
Regarding COA future1 segment name change impact on custom reportsSummary:Is there a specific option to find out what all custom reports are touching the chart of accounts Accounting Flexfield to analyze the impact of chart of account …Savita_1 24 views 1 comment 0 points Most recent by Anca A-Oracle Subledger Accounting & Accounting Hub -
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…
-
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 23 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…
-
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 9 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 9 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 …
-
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 262 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 16 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
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 76 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
-
Issue with exporting xls data from several reports for some usersSeveral of our users are facing the issue(see a screenshot below) when they try to extract XLS from several Financial reports (all of them for reports from the EPM works…Ann Djiyanova 15 views 1 comment 0 points Most recent by Viorel "Van" Andritoiu-Oracle EPM Platform and Freeform -
Table to view Project Expenses Mass Adjustment Reason and TypeSummary: Which table can I use to get the "Adjustment type" and "Adjustment Reason" for mass adjustments made against Project Expenses. I found the table PJC_TXN_MASS_AD… -
Bold Style is missing for Arabic text in PDF output of rtf templateSummary: We have a check template (.rtf) developed with Payment Date, Payee Name, Payment Amount and Payment Amount in Words . In these fields, Payee name and Payment Am…SireeshaJaladi 1.1K views 18 comments 1 point Most recent by Lohit Kad-Oracle Reporting and Analytics for ERP