OTBI
Discussion List
-
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 300 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 11 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.6K 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 54 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 … -
Consolidated List of OTBI and BI Publisher Reports Posted (14 April 2015)Content The following is the list of published OTBI and BI Publisher reports between 10 December 2014 and 10 February 2015: * OTBI: Employee Salary and Performance Ratin…Julian Challenger-Oracle 298 views 3 comments 3 points Most recent by Ms_Oracle Reporting and Analytics for HCM -
OTBI Vacancy ReportSummary: Is there a way to report using Subject Area(s) all current employees and any requisitions and vacancies so we have one entire list? For example a report that sh…JHaden3 162 views 13 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI -Costing Receipt Accounting Real Time - Cost Source ReferenceSummary: OTBI -Costing Receipt Accounting Real Time - Cost Source Reference We would like to have the information as per the attached print screen Which is the cost elem…
-
How to configure Web Service Data Source Options in OTMSummary: I want to use Web service as a Data source in OTBI Content (please ensure you mask any confidential information): Hello, I am trying to paste the WSDL URL from … -
Can you please help me to find parent reports for the below OTBI child reports?Can you please help me to find parent reports for the below OTBI child reports? Past Due Fulfillment Lines Report Sales Order E-mail Sales Order Line Status Update Sales…User_SIV20 2 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
How can I grant "GL users" access to the seeded "Payables Trial Balance Report"?We have a requirement in which "GL users" can generate the seeded "Payables Trial Balance Report" on their own to expedite their tasks. How can we configure this in Orac…Arsen Guevara-CITCO 72 views 4 comments 0 points Most recent by JohnG Reporting and Analytics for ERP -
How to get original or first requisition approved dateHi! I need to get the first or original requisition approval date for a report. How do I get it? The field Requisition Approval Date shows the latest/recent approval dat…Jose Renato Salvador 11 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Create an OTBI report for quantitative questions in an EvaluationSummary: Content (please ensure you mask any confidential information): We use Sildo to gather feedback after Instructor Led training sessions. This is far from automate… -
Where is the Assignment Start Date in Learning Records Real Time subject area?I have an assignment that I can see in the UI has a start date of next year. This assignment is a result of a retraining cycle - a course they take yearly. In the Learni…