To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for ERP
Discussion List
-
eText BIP Template inserting blank row at top of output fileSummary: eText BIP Template inserting blank row at top of output file Content (please ensure you mask any confidential information): Hello, We have a BIP eText template … -
I have created one BIP report, Output is .csv file. I am getting String values in Double Quote.Summary: I have created one BIP report, Output is .csv file. I am getting String values in Double Quote. I want to have the values without double quotes. I have tried it…
-
About the table having Segment HyerarchyI want to use information about Segment Hyerarchy in GL with BIP but I am not sure which table I should refer to. If you know, please let me know.
-
BIACM data models not returning any valueSummary: We are building a data warehouse and needs to utilize the default models provided by Oracle via BIACM to extract values needed for this project. When started wi…
-
Moved: Project Budgeting is done at resource level or task levelThis discussion has been moved. -
sql query or table name for Manage Account RulesSummary: Hi team, We need a table name or SQL query to get fields for the values type and values under the setup Manage Account Rules Content (please ensure you mask any…
-
Hide Data Models from BI Author and BI Consumer Roles - Access Impact?Summary: Content (please ensure you mask any confidential information): We want to remove the BI Author and BI Consumer roles from any folders that just contain data mod…
-
How to Insert/modify targets in main dashboard OTMSummary: Hi, I'm opening this ticket by suggestion from OTM CCC discussion: Is it possible to insert or update targets values in the main dashboard page? We have try to …
-
How to get count in pivot table in rtf templateHow to get count in pivot table in rtf template
-
Which table contains future budget period amount details?Summary: Hi Experts, We need to retrieve budget amount, actual amount and commitment amount for future budget periods for a report, these are the fields we see in the be…
-
How to have a fixed table for stub before check regardless of the number of invoicesSummary: We have a business requirement to create a custom in-house check wherein the remittance table is causing the check to shift and overflow to the 2nd page. We nee…
-
Any one has idea on Pivot table in rtf, need some help on itAny one has idea on Pivot table in rtf, need some help on it. It is allowing only 5 columns, can we extend it more than 5 columns and also grouping data , need it to be …
-
How can I add the from date of a role and the user that gave the role to a report?Summary: I am looking to add the date a role was given to an employee and who gave the employee that role to a report for security. The date would be the auto populated …
-
display hyperlink in messagesHello I am creating a new message from Manage messages and I am retrieving this message from BI query. I would like to have a hyperlink in the message when I am creating… -
while creating the custom roles, getting unwanted subject areas in analysisSummary: Hello Experts, Our client has a requirement to create a custom role for restricted access to business users. While doing so, we could see in reports and analyti…
-
How to give Unarchive option in Custom folder which is read only for a user in BI Catalog?Summary: We have a custom role which gives read only access to the Shared Folders > Custom folder. We also want to provide Unarchive access under the Custom folder. The …
-
performance issue in transaction listing reportSummary: I am trying to optimize the performance of GL transaction listing report. It is taking longer time to load the report & after 30 mins it is getting failed while… -
How to split the selected areas of the BIP Excel sheet into different sheets according to numberSummary: Is there a way to split the selected areas of the BIP Excel template sheet into edifferent sheets according to number? Content: Hi, we are trying to build BIPub…
-
How to Format a Date Column to include Time Stamp in BICC Extract OutputSummary: Hi, I am trying to extract fusion table data using BICC, and I am seeing when the data is exported the date fields doesn't have the time values in it even thoug…
-
Request for Information on Managing Budget Versions Approver details in fusion TablesSummary: I am currently working on a requirement to display the approver's name and the submitted person’s name for budget versions in our Grant Management system. Howev…
-
How to Display Date and Time as per User Preference in Excel TemplateSummary: Not getting data as per the user general Date Format/Timezone preference in EXCEL template for BIP report Template build in RTF, is working fine as per User Pre…
-
incorrect result when calculated measure by multiplying 2 columnsSummary: multipying revenue amount with ledger amount is giving incorrect results Content (please ensure you mask any confidential information): External Revenue Amount …
-
OTBI Agent - Invoke an HTTP RequestSummary: While invoking an HTTP Request as an Action from Agent, receiving below error in Fusion ERP Cloud. Could you please provide steps on how to resolve this in Fusi… -
Drill down query for GL->XLA->AR(Receipt Category)Drill down query for GL->XLA->AR(Receipt Category). I have a custom report where I have to pick the details from GL_JE_Lines tables, and RA_CUSTOMER_TRX_ALL, AR_CASH_REC…
-
FTP Files of BI Publisher Report Via Bursting > Defining The Bursting QuerySummary: FTP Files of BI Publisher Report Via Bursting > Defining The Bursting Query Content (required): Hello All, We would like to send a report generated in CSV forma…
-
Add Supplier Name in Account Analysis ReportSummary: Would it be possible to add a Vendor Name column under the Account Analysis Report for all source related to Payables and Receipt Accounting? We have a custom r…
-
Moved: I am looking for a database table from oracle fusion for resourc override screen from work e…This discussion has been moved.
-
Project List Details OTBI report not showing any DataSummary: Project List Details OTBI report not showing any Data. Custom role is configured with all the below required duty roles Project Performance Reporting Transactio…
-
can we hide a WF Notification hyperlink with BIP and RTF template based on a security roleSummary: HI Reporting and Analytics forum esp BI Publisher gurus: Is there is an easy way to hide a URL hyperlink on a Notification page (RTF BI Report -side) also based…
-
ESS.REQUEST_HISTORY table state column meaningin which oracle fusion financials, Fusion_ORA_ESS.REQUEST_HISTORY there is a columns named 'State' which shows 12,11,10 values. What is meaning of it. It seems that ESS …