Category 129
Discussion List
-
After 22A upgrade we are not able to delete BI email server from Oracle Cloud Non-Prod InstancesSummary: Please suggest, After 22A upgrade we are not able to delete BI email server from Oracle Cloud Non-Prod Instances Content (required): After 22A upgrade completed…User_J7H19 31 views 1 comment 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP -
ERP Cloud BIP report data model schema integrate with EPBCSHi all, I need to create a metadata / dimension integration from our ERP Cloud GL to EPBCS via data management. Can you please help me find in ERP the SQL query on top f… -
oracle report to google sheet directlyis there any way to connect oracle BI and OTBI reports with online google sheet or offline excel file ? ThanksSandeep Nihalani 31 views 2 comments 0 points Most recent by Melissa G Reporting and Analytics for ERP
-
Vacation and Delegation Rules reportSummary: Hi All, We have a requirement to create the below report for Vacation and Delegation rules in the application. Say when Line Manager is going on Holiday and he …Dharmendra Jha 62 views 3 comments 0 points Most recent by Stephen_J Reporting and Analytics for ERP
-
PRC: SQL to get the Cost Center Owner approver's email address on RequisitionsSummary: We are currently investigating the process of being able to extract the Cost Center Approver email address. The cost center owner approval is setup in the secon…
-
which table Notification attachments are storedSummary: While approving the any approval notification the user can add attachment in the notification. where this attachment are stored. Content (required): Notificatio…
-
Need to push output files of the job Import Project Budgets through SFTP.Summary: Content (required): The issue can be reproduced with the following steps: Step1: We are scheduling the Import Project Budgets job. This is a seeded processes. S…Lokesh Senthilnathan 1 view 0 comments 0 points Started by Lokesh Senthilnathan Reporting and Analytics for ERP
-
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 42 views 6 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP -
Unable to find PVOs related to MSC(Planning Table)Summary: Hello, We need PVOs for following(Fusion) tables in BICC, as we couldn't find these in Data Lineage Sheet. If anyone has any idea on how to get those or any doc…Jahnavi-Oracle 51 views 0 comments 0 points Started by Jahnavi-Oracle 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 63 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… -
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 31 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 …JeannieMoore 32 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 199 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 21 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 52 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…
-
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…Kathy King 71 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…AngelOftheNorth 71 views 2 comments 0 points Most recent by AngelOftheNorth 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 22 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 492 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 …AngelOftheNorth 21 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 11 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 164 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 11 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 "…