Category 385
Discussion List
-
Query to fetch absence plan balance history detailsHi Experts, Greetings of the day!! We have a requirement to get all the absence plan balance history details. We need all individual entries like Periodic accrual, Carry…Divya Kollipara 80 views 4 comments 0 points Most recent by Neno Kolonich Reporting and Analytics for HCM -
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
-
Cycle count adjustmentI have to make an cycle count history report BU wise – for this I am using INV_CYCLE_COUNT_ENTRIES table, in the frontend when i am checking the data for Transaction Typ…
-
FLA to GL tables join to display vendor detailsHi, For an account analysis BIP report, I want to link the FLA table and GL tables to display the vendor details. But I am not able to join Can you assist? Thanks and Re…Venkatesh Thanniru 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
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 12 views 2 comments 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
We need a dynamic GIF Image send over emailWe need a dynamic GIF Image which is like a video image to be incorporated and send over email to employees on their birthday.Shaarif_Hussain 1 view 2 comments 0 points Most recent by Loo Alex Reporting & Analytics for Fusion Service
-
**SOLVED** How can I get Manager grade step to display in OTBI?I have a requirement to include the grade step of managers in a report I am building however there doesn't appear to be anything available out of the box for this. Does …Rob Ward 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Need a report which lists all reports with roles required to run thoseIs it possible create a report that lists all reports in fusion Financials and the security role that is required to run each of these reports. Business is asked constan…Vinay414 33 views 1 comment 0 points Most recent by Razvan Paduraru-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 25 views 1 comment 0 points Most recent by Razvan Paduraru-Oracle General Ledger & Intercompany -
BIP reports usageSummary: Is that possible to run a BIP report that show all BIP reports that have been running in our POD? We know we can see the scheduled reports in ESS table but we a… -
Payroll Report Pulling Wrong Assignment Manager in BI ReportI'm working on updating a Payroll Last Row Validation Report. It is currently pulling the wrong assignment manager for the last effective dated change on their employmen…Nicole A. 22 views 6 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
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…
-
Page Break function not working for excel(MHTML) output formatHi Team, The customer wants to redevelop the Excel template report (with multiple tabs) into an RTF template, as the Excel template only displays 65K records per tab. We…Somasekhar Basetty -Oracle 12 views 1 comment 0 points Most recent by User_ITP2X Reporting & Analytics for Fusion Service
-
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 23 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 13 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 61 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 14 views 0 comments 0 points Started by Nalsoft Pvt Ltd Reporting and Analytics for HCM
-
Data is not showing up in the RTF templateI am developing LMAR debtors ledger report. In the RTF template the closing balance data is not coming. Even if the header part is not coming. I am attaching the Report …
-
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 12 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
-
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 23 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 12 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 90 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 47 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…