Reporting and Analytics
Discussion List
-
Custom BIP report for Accounts payable trial balanceI am developing a Custom BIP report for Accounts payable trial balance. Here the paramters are legal entity, as on date and business unit. When I am trying to put the as…Ritu123 11 views 1 comment 0 points Most recent by Bodhisattwa Mukherjee-Oracle Reporting & Analytics for Fusion Service -
Analysis to monitor the average time of the CRM APIs response we consumeSummary: We would like to know how to create a report to monitor the average time of the CRM (Oracle Sales Fusion Cloud) APIs response we consume from all integrations. …Joan Rodriguez 25 views 2 comments 0 points Most recent by Umamaheswarareddy Ambati-Support-Oracle Sales
-
After migration of FR to reports is formatting issue where a row has expanded in height drasticallyAfter migration of FR to reports I have a formatting issue where a row has expanded in height drastically, but all row height parameters are correct. Any idea what could…
-
In partners, need the corresponding backend table and column name for Partner's Geographies Served.In partners, there is a column titled 'Partner's Geographies Served.' We need the corresponding backend table and column name. In BIA, we are currently able to retrieve …Vennela Valluri 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
how do you retrieve soc1 reportsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…PFreeman 73 views 3 comments 0 points Most recent by Mihai Nedelea-Oracle Fusion Applications Administration
-
query to get address number via SourceSystem and SourceSystemReferenceValue (address).Summary: query to get address number via SourceSystem and SourceSystemReferenceValue (address). Looking for table_name to get the values of SourceSystem and SourceSystem…
-
Sp HTTP 500/504 errors when using SOAP API in using BI PublisherSummary: My team makes calls every 30 minutes to BI Publisher through a SOAP API to retrieve information we need to update tables on an on prem database. We are making t…StefanyD 84 views 2 comments 0 points Most recent by Ankita Biswas-Oracle Reporting & Analytics for Fusion Service
-
How to get Audit Report of a Custom Object using Rest APISummary: To get Audit Report of a Custom Object using Rest API Content (please ensure you mask any confidential information): I want to get the Audit Report of a Custom …
-
Need to call "Print Movement Request Pick Slip Report" from Movement Request pageSummary:Need to call "Print Movement Request Pick Slip Report" from Movement Request page Content (required):Need to call "Print Movement Request Pick Slip Report" from …User_2025-03-08-03-49-56-344 13 views 3 comments 1 point Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM
-
Using Filters for Items with Rank Functions in BIThe Rank function is used to get the order of the employee numbers and divide the groups by 10's. Can I use this group for filters and prompts? Please let me know how to… -
Query to get ResourceOrganizationName of the userHi All, I am trying to extract resources/users with specific ResourceOrganizationName. I want to extract the ResourcePartyNumber and ResourceOrganizationName. Can you pl…Anj M. 16 views 1 comment 0 points Most recent by Topher Heath-Support-Oracle Reporting & Analytics for Sales
-
How to change the oracle AD account password without impacting the ESS JobsSummary: Hi , We have a requirement to reset the Oracle AD account using which most of the jobs are scheduled. So is there any option to change the password of the accou…cvidhya 32 views 8 comments 0 points Most recent by Alexandru Dicu-Oracle Fusion Applications Administration
-
Can we default multiple output formats while running standard reportSummary: Users want the report output to be generated by default in two formats - PDF and Excel for a standard report. These report formats need to be defaulted instead …User_3ZQZR 12 views 2 comments 0 points Most recent by Mihai Nedelea-Oracle Fusion Applications Administration
-
item inventory availability quantitySummary: how could build an report to retrieve the item availability quantity based on organization_id, sub_organization, item_inventory_id and lot number. Content (requ…Mohammad Hussein 118 views 2 comments 2 points Most recent by Iker Barragán Reporting & Analytics for Fusion Service
-
Item "Where Used" report in Oracle fusionSummary: Item "Where Used" report in Oracle fusion I want to prepare the data which tells this Item is used in all different work definition and its parent name. In EBS …Jignesh_HAE 31 views 3 comments 1 point Most recent by Manali Biswas-Oracle Reporting and Analytics for SCM
-
How to find all the relationship between contact and contact/account?Summary: Hi, How To get a report about the Contact/Account Relationships details with other contact/Accounts? can we get any SQL or subject area that can be used to fetc…
-
SQL Query for Data Model objects from OTBISummary: I am looking to perform a SQL query of Data Models from within OTBI and need to know which table to query. Content (please ensure you mask any confidential info…Alexinmn 421 views 3 comments 0 points Most recent by marcfromhawaii Reporting & Analytics for Fusion Service
-
where Knowledge advanced is in active use - understand the actual usage volumeHi, I need to create a report to review the current use cases where Knowledge advanced is in active use - understand the actual usage volume Regards, Meera
-
Is it possible to download a BI report PDF through API from a CRM Groovy script?Hello, We have a requirement to download a PDF from a CRM Service Request screen, when a button is clicked, so we'd like to know if it's possible to run and download a B…Eduardo Ortiz 21 views 2 comments 0 points Most recent by Eduardo Ortiz Reporting & Analytics for Fusion Service
-
Feature Friday: News Feed Home PageContent The News Feed home page layout is our recommended way for you to give your users a fast, easy to use home page. To help you understand and quickly switch to the … -
I need a custom script to capture a assigned time of a ticketHi, For a Response SLA report, we are capturing stop time as min(transactions.created). But there is a problem where incident reaches to wrong queue first and assigned t…Meera Saseendran T 35 views 1 comment 0 points Most recent by Michelle Akin-Support-Oracle Reporting & Analytics for B2C Service
-
How to create a report for find for each sla what all holidays are selectedHow to create a report for find for each sla what all holidays are selectedMeera Saseendran T 22 views 1 comment 0 points Most recent by Michelle Akin-Support-Oracle Reporting & Analytics for B2C Service
-
Add BIP parameter list of values to ESS Job ParameterThe list of values created in BIP Publisher Report needs to be displayed in the ESS Job parameter list.Kunwar Prashan Srivastava 31 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service -
Creating a Report for Unanswered Community Comments in RightNow CXSummary: We need to build a report in RightNow CX that highlights comments in our community that have not received a reply from a staff account. We have community profil…SDP 45 views 2 comments 0 points Most recent by Nika Gerson Lohman Reporting & Analytics for B2C Service
-
The specified criteria didn't result in any data - For Purchase Requisitions and PO Details ReportsSummary: We have created a custom role by copying it BI Consumer Role, We have also added the Purchase Analysis role under this custom role so that users can access the …Shabbir M Tahasildar 148 views 3 comments 0 points Most recent by Shabbir M Tahasildar Reporting and Analytics for SCM -
How to extract resource/user LDAP data?Summary: is there a way we can extract resource/user information from LDAP? as shown in the list below we encounter an issue similar to below question as a solution we n…
-
XMLPSERVERIn the XMLPServer section, can OTBI reports be seen, or are only BI reports visible?Emanuele De Marchi 15 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
how to trigger seeded version of the report if we have customization in BI reportswe customized Print Movement Request Pick Slip Report, and it's getting printed when we submit Pick Materials for Work Orders Report process. we have a requirement to ge…KabirB 21 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
How to get user who last updated an OTBI analysis?Summary: Hi, Some custom analysis are shared in a shared folder so that other users has access to it. Some users can only view the analysis, but some others may have per… -
In OTBI Analytics - How to export more than 75,000 records in Excel/CSV formatSummary: Currently in Oracle Transactional Business Intelligence, there is an export limit of 75,000 records in Excel format on a custom subject area we have created. Ar…Jay Patel-157091 126 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales