Category 129
Discussion List
-
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 244 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 11 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 57 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 12 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
-
Verification of User Login Status in ERP CloudSummary: I would like to know if there is a report in ERP Cloud that shows which users logged in and when. Content (please ensure you mask any confidential information):…
-
OTBI costing receipt accounting subject area -- project number is not populating for transfer ordersI have created an analysis in OTBI using the costing receipt accounting real time subject area. The report is working fine, balances to the general ledger and reflects a…Walter L Gess 1 view 1 comment 0 points Most recent by Walter L Gess Reporting and Analytics for ERP
-
which tables store information about data access set for user?I need to a query to read for each user which BU have access to
-
No data shown for Time and labor under audit reportsSummary: We are trying to setup audit trail for Time and Labor and have enabled it but when we go to audit reports and select all the necessary parameters, still there i…
-
How to creat data set with standard SQL link to PLSQLI need to build a BIP report using RTF as layout The report has header and detail level To generate XML with header / detail , I need to write header and detail SQL in t…
-
Use of custom objects created using application composer for building BIP reportsSummary: We have built couple of reports referencing custom objects created using application composer. We wanted to check if Oracle has any plans in near future to depr…Jepson Erattuparmbil 1 view 0 comments 0 points Started by Jepson Erattuparmbil Reporting and Analytics for ERP
-
Trigger email notification when approver has requested more information on a requisition.Hi All, I'm trying to implement a change where an email notification should be triggered when an approver has requested more information on a requisition. I'm editing ex…Evanshi Vasani 79 views 1 comment 0 points Most recent by Alex Tuteur-Oracle Self Service Procurement
-
Hi, It is possible to send Attachment from AR Invoice Level Using BI Bursting Report from AttachmentHi, It is possible to send Attachment from AR Invoice Level Using BI Bursting Report from Attachment
-
Is it possible to make import output with capitalize letter even original data stored as uppercaseIs it possible that original data is all uppercase but transfer to captalize letter in output report? for example， JIM CHUNG, but in expected output, need to be Jim Chu…
-
Required Tables and column to store the Currency setting details under Manage Financial Plan typesSummary: Hi Team, What are the Tables and columns that store the Currency setting details under Manage Financial Plan types - functionality "Use same conversion attribut…
-
Seeking Innovative Solutions for Stale Dated Check Letter Report in Oracle Fusion ERP CloudSummary: Hi Team, We're developing a report to identify stale dated checks, specifically those exceeding 180 days from their issue date. Our goal is to automate the dail…Abhilash K - Deloitte USI 1 view 2 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
I am unable to join between Project types and class category for the task project typesSummary: Hi Team, Could you please help us to get class category under the classification associated with project types in oracle PPM Module Task Name: Manage Project Ty…