Analytics
Discussion List
-
Query to get the prepayment Amount ValuesSummary Dear All, I am creating a BIP report, In which I need to calculate the number of employees processed in the payroll run and sum of total amount in processed in p…VaibhavChavan20_ 127 views 1 comment 0 points Most recent by VaibhavChavan20_ Reporting and Analytics for HCM -
Unable to join Purchasing and Receipts subject areas in OTBIWe have a requirement where we need to create an OTBI report with Purchasing Order and Purchase Order Receipts information like Purchase Order Number, PO Line Number, PO…vikram khengare 27 views 2 comments 0 points Most recent by Teresa Meyerhoeffer Reporting and Analytics for SCM
-
Need to pass value from SaaS page To BIP ReportSummary: Hi We have added Highlighted Hyperlink to Call BIP Report. We are able to call BIP report but need few points in it. Need To pass Request from SaaS to BIP Repor…
-
Where can I find reference Columns of Supplier site purposeCan anyone help with query to find out the above red marked field for oracle site purpose flag as sourcing only. Thanks in advance -
Did oracle will allow to trigger bursting email to 60K candidates at once?Hi Team, We have requirement to trigger bursting email notifications to 60K candidates. Did our fusion application will allow to send notification to the 60K employees a…MaheshRayudu7 8 views 1 comment 0 points Most recent by MaheshRayudu7 Reporting and Analytics for HCM
-
Send a Document of record as attachment through OTBI analysis output via emailDear All, We want to send by mail the output of an OTBI Analysis we have, but we need to send with it an attached file. The file that we need will be the CV of an employ… -
Parameters and lists of Value in the analysis are not inherited into the BI Publisher Data ModelHi, Expert I encountered the case that I developed an Analysis and Prompts within it. Subsequently, I built a new Data Model, designating the Analysis as the dataset, bu…ICE Pratchapon 68 views 1 comment 0 points Most recent by ICE Pratchapon Reporting and Analytics for HCM
-
OTBI drilldown to a Custom object detail pageSummary: I want to configure a drill down feature in my OTBI analysis to open the application detail page for the selected object. But, my action link opens only the obj…Curtis Allen 16 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service -
How to Create a Data Set Using a Web Service in Oracle FusionHi Experts, I tried to create a data set in BI Publisher using a web service that returns valid XML data. I referred to this document: Creating a Data Set Using a Web Se…Krishan_Palihakkara 40 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service
-
I have build the report using service request object with custom subject area but getting error.Summary: I have build the report using service request object with custom subject area and trying to map the reference number to SR number (custom object custom field) b…Manjula Bellamkonda-Oracle 17 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service
-
Fusion Data Intelligence - System settingsHello, Trying to do some configuration for the Oracle Data Intelligence, and when I'm logged in and go to the Console and System Settings. It says I don't have permissio…BenSayers 58 views 3 comments 0 points Most recent by Baskar.Chakravarthi Fusion Applications Administration -
Sql query or Table name for Offering and Functional area for Opt in features in Oracle fusionSummary: Hi Team, We are stuck to find the table or query for Functional area and Offerings. Navigation: My Enterprise → New feature or Offerings. We have the below tabl…Opkey PA 95 views 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting & Analytics for Fusion Service
-
Report data size exceeds the maximum limit (524288000 bytes). Stopped processing.Summary: I am building a custom report - Payable Trail abalance. But while running the report, I am getting Report data size exceeds the maximum limit (524288000 bytes).…Ritu123 178 views 3 comments 1 point Most recent by Erick.B Reporting & Analytics for Fusion Service
-
Print Labels on Zebra Printer from Oracle FAW - BIWe have a requirement on printing labels to Zebra printer. We are sending the print command from FAW-BI to CUPS and CUPS to Printer however it is not getting printed. Po…Pawan Deep Singh 4 views 3 comments 0 points Most recent by Pawan Deep Singh Reporting and Analytics for SCM
-
Getting Duplicate data on performance and goalsGetting Duplicate data on performance and goals when employees checking from Me >> Performance >> Employee is able to view the list of goals of other employees from his …Shivani Karna 37 views 1 comment 0 points Most recent by Soumya Suravita Reporting and Analytics for HCM
-
Can I have multiple logos for 1 only income statement FRS report?Kindly find the below: The client want more than one logo used in the same income statement created in financial reporting center is there any way? thanks for help, Rega…Anthony Sleiman 49 views 2 comments 1 point Most recent by Abdelrhman Samy General Ledger & Intercompany
-
How to restrict the access folder level in BIP ReportsCould you please advise if there is an option to grant the permission only one folder (Eg: Pyables Custom) . We’re looking to ensure users cannot view or access for any …Linga Murthy 13 views 2 comments 0 points Most recent by Linga Murthy Reporting & Analytics for Fusion Service
-
I want to restrict last line of any receipt line to be printed in EDI Etext template for the clientWe have 2 new BIP report enhancement requirement To restrict every receipt's last line to be restricted in the query, please see screenshot below for your reference the …Shahid Qureshi 17 views 2 comments 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Feasibility of Dynamic Conditional Account Insertion in Financial Reporting Studio (FRS)We are implementing a financial report in Oracle Financial Reporting Studio (FRS). The business requirement is as follows: Based on the sum of two accounts (18600000 and…Patrick Chrabieh 30 views 1 comment 0 points Most recent by Razvan Paduraru-Oracle General Ledger & Intercompany
-
Getting not a group by function for the query in BIP reportGetting : ORA-00979: not a GROUP BY expression for the query in BIP report. Below is my query I am getting this errow while adding any sub query(Payment Terms). In the g…
-
How download a BI report in PDF Output using Smart Action on redwood page?Summary: On a CX Sales Redwood page, we’ve added a “View PDF” smart action button. The requirement is that when the user clicks this button, it should trigger a BIP (BI …Ashu Singh 53 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service
-
Query to get Applied prepayment amountSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Ritu123 42 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service
-
How Can I Show BOM Level Information for Each Item in a Report?I’m encountering an issue and would appreciate some guidance. I need to display the BOM in the report with the level information, and I’ve attached a picture for referen…Dinar 80 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Offer details are not getting stored in transaction table (HRC_TXN_HEADER)When an offer is sent for approval and after approval if the offer is "Re drafted" and edited then the table "IRC_OFFERS" is storing the latest data. Whereas i need to f…Nalsoft Pvt Ltd 17 views 0 comments 0 points Started by Nalsoft Pvt Ltd Reporting and Analytics for HCM
-
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…
-
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 20 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 17 views 1 comment 0 points Most recent by Bodhisattwa Mukherjee-Oracle Reporting & Analytics for Fusion Service
-
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 73 views 2 comments 0 points Most recent by Ankita Biswas-Oracle Reporting & Analytics for Fusion Service
-
How to Configure Request Payload for POST Method in BIP DataModelHello Oracle Community, I am currently working on a project where I need to invoke a REST API from a BIP DataModel/Report. However, I'm facing an issue with configuring …
-
How to fetch Additional Communication settings under Recruiting Messaging Configuration in sql queryHi Team, We are unable to fetch Additional Communication settings under the task "Recruiting Messaging Configuration" in oracle table. Could you please help us in fetchi…