Reporting and Analytics
Discussion List
-
While I am using (AP_INVOICES_PKG.GET_POSTING_STATUS( aia.INVOICE_ID ), the query is processing onlyWhile I am using (AP_INVOICES_PKG.GET_POSTING_STATUS( aia.INVOICE_ID ), the query is processing only and at least I am getting timeout error. Here is my query. Can you p… -
Roles/Previlage Usage-Remove unused Roles /Previlages from the UsersWe need the Report to extract the below Details to Remove unused Roles /Previlages. Example : 1.Role Usage : When is the Last date Role used by the User ( For example: I…JAGADEESH DS 31 views 6 comments 1 point Most recent by Andrada-Oracle Fusion Applications Administration
-
which field should I use for the Validation Status of AP Invoices?I am creating the Data Model of our BIP Report and I need to find out which field from what table should I use as Validation Status.Alvin 22 views 1 comment 0 points Most recent by Bodhisattwa Mukherjee-Oracle Reporting & Analytics for Fusion Service
-
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 21 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 71 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 11 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. 11 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 31 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 11 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 114 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 36 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 367 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 31 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 34 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 41 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 74 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 https://community.…
-
XMLPSERVERIn the XMLPServer section, can OTBI reports be seen, or are only BI reports visible?Emanuele De Marchi 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales