Category 129
Discussion List
-
HWM_TM_STATUSES - Many entries for a given timecard entry (Human Workforce Management / Timecards)We would like to know how the HWM_TM_STATUSES table works in regards to timecard entry changes (when a timecard is submitted, approved, then modfied). In our observed be… -
Bursting Enabled or DisabledHi Team, We wanted to check if we have a table or sql query to check how many reports have bursting enabled so a report or list can be prepared for the same. Please let …Swapnil Kashid 53 views 6 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP -
OTBI-Report-Supplier Portal - Invoice Real Time-Roles RequieredSummary: OTBI-Report-Supplier Portal - Invoice Real Time-Roles Requiered Content (required): Hello The following document state the role required to run the Supplier Por…Cesar Saveedra 73 views 3 comments 0 points Most recent by Cesar Saveedra Reporting and Analytics for ERP
-
BI - Seeded and Custom Folders Mirroring Each Other?!Summary: We are experiencing several custom template issues and have noticed that our Custom and Seeded Folders are mirroring each other without human intervention. Cont… -
Create a report that shows invoice data on day it was loaded?Summary: Hi everyone. I am curious if there is a way to create a report that allows me to collect data from an invoice on the day it was created. Such as Problem Type. I…User_2025-02-10-15-06-52-222 13 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
PO Spend Analysis in one currency (USD or Ledger Currency)Summary: PO Spend Analysis in one currency (USD or Ledger Currency) Content (required): We are using Oracle provided Analysis: PO Spend by Top Category We found that the…
-
ERP Cloud list of payables invoice approversSummary: You can go into BPM and see, for a given invoice, the full list of approvers showing who submitted the invoice for approval, who the invoice is currently with f…User_AJ9D1 33 views 1 comment 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP
-
BICC - I'm looking for the link to the list of potential deprecated PVO's or objects for Release 22ASummary: BICC - I'm looking for the link to the list of potential deprecated PVO's or objects for Release 22A Content (required): BICC - I'm looking for the link to the …User_2025-03-07-18-57-57-349 33 views 1 comment 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP
-
What tables hold the project costs expenditure batch workflow details for creator and approverSummary:Does anyone know if this information can be reported on using BI Publisher or OTBI to view the approval workflow for project cost expenditure batches? This infor…Rich Merkel 270 views 2 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP -
What is Difference Between Secured and Unsecured Assignment Manager Folders in Workforce ManagementSummary: What is Difference Between Secured and Unsecured Assignment Manager Folders in Workforce Management - Worker Assignment Real Time Content (required): What is Di…Vijay Gorania 25 views 2 comments 0 points Most recent by Vijay Gorania Reporting and Analytics for ERP
-
21D BIVO list for ERP (Financials, Procurement, Projects and HCM)Summary: I am looking for latest 21D Deprectaed BICCC list for ERP (Financials, Procurement, Projects and HCM). Any link where I can download the latest listing. Appreci…pratyushak 56 views 3 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
Invoices Report acccessSummary: creating have created a report using Payables Invoices - Transactions Real Time and Payables Invoices - Installments Real Time Content (required): creating have…User_2025-02-10-15-06-52-222 31 views 6 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
OTBI report - export to Excel limitationSummary: We have OTBI reports that will exceed the 50,000 field limitation for exporting to Excel. Content (required): Can you "schedule" an OTBI report to get around th…User_2025-01-28-20-19-02-475 76 views 2 comments 0 points Most recent by Ghanshyam M-Oracle Reporting and Analytics for ERP
-
OBIEE / OTBI Pivot Table Calculated % VarianceSummary: Need the equivalent of ABS in pivot table calculated column Content (required): In a pivot table presentation; - I have a calculated column; Variance which is e…User_2025-02-10-15-12-48-631 75 views 2 comments 0 points Most recent by User_2025-02-10-15-12-48-631 Reporting and Analytics for ERP
-
BIP Excel output always adds additional comma to end of values when saving as csvSummary: Content (required): In BI Publisher, I need to export a simple table report to XLS (not csv) to be used as a template. However, once completed and then saved as…Marcus131975 28 views 3 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
How to copy a BI or OTBI report to another environmentSummary: Content (required): Looking for how to copy a report from one environment to another Version (include the version you are using, if applicable): Oracle Cloud Ap…55Chevy 882 views 5 comments 0 points Most recent by Ghanshyam M-Oracle Reporting and Analytics for ERP
-
How to get action link to pass parameter to 'Is Prompted' column when source column is calculated?Summary: Content (required): In Fusion Financials subject area; "General Ledger - Balances Real Time" I have been following the white paper to develop a dashboard based …User_2025-02-10-15-12-48-631 23 views 1 comment 0 points Most recent by Ghanshyam M-Oracle Reporting and Analytics for ERP
-
Do analyses run with Agents log to "OTBI Usage Real Time" subject area?Summary: Do analyses run with Agents log to "OTBI Usage Real Time" subject area? Content (required): Version (include the version you are using, if applicable): Code Sni…Andrew_Schmitz 12 views 2 comments 0 points Most recent by Ghanshyam M-Oracle Reporting and Analytics for ERP -
Folder/Report Last Modified DateHI Team, After a refresh/upgrade/patch getting applied does the folder last modified date change for each folder. We could see some folders have different last modified …Swapnil Kashid 176 views 3 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
Projects-Labor distribution Cost analysis is missing exception information for error rowsSummary: Projects-Labor distribution Cost analysis is missing exception information for error rows Content (required): We have analysis built on Projects-Labor distribut…Mona Mantry 13 views 1 comment 0 points Most recent by Mike Bartoletti-Oracle Reporting and Analytics for ERP -
Is it possible to have manual input option with LOV menu?Summary: Researching the ability to manually input bulk values while keeping LOV search functions. Content (required): When you open the search box for dropdown paramete…
-
Delivered Asset Transaction History Report runs to error if From/To Asset fields are blankSummary: If we run the Asset Transaction History Report, and only entering the required parameter of Asset Book, it runs to Error within a minute. The "From Asset" and "…Brad Kirschner 3 views 0 comments 0 points Started by Brad Kirschner Reporting and Analytics for ERP
-
How do I manage, see, & edit existing scheduled BI Reports I set to run monthlySummary: I have 5 BI Reports that I've scheduled to run every month. I used to be able to see/edit the list of my scheduled reports in the "Report Jobs" link in the left…Jocelyn Layos 175 views 10 comments 0 points Most recent by Sandeep19rm Reporting and Analytics for ERP
-
How are you managing OTBI AgentsSummary: We have some analysis/dashboards that we want to schedule and send out as specific times using agents. Question is there any best practices around the managemen…amy hardtke 13 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP -
GL Segment Level security and OTBI Subject areasSummary: We have a requirement to secure data down to a legal entity/cost center level for dashboard built in OTBI with the GL Transactions real time subject area. How b…
-
BI Cloud Connector (BICC) do all incremental last_update_date columns need to be selected for PVOSummary: When there is more than one last_update_date object included in a PVO should all be included/selected for the extraction file. For example, with most of the 'vi…User_2025-03-07-18-57-57-349 59 views 1 comment 0 points Most recent by Vivek Gautam Reporting and Analytics for ERP
-
OTBI analysis opens directly without showing prompt when opened from the reports and analytics pageHi team, Facing an issue where an OTBI analysis opens without showing any prompt from the reports and analytics page ( it's added to favourites ) but when opened by navi…
-
BICC - How do you remove a datastore/pvo from a job?Summary: How do I remove a datastore from a job; disassociate it. I have a custom offering where I had added a datastore/pvo that I no longer want included in the job th…User_2025-03-07-18-57-57-349 126 views 1 comment 0 points Most recent by Vivek Gautam Reporting and Analytics for ERP
-
Account Description is as the code in General Ledger Analysis and error when the columns are addedSummary: Content (required): Trying to build up an analysis report but when extracting the account description it is the same as the account code. But in the value sets …Dian Minshan 43 views 1 comment 0 points Most recent by Dian Minshan Reporting and Analytics for ERP -
OTBI - Convert Entered Amount to USD for Non Usd LedgerSummary: Is it possible to convert an Accounted Amount to USD for Non USD Ledger in OTBI (General Ledger Journals Real Time)? Content (required): I have business require…Hannah Dorman 234 views 2 comments 0 points Most recent by Hannah Dorman Reporting and Analytics for ERP