OTBI
Discussion List
-
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 24 views 1 comment 3 points Most recent by JayeshKori-Oracle Reporting and Analytics for HCM -
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 434 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 129 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…Helen Tilling 1 view 0 comments 0 points Most recent by Helen Tilling Reporting and Analytics for HCM
-
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 329 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 72 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…Jeevan Loyal 2 views 0 comments 0 points Most recent by Jeevan Loyal 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 22 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 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 22 views 2 comments 4 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.
-
Key Flexfield Segments Not Appearing in OTBI Subject Area "Budgetary Control - Balances Real TimeDear all, I am writing to request assistance with Key Flexfield structures and their visibility in Oracle Transactional Business Intelligence (OTBI). Issue: I have creat… -
Journey Template reportSummary: Does anyone have a sample of a report that pulls all the configuration details related to a journey template? Content (please ensure you mask any confidential i…Shanna Oppenheim 3 views 0 comments 0 points Most recent by Shanna Oppenheim Reporting and Analytics for HCM -
In OTBI Multiple home email address to show in Single columnSummary: In OTBI, there is a requirement to display multiple home email addresses in a single column. In my case, two home email addresses need to appear in separate col…Shubham Kadam 32 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM