OTBI
Discussion List
-
Create dashboard prompt using column with custom formulaSummary Analysis has calculated column with bins. How can I create a dashboard prompt using this column?Content I created a column that bins seniority years (seniority u… -
How to view the accounting entries for AP invoice in Receipt AccountingSummary How to view the accounting entries for AP invoice in Receipt AccountingContent How to view the accounting entries for AP invoice in Receipt Accounting module. Th… -
How to obtain a flat bill of material (flat BOM)?Summary Within production information management, is there a way to get an aggregated parts list?Content We have a bill of material that has approximately 700 unique par…Brian Lisiecki 187 views 1 comment 0 points Most recent by Carlos Benassi Product Master Data Management
-
How to Print the attachment in PO ReportSummary We have a requirement to get the attachment from a PO should get displayed on the View PDF document. Kindly SuggestVersion 11.13.20.04.0Yogesh Kumar-234569 132 views 3 comments 0 points Most recent by Lucky Sharma Reporting and Analytics for SCM
-
OTBI Custom Dashboard PromptSummary Looking for ideas on Custom Dashboard PromptContent Hello, We want to create a custom dashboard prompt to add to the other list of prompts. We need a prompt for …Tony Puentes 92 views 7 comments 0 points Most recent by Tony Puentes Reporting and Analytics for HCM
-
Usage TrackingSummary OTBI Usage TrackingContent Is Usage Tracking available for OTBI Reports? Something like in 20A for BI Publisher reports? Or even that which is available for OBIE…User_2025-02-05-23-02-10-916 98 views 6 comments 2 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
How to retrieve attachment file of expense item in a BI ReportContent Hi everyone, Is it possible to get the attachment of an expense item through a BI report? So far I have only found the tables from fnd_documents and fnd_document… -
Report needed for default expense accountSummary Report needed for default expense accountContent Hi I am trying to get a report of all users on oracle and their default expense account on OTBI but cannot find …User_2025-01-29-02-09-34-137 163 views 9 comments 1 point Most recent by User_2025-02-05-23-22-15-856 Reporting and Analytics for ERP
-
Send UCM File As Email AttachmentSummary Send UCM File As Email AttachmentContent Hello Experts, We are using “Publish Plan” program to export some planning tables data to UCM server but there is no way…Abhishek Sharma- 89 views 4 comments 2 points Most recent by Dj-Oracle Supply Chain Planning and Collaboration -
Can we create a multiple selection paramter in the custo ess job?Summary Can we create a multiple selection paramter in the custo ess job?Content Hello , We have create a one custom job for the BIP report and now the users are excepti…Koteswararao Yenikepalli 54 views 1 comment 0 points Most recent by Vikas Tiwari Reporting and Analytics for ERP -
Is it possible to fetch Hire Date changes of employees through HCM Extract or OTBI?Summary Is it possible to fetch Hire Date changes of employees through HCM Extract or OTBI?Content Hi Experts, We are looking for a requirement to fetch Hire date change…Harish Kumar Kovi 54 views 4 comments 0 points Most recent by Harish Kumar Kovi Reporting and Analytics for HCM
-
Set background color on subtotal lines in OTBIContent Hi, I would like to set background color on subtotal lines in OTBI Analytics. Does anyone know how to configure about this? regards, Version BIP 11.1.9 bundled w…shun nakamura 40 views 5 comments 2 points Most recent by shun nakamura Reporting and Analytics for ERP
-
Using Subject ID in Transaction AdministrationSummary How do I use Subject ID to join to other Subject Areas to identify employee impacted by transaction by nameContent I would like to create an OTBI report on faile…User_2025-02-04-08-27-17-553 64 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
SCM – What's New in Quality Management, 26 August 2020, 9 a.m PT - Submit QuestionsContent Submit your questions for the SCM – What's New in Quality Management session to have them answered during the live event. Post your questions by posting a new co…
-
Require More than one Segments Dependent on an Independent Segment (#LOC KFF)Summary Require More than one Segment to be Dependent on an Independent Segment (#LOC KFF)Content Hello Team, In the FA Location Flexfield, we require two segments to be… -
COA value missing in the LOV in Payables invoices - Transactions real time subject areaSummary COA value missing in the LOV in AP invoices real time subject areaContent Hi Gurus, We defined a cost center long ago and had AP transactions created against it.…
-
Approved GoalsSummary Need to find dates when Goals were approvedContent Hi, I need to find all Goals that were approved between the 20th - 23rd July but when I look I see there are m…User_2025-02-05-22-44-35-842 23 views 4 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
Busting OTBI Myths - Trend reportsContent Myth: You can't report trends in OTBI Trend reports can be produced in any subject area which has a "Time" dimension folder (as of 19B 63 out of 78 subject areas…Julian Challenger-Oracle 66 views 2 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Cycle query for Structures and Components.Content Hi there. I'm trying to get a by level BOM with tables EGP_STRUCTURES_B and EGP_COMPONENTS_B. It's not so easy to relate as in EBS, you guys have any good cycle …User_2025-02-07-06-48-26-537 22 views 1 comment 0 points Most recent by Ahmed Mousa Reporting and Analytics for ERP
-
How to get invoice_number against transaction in RA_CUSTOMER_TRX tableSummary How to get invoice_number against transaction in RA_CUSTOMER_TRX tableContent Please help us to get invoice_number against transaction in RA_CUSTOMER_TRX tableNageshwaran1 95 views 5 comments 0 points Most recent by Nageshwaran1 Reporting and Analytics for ERP -
Query who is assigned the requisition approvalContent Hi, I need to create a report to find out which user is assigned the Purchase Requisition approval. Does anyone have the query or tables I need to create this vi… -
Transfer ReportingContent Hello everyone, I am trying to get a transfer report built in OTBI. I have the basis of the report built and it is pulling the employees that I am looking for. H…Andy Whalen 59 views 2 comments 0 points Most recent by User_2025-02-01-03-43-13-079 Reporting and Analytics for HCM -
Demand Plan: Which Data base table stores the details of 'which forecasting method was used to generSummary Demand Plan: Which Data base table stores the details of 'which forecasting method was used to generate the forecast for Item-Org combination in a demand plan'?C…Ramesh Choudhary 76 views 2 comments 0 points Most recent by RakeshOracle-Oracle Supply Chain Planning and Collaboration -
Learning Gamification and BadgingSummary Use OTBI to deliver gamification and badgingContent
-
Rehire Date as a PRESENTATION_COLUMNSummary Rehire Date as a PRESENTATION_COLUMNContent Hi All, My business user complains to me that Rehire date is not a presentation column and is not as easy as adding a…Sriharsha Devraj 52 views 1 comment 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM