OTBI
Discussion List
-
No data displayed in Goods Received not Invoiced ReportSummary: Hi, I am using seeded OTBI Report 'Goods Received not Invoiced Report' and made a custom report with the same subject area i.e. Costing- Receipt Accounting Real…Vijayalakshmi Matcha - Oracle-Oracle 581 views 4 comments 0 points Most recent by cylim Reporting and Analytics for SCM -
Learning Calendar is not working as expectedSummary: Hi Team, @Mandeep Gupta I'm trying to enable the Learning Calendar in the Administrator Dashboard. Currently, I'm facing an issue with the Learning Calendar OTB… -
Static URL for an analysisI am creating a tile on the My TEam page for a report, how do I build the static URL for an out of the box analysis that I have created a report from? I was able to do s… -
How to enable Export options when analysis added to Reports and AnalyticsSummary: Enable export options below a report from an analysis Content (please ensure you mask any confidential information): We have created custom analysis and made th…Alexandre Chea-Oracle 324 views 12 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP -
Person real time and Assignment real time securityWe have an OTBI analysis for passport and visa details. It combines the Person Real Time and Assignment Real Time subject areas. One employee has a current assignment in…Stephen Jones 21 views 5 comments 0 points Most recent by Stephen Jones Reporting and Analytics for HCM -
SQL query to get remaining life, depreciation for the month, depreciation expense account in FusionSummary: SQL query to get remaining life, depreciation for the month, depreciation expense account in Oracle Fusion for Assets Content (required): Version (include the v… -
Missing current month data in OTBI for payrollSummary: Missing current month data in OTBI for payroll Content (please ensure you mask any confidential information): We have facing an issue where the current pay peri… -
Need document on how to migrate Value Set from HCM Extarct to from one instance to another instanceSummary: Need document on how to migrate Value Set from one instance to another instance Content (please ensure you mask any confidential information): Hi Team, I am usi…Ketan-Oracle 21 views 1 comment 3 points Most recent by JayeshKori-Oracle Reporting and Analytics for HCM -
How do we access OTBI reports in redwood inventory?Summary: In the Classic UI users are able to access OTBI reports from the drawer on the right of the screen. How do users access OTBI reports in Redwood Inventory? Conte… -
Generate Report with Timecard ApproverSummary: We need to generate a report with the time card approved date and who approved it. Content (required): I've seen this question asked a few times, but it doesn't…User_2025-01-31-00-25-12-234 424 views 8 comments 0 points Most recent by PraveenNvP Reporting and Analytics for HCM -
Adding Project Classification (Class Code) to OTBI report duplicate Costs RowsSummary Adding Project Classification (Class Code) to OTBI report duplicate Costs RowsContent Adding Project Classification (Class Code) to OTBI report duplicate Costs R…User_2025-01-30-23-00-53-497 114 views 5 comments 1 point Most recent by Rich Merkel Reporting and Analytics for ERP -
Is it possible to run an OTBI report and the results to be what my manager would seeI want to be able to build reports in OTBI for employees to run, with the results to return as if it was their line manager running the report themselves. I understand t… -
How to report on comments for Checklist QuestionnaireSummary: In OTBI, Workforce Management - Checklist Real Time, I am trying to find the column that shows what comments were made in the "Comments" field in the questionna… -
While im creating a analysis report, when i add the invoice number it duplicates the rowSummary: Im creating a report in analysis when basics fields like Order, source order, customer, item and basic of the order line everything fine. But when i add the inv… -
Original Candidate sourceSummary: Content (required): Is it possible to capture candidate’s original source via reporting? Currently the system only tracks application source and we lose key dat…Riti Malhotra 42 views 3 comments 1 point Most recent by Riti Malhotra Reporting and Analytics for HCM -
Labor Distribution - Reporting Attribute to Identify Labor Costs that are Eligible for ReprocessingSummary: We need to be able to proactively identify labor costs that are eligible for reprocessing based on changes to corresponding labor schedules. For example, if a l… -
OTBI Report with future hires and terminationsHello, We are attempting to build a report to help our partners keep track of I-9 completions. We are using the subject areas Worker Assignment Event Real Time and Work …joshvanlaan 312 views 10 comments 0 points Most recent by Kimberly B. Reporting and Analytics for HCM -
otbi is fetching the amount details for only USD currencies not for all currenciesotbi is fetching the amount details for only USD currencies not for all currencies do we need to enable any profile options, apart from USD we are unable to get the amou…Akhila.Allagadda 51 views 8 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
OTBI Agent Not Sending Files to Distribution List EmailGood Day Experts, We have an OTBI Agent that is not sending the file to a distribution list email. The OTBI Agent is sending our dashboard to an excel file. Sending to i…JMLMIII 61 views 6 comments 0 points Most recent by Vidhya Nadarajan-Oracle Reporting and Analytics for HCM -
Where can we find bank account suffix from Supplier site bank account Subject area?Summary: Supplier bank account suffix in OTBI Content (please ensure you mask any confidential information): The Account Suffix is located under Additional Information i…Uma Scherer 1 view 1 comment 0 points Most recent by SankarBalu Payables, Payments & Cash Management -
pension reason for leaving qualifying schemeSummary: Report on Employees who have opted out of a pension scheme. Content (please ensure you mask any confidential information): Hi All. Trying to create a report tha… -
How doo_headers_all and por_requisition tables are related .Summary: We need to write query to connect doo_headers and requisition to get po_number and receipt . or it can be connect from PO or RCV tables? how can i form query wi… -
Cannot select attributes from 2 different folders in same Subject AreaSummary: I select "- Negotiation Header Detail"."Negotiation Number" and "- Supplier List Detail"."Trading Partner Id", 2 columns from same Subject Area and 2 different … -
How do we access OTBI reports in redwood inventory?Summary: In the Classic UI users are able to access OTBI reports from the drawer on the right of the screen. How do users access OTBI reports in Redwood Inventory? Conte… -
Custom dashboard -How to provide link/details to export based on graph/chartSummary: Custom dashboard -How to provide link/details to export based on graph/chart Content (please ensure you mask any confidential information): we created custom da…Tapas_Sathua 21 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
Issue with Tax Amount Display in OTBI Line ItemsSummary: Merge Tax line of receipt Content (please ensure you mask any confidential information): Hi, We need to include the tax amount on a single line. Currently, in O…Muhammad_Saad 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
How to insert Linefeed or carriage return between two Attributes?Summary: I would like to concatenate 2 attributes and have the second attribute print on the next line. This formula doesn't achieve that: "- Negotiation Header Detail".…VDM_IM 32 views 3 comments 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
How to get procurement supplier number from supply planHi CCC, My requirement is to get supplier number for the suppliers in the supply plans. I could see the order_number in MSC_SUPPLIES but for some it is empty. SUPPLIER_I…VishnupriyaSelvakumar 21 views 3 comments 0 points Most recent by Sebastian Thomas Supply Chain Planning and Collaboration -
Has anyone been able to edit seeded data model that uses XML file as a dataset instead of sql query?Summary: I need to edit the Electronic Record for Ship Confirm Report to include custom data. The data model for this report uses an XML file as a dataset instead of an …ajudge 21 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
How to connect organization hierarchy with job requisition?Summary: I am using recruiting real time subject area and trying to connect Job Requisition with Level 3 Organization Name but unable to get result on the Level 3 org na…