OTBI
Discussion List
-
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 421 views 8 comments 0 points Most recent by PraveenNvP Reporting and Analytics for HCM -
Supplier Portal Dashboard Not Working – Error: “The specified criteria didn’t result in any data”Hi, We are facing an issue where the Supplier Portal standard dashboard is not working and is not displaying any data in our instance. I have attached screenshots for yo… -
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 109 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 41 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 305 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 62 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 2 views 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…
-
Need to add the PO number and related information in the Account analysis reportSummary: As stated in the subject that we need to add the Po number and its relevant information in the Account analysis report therefore we have customized the standard…
-
HCM OTBI subject areas to database lineage mapping spreadsheetThis spreadsheet documents HCM OTBI subject areas to database lineage mapping and subject area security. Content This spreadsheet is published by Oracle OTBI Development…Raghavendra Raghunath-Oracle 44.5K views 194 comments 127 points Most recent by MMB Reporting and Analytics for HCM -
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 31 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 22 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…
-
How to export three reports output into a single pageHi Team, I have merged three reports into a single page. Out of the three, two are OTBI reports & one is a BIP report. When I am trying to export data, only two OTBI rep…
-
Fixed asset YTD deprecation Value IssueIn Fixed Assets, the depreciation data displayed in the application is different from the data stored in the Oracle database tables (FA_DEPRN_SUMMARY and FA_DEPRN_DETAIL…
-
Account Analysis Drill down -Subledger-Real TimeSummary: The requirement is to have all the transactions (Invoices/Credit Memo's) listed in tabular form once we click on particular balance sheet account for the period…Kinjal Patel-Oracle 21 views 2 comments 2 points Most recent by Kinjal Patel-Oracle Reporting & Analytics for Fusion Service
-
Print Receivables Transactions but don't emailSummary: Hello, We want to be able to run the aforementioned request but rather than have email the documents out, simply generate a PDF document. I know that we can rec… -
Looking for the PVO that exposes the ATTRIBUTE_CHAR12 column from the DOO_HEADERS_EFF_B tableLooking for the PVO that exposes the ATTRIBUTE_CHAR12 column from the DOO_HEADERS_EFF_B table in Oracle fusion. We need this for DA in FDI.