To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for ERP
Discussion List
-
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… -
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… -
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… -
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…
-
Which table store User category and Password expiration DateSummary Which table store User category and Password expiration DateContent Hi Guru's Please let me know Which table store User category and Password expiration Date und…
-
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…
-
OTBI Report with Payments Disbursements and Invoices with Invoice distributionSummary OTBI Report with Payments Disbursements and Invoices with Invoice distributionContent I am trying to create a report that shows only the invoice expense account … -
[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…
-
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… -
Cloud ERP Guided Path and Configuration Best PracticesSummary Provides a guided path of Oracle ERP Cloud resources (documentation) and best configuration practicesContent Guided Path: Highlight key Oracle resources/best pra…G.Brett Beaubouef, PMP, CISA, ERP Author 269 views 8 comments 10 points Most recent by Soumya Prakash Parhi -
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…
-
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]… -
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
-
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… -
ESS job and job sets migration from one instance to anotherSummary: We have around 200+ ESS jobs and each time after refresh, it is a tedious and time consuming task to migrate each of them individually. We have to document each… -
Review Budgetary Control BalancesReview Budgetary Control Balances Hello, please i need support to get THE VIEW OR TABLE that build Review Budgetary Control Balances and build a query as data model TO S…
-
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…
-
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…
-
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…
-
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
-
How to Import a signature and logo in UCM Server and Export a signature and logo in RTF TemplateSummary A requirement is to upload logo in UCM server and access that logo in RTF Template by using Payment Format(Check printing))Content A requirement is to upload log…