Reports
Discussion List
-
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… -
Need Table Storing Bank's "Active" Flag from Personal payment Methods ScreenHello, I'm trying to locate the backend table that stores the "Active" flag status displayed on the Personal Payment Methods > Bank Information screen in Oracle HCM (Sel…Jahnvee Sharma 31 views 1 comment 0 points Most recent by Carl Bequilla-Oracle Reporting and Analytics for HCM -
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 1 view 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
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…
-
In which table does the Candidate Job Application Fields are storedSummary: Hi Everyone I have loaded the Candidate Job Application into the system using HDL. So I'm trying to fetch those loaded fields using SQL for verification. Conten…Sujeeth Chinta 703 views 4 comments 0 points Most recent by Emerson Oliveira Reporting and Analytics for HCM
-
Data Extract from EPBCSOracle Team: I know that we have the ability to create visibility into Oracle Fusion ERP by creating data models to extract data from the base tables in Oracle Fusion ER… -
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…
-
Labels placement on Bar chart in narrative reportingHi, We are looking for labels outside the bar chart as the width of the graph is less, numbers are not showing on the graph due to small value of the data. e.g. In image… -
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 …User_2025-02-06-00-15-19-515 759 views 3 comments 0 points Most recent by J Dimond Reporting and Analytics for ERP -
BI Report access issueSummary: Hi, One of the users is unable to access the BI report. When he tries to access it, he getting the error shown below. But, he is able to access the report from …DHILNA P 1 view 2 comments 0 points Most recent by Yves_Guyon-Oracle Reporting and Analytics for HCM -
OTBI output is different for 2 different usersSummary: Hi, We have a custom OTBI report which is scheduled to send report to the Business Users. This report shows that 100 employees have missing family contact infor…Sailajad 21 views 8 comments 0 points Most recent by Yves_Guyon-Oracle Reporting and Analytics for HCM -
Issue: Unable to expand Calculation Components Detail folder in Payroll - Calculation Cards Real TimSummary Users building reports on Calculation Cards Subject Area when try to expand Calculation Components Detail folder, the folder doesn't expand. Solution is provided…Tanvi Jain-Oracle 142 views 1 comment 2 points Most recent by Al Darabaris Reporting and Analytics for HCM -
View Reports and AnalysisSummary: View Reporting and Analysis on the Cloud Help Center Content (please ensure you mask any confidential information): There used to be a link for Reporting and An…AVorster-Oracle 21 views 4 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
Qualified Member Name from Reports output cannot be recognized when perform ad hoc analysisSummary: We move Financial Report to Reports then the output for member qualified name display only with dot and without bracket. This display cause error when perform a… -
[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… -
Add Business Unit as an additional parameter in the Run Gross-to-Net ReportWe have a requirement to include Business Unit as an additional parameter in the Run Gross-to-Net Report (Gross to Net Summary Archive) so that the report can be generat… -
Report to say if employee has any direct reportsContent Hi, have a simple report that says something like PERSON NUMBER | Name | Department. I need to add an additional column that returns yes/no for if that employee …Mike Borghoff 129 views 7 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
How to create custom report for future lease schedules using FLA_ON_DEMAND_SCHEDULES_PKGHi Experts, The future lease schedules data are being deleted from Fusion Tables when attaching the lease detail report and finalizing the lease. Document 2819925.1 Howe… -
Email Address FormulaHi Everyone, I am building a report for one of our HR partners. She is using the report as a file loader to put employee data in an external employee recognition platfor… -
Facing " There is no data to process" in BIP reportSummary: Facing the error " [INSTANCE_ID=bip.bi_server2] oracle.xdo.servlet.scheduler.ProcessingException: There is no data to process" in BIP report and there is bursti… -
Combining two Smartlist Accounts into One AccountHello, I am trying to combine two text Accounts(one Smartlist, one open text) into One Account. I have tried doing it in the Member Formula of that Account in Dimensions… -
How to to enable the selection of POV members when running report package?Summary: I am currently developing a report package in Narrative Reporting and need assistance regarding the configuration of the Point of View (POV). I have dimensions … -
The shared connection cannot open the reportsHello everyone, I have some reports in PBCS system. Now, I am trying to connect to the report on Excel SmartView via a Shared connection. I remember in the past, I could… -
Resource mapping Report: feasibility to append the Job Requisition URL with external Site detailsIs there any feasibility to append the Job Requisition URL with the external site name details for tracking the candidate flow from the source website.(E.G; LinkedIn, In…Suneetha Narisipuram 22 views 2 comments 0 points Most recent by Pandey Roma Reporting and Analytics for HCM -
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… -
Reports folder missing from Planning Apps in SmartViewSummary: Reports folder is missing for users in smartview in our planning apps over the past couple weeks. Potentially aligned with Feb production updates. Am I missing … -
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 79 views 2 comments 0 points Most recent by Jeelan Banglewale-Oracle Reporting and Analytics for ERP