Category 385
Discussion List
-
Issue with OTBI – General Ledger Journal Real Time DashboardWe are currently experiencing an issue with the OTBI – General Ledger Journal Real Time Dashboard. Specifically, some of the accounting segments are not visible in the d…Kinjal Patel-Oracle 31 views 1 comment 2 points Most recent by KetanJ-Oracle Reporting & Analytics for Fusion Service -
Is it possible to schedule ESS jobs in bulkWe currently have around 1,500+ ESS jobs, and we are looking for a solution that would allow us to schedule these jobs in bulk. All relevant job details are stored in an…deepmehta-Oracle 31 views 2 comments 3 points Most recent by deepmehta-Oracle Reporting & Analytics for Fusion Service
-
PO PDF templateWe have created a custom PO PDF template for the customer The user is able to download any PO PDF when the document amount < = 999 $/Rs/Euro(Any currency) But for amount…Kinjal Patel-Oracle 21 views 1 comment 1 point Most recent by deepmehta-Oracle Reporting & Analytics for Fusion Service
-
Question regarding the mandatory 'Enhanced Time and Absence Integration' feature with 25BWe were recently acquired by a company and are no longer processing new payrolls - we're just maintaining our Oracle data for historical reference. Prior to the acquisit…Greg Aulson 71 views 1 comment 0 points Most recent by Anca Andronic-Oracle Payroll and Global Payroll Interface (GPI)
-
Time is being omitted in OOTB ESS Job Employee Vacation and Delegation Rules ReportHello, Does anyone know why the time from XML output of the report gets omitted? When we set a vacation rule in BPM, it includes both date and time. We need the time sin…Peps 51 views 4 comments 0 points Most recent by User_CHLT4 Reporting & Analytics for Fusion Service
-
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 81 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 11 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 11 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 32 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 22 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. 21 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 11 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 25 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 11 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 11 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 11 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 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 61 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…