Category 385
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 -
How to extract the supplier information when few columns are not available in API.We have used the below two API to extract the supplier information. We observed that few columns are not available in API. API Used: https://eiiv-dev46.fa.us6.oracleclou…Vidmahi Kammari 21 views 1 comment 0 points Most recent by Shaik Nayab Rasul-Oracle Supplier Management
-
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 62 views 2 comments 0 points Most recent by Ankita Biswas-Oracle Reporting & Analytics for Fusion Service
-
Performance Issue After Joining EGO_ITEM_EFF_B on the basis of CHANGE_LINE_ID. Any solutions?Hi, I’m working on a query that previously ran within seconds, but after adding the lastLEFT JOIN, the execution time has increased significantly—even for a single chang… -
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 …
-
course usage reportHello, I would like to create a report to see course usage to potentially achieve trainings that have not been used for a while. Any suggestions on how to create this re…Sara.Zhao 11 views 1 comment 0 points Most recent by Abdul Rauf Mohammad-Oracle Reporting and Analytics for HCM
-
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 85 views 2 comments 2 points Most recent by Iker Barragán Reporting & Analytics for Fusion Service
-
What is Oracle Fusion alternative for rowset and columnset used with FSG reports in Oracle EBS?Summary: In Oracle EBS, FSG Reports maintenance was quite simple. We used to maintain rowset and column sets. We can combine any rowset and columnset to form a FSG repor…Tuheen Mann 41 views 3 comments 0 points Most recent by Anca A-Oracle Reporting and Analytics for ERP
-
Where is the data that is temporarily stored in ZX_REP_TRX_DETAIL_T coming from?Summary: Hello, We wanted to do a fully customised version of the Financial Tax Register report since we needed more flexibility due to the business requirements. We wan…
-
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,…
-
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 271 views 3 comments 0 points Most recent by marcfromhawaii Reporting & Analytics for Fusion Service
-
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
-
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 -
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 21 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 …
-
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
-
How to replace special characters in etext templateIn one if the interface (HCM extract) we are using DBI item as 'Bank Account Name'. For one of the records, it is bringing the special character as Esmé but we need Esme…
-
Custom ESS job is running long for one particular userWe have custom ESS job which is running long for one particular user. For other users it is completed in 3-5 mins for the same parameters.(Both users are having same set…Thanigainathan R 3 views 1 comment 0 points Most recent by Razvan Paduraru-Oracle General Ledger & Intercompany
-
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
-
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
-
invoice_id is blank in ap_trial_balances_gt tableHello All, We have a requirement to create a custom Payables Trial Balance Report by copying and customizing the data model to add more columns from ap_invoices_all tabl…DebasmitaDas123 31 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
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
-
How to call a query or data of one particular data model to another data model.We have a requirement to get gross salary details in many BI Reports. We need to know that is there any feasibility to call one data model related data in another data m…Nalsoft Pvt Ltd 12 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
How to Resync Arabic Hijrah Calendar in Oracle FusionWe are experiencing discrepancies in the dates within Oracle Fusion, specifically with the 'Arabic Hijrah calendar'. leading to issues with reports using Hijri Date. The…KirolosMagdy 83 views 2 comments 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM