Analytics
Discussion List
-
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 11 views 2 comments 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
FDI to AWS Redshift connectionWe are trying to connect OCI FDI (Fusion Data Intelligence) instance to AWS Redshift instance for getting data from AWS Redshift (behind a VPC and not publicly accessibl…
-
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 21 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 51 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 41 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 84 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 12 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 21 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
-
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 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 …
-
Anyway to tag courses besides skills?Is there a way to tag courses that could be used to group courses together without skills? If sills is the only way , where in OTBI can you bring in skills associated wi…
-
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…
-
How to download .PDF attachment from Contract through BIP report in fusionDears, We have a requirement to download .pdf attachment from contract. How we can download the above attachment (24000065-1 (1)نسخة التوقيع.pdf) from BI report. Thanks,…
-
REST API for FDI Fusion Data IntelligenceSummary: REST API for FDI Fusion Data Intelligence to GET the information of users, groups, application roles, and data access Content (please ensure you mask any confid…
-
is it possible to have access for specific entities in FRS report(income statement)?Dear all, Kindly find the below: the client want to have access in the FRS income statement for each entity to not show all the income statements available in the financ…Anthony Sleiman 31 views 1 comment 1 point Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
how to edit Supplier negotiation invitation email subjectSummary: I need to change/edit the supplier negotiation invitation email subject which is sent to suppliers to invite them to negotiation. Content (required): I need to …
-
Foreign key Column & Foreign Table for GL_JE_ACTION_LOG table using HISTORY_IDWe are not able to find the join for GL_JE_ACTION_LOG using HISTORY_ID field. I can able to see in Oracle Docs that HISTORY_ID is the Unique Identifier assigned to user …
-
How to get the URL to consume a report in Oracle TransactionalSummary: In transactional Oracle I have different reports, I use OIC to consume these reports to obtain the data, how can I get the URL to consume it via http? Content (…
-
OTBI Prompt to control AORIn OTBI, can we control the prompt list of alues based on area of responsibility. Example - if the employee is tagged to abc, xyz & 123 legal entity, then when opening t…Suganya v 11 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
Change time frame (Last 30 Days) in Help Desk InfoletsSummary: The requirement is to change the time frame for the data shown in the Help Desk Infolets. How to change the "Last 30 Days"? Content (please ensure you mask any …Swetha J Nair 41 views 4 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
Export Material plan into Excel for all items to review supplies, demands and net inventoryHi there, We are looking for the ability to export the 'Material Plan' view in Fusion into Excel for all items. Issue we are hitting is the 'Material Plan' view does not…Tom Harris 31 views 2 comments 0 points Most recent by Sandeep Pati-Trinamix Supply Chain Planning and Collaboration
-
How to pick delivery method (online or offline) on the report defined in development goal pageOn the development goal page we have attached the course as a training and that course has DFF of online training or offline training defined on create course page, now … -
ORC Job Offer Letter has got a different font than the RTF Template.Hi Team, I am currently facing an issue on the Job Offer letter in ORC,the customer is using their own custom font style for branding purpose. I am using the same font s…Beatrice C 31 views 1 comment 0 points Most recent by Patricia-S-Oracle Recruiting, Opportunity Marketplace
-
Case Management OTBI FieldsSummary: Is there a list of Case Management OTBI fields that are reportable? This would be extremely helpful so I don't have to keep endlessly digging. I've been able to…
-
How to display the content of the PO PDF document in the Email body of the Approval NotificationApart from getting the attachment as a PDF, need to display a few columns in the email body as well
-
Seeded report in HR HelpDesk is not referring correct attribute in Filter criteria.Summary: Under /shared/Service/Embedded Content/HR HelpDesk Agent/_portal , there is a seeded Dashboard Average Time to Resolve My Closed SRs which is having single anal…
-
How to get same data in two data sets in the same data model without any data model link.We have 2 different data sets in the same data model, and we have a common column in both the data sets but without a link. Can we get same data based on the common colu…Nalsoft Pvt Ltd 11 views 2 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM