Category 129
Discussion List
-
Analysis ("Payables Invoices - Transactions Real Time") - Need to Add a new columnI'm building an analysis ("Payables Invoices - Transactions Real Time") in OTBI and wanted to know if it's possible to add a new column which is not in the "Payables Inv… -
Tracking Data Model Usage and associated queriesSummary: How is called the table or view (Oracle fusion) which tracks the information about the queries (data models) run by a user? The goal is to determine which table…Christian Flegler 11 views 1 comment 1 point Most recent by Lee Eslick-Huff Reporting and Analytics for ERP -
How to Attach Process ID(fusionapps_request_id) to File Name when Bursting ?Hi All, Now there is a process which content is a BIP report with bursting. I'd like to attach the process id as a part of bursting file name. But when I use ':fusionapp…
-
Excel template with summary and Detail and Detail sheet should split in to multi sheet, need helpSummary: Excel template with summary and Detail and Detail sheet should split in to multi sheet, need help Content (required): Excel template with summary and Detail ( D…Dineshkumar.A-Oracle 3 views 1 comment 1 point Most recent by KISHAN BUSSA Reporting and Analytics for ERP
-
How can I create an event trigger in a data model with subject area?I have created a report with a data model with subject area and this report works fine, but I want to create an event trigger so that the report is only generated if it …
-
How to change member display in SmartView FunctionEven if I changed "Member Name Display" in Options>Member Options> General> Member Name Display, there are no changes in "Member Selection". Member Selections shows each…Nao-Oracle 22 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP -
How does FR retrieve data from EssbaseCube?I would like to know how FR retrieves data from EssbaseCube, because of its performance. When we'd use FR, it takes much more time than we'd use Smartview at the same co…
-
Prompts are not currently supported for analysis that combine criteriaSummary: Combined two SA i.e "Projects Billing - Revenue Real Time" + "Project Performance Reporting Real time" and want to have 'Project name' as Prompt Value and it is…SBJ_PPM_1210 73 views 2 comments 0 points Most recent by Tomasz Kaniuk Reporting and Analytics for ERP -
Query to bring the BU to which a Customer Account Site is associated toSummary: Content (required): I need a query to retrieve the BU name associated to the Account Site . Thanks. Version (include the version you are using, if applicable): …Michal Shaked 439 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
Customer StatementSummary: Unable to print page number in rtf layout based on the customer Content (required): Hi Team, we have requirement to print the page number in the rtf template ba…
-
LACLS: Dominican Republic (DO) BIP Reports Libro Diario and Libro Major do not render parametersSummary: The Libro Diario and Libro Major BIP reports in the Latin America Cloud Local Solution (LACLS) for Dominican Republic do not work. Parameters do not render. Con… -
Table for Bursting Output ResultsSummary: Does anyone know what table has the results of an individual bursting output from a scheduled BIP report? From the screenshot above you can see that we have one…Lee Eslick-Huff 149 views 2 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP -
Is there a standard report to run showing all terminated users and terminated dates from Oracle ERP?Summary: The customer was inactivated and locked the user from the Security and Console. Please note they are not using the HCM module. However, they would like to displ…
-
Format Automatic Receipts - Override Email CommunicationSummary: At BIP server level, for the complete POD, is there any option to override the TO email address is being used to communicate any email via bursting query? Conte…
-
Is it possible to add a new filed in data model query of Payable Trial Balance seeded report?Summary: We have a requirement to get Supplier name in Arabic in Payable Trial Balance report. User don't want to customize the seeded report as they are using same repo…SireeshaJaladi 144 views 8 comments 0 points Most recent by SireeshaJaladi Reporting and Analytics for ERP
-
How to pull GL JE data for a rolling last 2 periods or last 60 daysSummary: How to pull GL JE data for a rolling last 2 periods or last 60 days Content (required): How can I pull GL JE data from the GL JE Header and Lines tables, so the…
-
Can BICC write CSV files to Object storage or UCM without zippingSummary: Can BICC write CSV files to Object storage or UCM without zipping Content (required): Currently BICC writes CSV files with zipping onto Object storage or UCM. S…V Bikki 64 views 3 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
GL Budgets not being returned from General Ledger - Balances Real TimeSummary: Subject area General Ledger - Balances Real Time not returning data for GL Budgets (budgets are loaded) Content (required): Hi, I have followed Doc ID 2177122.1…Ian.Gooderham 106 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Convert Period Name to DateSummary: Trying to convert period name format to date format mm/dd/yy Content (required): Hi All, I'm trying to convert the column "Fixed Assets - Asset Depreciation Rea…
-
Pricing List ReportHi, I am looking to create BI publisher report on Pricing List. If you can share the query and RTF template if any available please do share ThanksMohammed Rafi 32 views 2 comments 1 point Most recent by Mohammed Rafi Reporting and Analytics for ERP -
rtf template balance lines between two adjacent cellsSummary: RTF Template - Balance lines between two adjacent cells Content (required): We've modified our invoice print template to include serial numbers when applicable.…WTX Sysadmin 12 views 3 comments 0 points Most recent by Aaron Leggett Reporting and Analytics for ERP
-
Query to fetch List of OTBI usersHi Team, We do have a requirement to Create a report for List of users having OTBI access. Regards, RamuVadde Ramu 64 views 3 comments 0 points Most recent by Dharmendra Shukla Reporting and Analytics for ERP
-
How to find from which system or ip submitted a bip reportSummary: can we check from which system or ip a bip report got triggered? we are using a generic login shared across all developers and testers Content (required): can w…Lavakumar 13 views 1 comment 0 points Most recent by Dharmendra Shukla Reporting and Analytics for ERP
-
Obtain the number of SQL executions or the number of executions of the BIP itselfSummary: I want to create a query to extract the number of data model runs or BIP reports run in ERP's BI publisher. Content (required): The objective is to extract the …YUTA TOGASHI-Oracle 42 views 3 comments 0 points Most recent by YUTA TOGASHI-Oracle Reporting and Analytics for ERP
-
How to check Agent HistorySummary: How to check Agent History Content (required): As JOb history in BI shows executions of BI reports, do we have similar place to see executions of Agents ? Versi… -
OTBISummary: Hi Experts, I want to measure the performance for last 5 years, the year should be consist the data from July to Jun, instead of Jan to Dec. how I can convert t…
-
Getting an error while trying to open Supplier Master OTBI reportSummary: Unable to open Supplier Master report created in OTBI Content (required): Hi, I have created a supplier master report in OTBI with the fields such as Supplier N… -
What role or privilege do we need to access "Inherit Segment Value Attributes" ESS JobSummary: We would like to understand what role or privilege do we need to access "Inherit Segment Value Attributes" ESS Job. We tried searching for this in OTBI and "Man…Tawfeeq.Khan 11 views 1 comment 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP
-
Custom sort OTBI ColumnI have a column in my otbi analysis. They return me the values Exceeds Performance Expectations, Inadequate, Meets Performance Expectations ,Nearly there, No PMS Rating.…VDoolhur 135 views 8 comments 0 points Most recent by Anders W. Langholm Reporting and Analytics for ERP
-
Add Segment Description to OTBI ReportSummary: We have a report that uses the subject area General Ledger - Journals Real Time subject area, and we want to add the segment description for our 5 segment. We k…