OTBI
Discussion List
-
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 186 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 135 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- 90 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 67 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 94 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…