OTBI
Discussion List
-
How to translate Amount in Words from English to Arabic language in rtf templateSummary: we have a requirement to print Payment amount in Words (English) to Arabic language in check template. The expectation is that, translate below given English te…SireeshaJaladi 565 views 9 comments 0 points Most recent by ArjunReddy88 Reporting and Analytics for ERP -
How to use Special Handling attributes in OTBI analysis?Summary: As of the 24D update, there is the new feature to use special handling type attributes within the "Procurement - Purchasing Real Time" subject area (https://doc…
-
Subtotal is not calculated correcting for one of the custom calculated measure in the OTBI reportSummary: I have created a custom OTBI report DPO (Days Payables Outstanding) to look at the average days to pay vendor. The last column is a calculated measure based on …
-
How to create an OTBI report to pull information on learning assignment deleted date?Summary: How to create an OTBI report ( or what are the subject areas ) that helps to pull information regarding learning assignment deleted date? As part of 24 C New fe…
-
SQL Link between AP and Projects ?Summary: Report which shows project transaction that have flown through to AP Content (required): Hi Does anyone know the links/joins between AP and Projects, we are try…
-
Embedded OTBI Analysis Refresh IssueHi, I'm using an embedded OTBI Analysis within Fusion HCM on Candidate Submission Profile. I'm running into a cache issue where if the report is viewed before the result… -
How can I track changes on Maintenance Asset Notes?Summary: How can I track changes to Maintenance Asset Notes and add them to the History tab? Content (please ensure you mask any confidential information): Our client wa… -
Unique Learner Record - Learning Records Real TimeSummary: I am needing to produce results that provide a unique set of learner records for each training title in the analysis. I need the formula to produce the record t… -
Getting Error when adding Questionnaire Text and Response Text for Observer Checklist reportsSummary: Getting Error Content (required): Has anyone put together a step by step in creating the Observer Checklist Responses? I can't find all of the options listed in… -
OTBI Report integrated within performance document is not loading first timeSummary: OTBI Report integrated within performance document is not loading first time Content (please ensure you mask any confidential information): I have OTBI report c…Neha Thakre 2023 11 views 2 comments 0 points Most recent by Sivakumaran Muthusamy-Oracle Reporting and Analytics for HCM -
Performance OTBI to extract Task Status, Section Names, Rating LevelsDears, we have a requirement to build an Analysis to extract performance document task status and ratings given to each document section. To do so we are crossing "Workf…Domenico P. 201 views 1 comment 0 points Most recent by Sivakumaran Muthusamy-Oracle Reporting and Analytics for HCM
-
Search AHCS transactions from UI via search criteria of Supporting Reference ValueSummary: There is a requirement to search AHCS transactions from UI via search criteria of Supporting Reference Value. Please suggest a workaround if current functionali…Himanshu_Parmar827 31 views 1 comment 0 points Most recent by Anca A-Oracle Subledger Accounting & Accounting Hub
-
Fusion HCM - OTBI Report - Can't view other employee's data only my own ?Summary Fusion HCM - OTBI Report - Can't view other employee's data only my own ?Content I have created a OTBI report with the subject area 'Workforce Management - Worke…Ruzwan Akram 297 views 15 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI report returning incorrect row count if certain columns are not in the selected columnsWe have a report that does not return the accurate row count if the Acquisition Date, Internal Segment, and Department Name are not in the Selected Columns. If the Acqui…
-
Access to learning items based on legal employerSummary: We have a requirement where learner should access courses based on their legal entity. Foe example: Learner whose legal employer is XYZ should access courses cr…
-
Fixed Asset - Creating Cross Subject Area without SQLI am creating a cross Subject Area OTBI and having a problem. Fixed Asset- Asset Depreciation Real Time Fixed Asset- Asset Transactions Real Time When adding Asset Tran…Nao-Oracle 12 views 1 comment 0 points Most recent by Louise Gareau - Support - Oracle-Oracle Assets -
for-each OTBIHello everyone, I have the following problem: I have a report that is grouped by several groups and subgroups. I need to be able to total the columns for each subgroup a… -
accounting asset inquirySummary: Hello everyone, I am making a report from which I need to obtain the following value from the box in red. I can't find the table in which I can locate those val…
-
QUERY PURCHASE ORDERS WITH RECEIPTSHello everyone, I require a query for a report in OTBI that allows me to reach those values (those in the red box) when I pass the purchase order number as a parameter.
-
Need to build report between Task and Call Report (created via Task Page)Summary: Created a Task > open Task Detail > Action > Create Call Report. So now we have Task and its linked call report. Now we want to create a BI Report which should …AMIT KUMAR YADAV 41 views 9 comments 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Sales
-
Report data size exceeds the maximum limit (524288000 bytes). Stopped processing.Summary: We were given a SQL query to pull journal entries for our auditors and it worked successfully for FY22. We tried to run the report again for 2023 and received t…hannah_barry 8.8K views 7 comments 0 points Most recent by Shankar-Oracle Reporting and Analytics for ERP
-
What are the setups/steps needed to enable to print the checks in local language?We have a requirement from the Canada, that has to print the checks in their local language (Canadian French). Could you please provide the steps that need to enable in …Raju Thadakala_1234 62 views 3 comments 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Work Order(WO): Requisition is approved without approval.Summary Work Order(WO): Requisition is approved without approval.Content Hi all, Work Order(WO): Requisition is approved without approval. Thanks, Dev Thota. Version 19B -
OTBI Unable to get the Payment Process Profile TemplateSummary: I need to create an OTBI Payment Report and include the PPP Template "Name", and I am unable to find it. I check in the "Payable Payment - Disinterment Real Tim…Pablo Schenquerman 11 views 3 comments 0 points Most recent by ADOLFO GARCIA BARBA-Oracle Payables, Payments & Cash Management
-
Created a BIP report from subject area Payables-Payments Disbursement Real to concatenate columnsSummary: Created a BI publisher report using Subject area from Payables. There is no option to concatenate two or more columns. I need to concatenate the payee address f…PSehgal2388 11 views 1 comment 0 points Most recent by James McBride Reporting and Analytics for ERP
-
Report to get employee's default expense accountSummary: Hi, Can you please suggest if OTBI report is possible to develop to get employee's default expense account? If Not can you please share any SQL query which can …