OTBI
Discussion List
-
From which customer table can we find order_type fieldSummary From which customer table can we find order_type fieldContent Please suggest from which customer table can we find order_type fieldNageshwaran1 53 views 6 comments 0 points Most recent by Pradvin Prabhakar Reporting and Analytics for ERP -
R13 20A - How to extract BPM approval Configurations task details via SQLSummary Need to extract BPM approval configurationsContent We have a need to extract all the BPM approval configuration task details via SQL. All things BPM related (the…Suganthi Srinivasan 101 views 4 comments 5 points Most recent by Venkatraman G Reporting and Analytics for HCM -
New Role only seeing their information on any report ran in Reports & AnalyticsSummary PAYADMIN_READONLY_DATA_DATAContent Created a new role in HCM and it only when reports are ran it only shows their information, unless it is a line manager, then …Gabe K 57 views 3 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI Environment variablesSummary Display current user details in environmentContent Hi, Has anyone come across any OTBI environment variables. Or is there a subject area that displays the curren…User_2025-02-05-23-02-10-916 90 views 4 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
When OM creates TO, it creates different transfer order for different lines, is there a way to groupSummary When OM creates TO, it creates different transfer order for different lines, is there a way to group all the lines to create 1 TO for 1 SO -
ESS Access to Custom BI Publisher ReportSummary Access to a Custom BI Publisher Report as Employee Self ServiceContent Hi Friends We have a custom BI Report and one of the parameters is the name. Right now thi…Mansur Khalil 79 views 15 comments 1 point Most recent by AshishERPCloud Reporting and Analytics for HCM -
Benefits Rates and Coverages - Report for Newly added and Dropped Coverages during a pay periodSummary Benefits Rates and Coverages - Report for Newly added and Dropped Coverages during a pay periodContent Hi Experts Please let me know if there is a report for all…Mansur Khalil 53 views 3 comments 1 point Most recent by Adam Gates-Oracle Reporting and Analytics for HCM -
Time entry hours by various time codes otbi/reportSummary Time entry hours by various time codesContent Hi, We have some time codes which are not payroll time types specifically. Either they are part of 'Regular Hours' …Anuradha T 60 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
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 182 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 97 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- 91 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.…