BI Publisher
Discussion List
-
Do you need FDI to create new KPIs in new Purchasing icon?Summary: Hi Oracle community, I am following this link regarding the new Purchasing Icon application on the Procurement tab on the Oracle Fusion Homepage Link: https://d… -
subject areas Distributed Order Orchestration - Fulfillment Lines Real Time and Shipping Real timeI need to create prompt in OTBI with Aging days having case function defined, when running i am getting the below error, can someone help me on this CASEWHEN Timestampdi…Shahid Qureshi 01 12 views 2 comments 0 points Most recent by Shahid Qureshi 01 Reporting and Analytics for SCM -
How to remove special characters in the output of a e-text templatesSummary: We want to send all the open POs to a third party system in .txt format. The item description have a lot of special characters, how to remove it in the output w… -
In which bip table to find Administator conversation commentHello, I am looking into a way to report on the comment found in the page "administator conversation" in offering page. Could you please advise ? Thank you ! -
Accrual Plan Balance value for the future dateSummary: We are trying to fetch the accrual Plan Balance value for the future date records. Content (please ensure you mask any confidential information): As of now, we …ViswanadhK 46 views 4 comments 0 points Most recent by Peeyush Chandel Reporting and Analytics for HCM -
Oracle criteria to identify BIP reports with specific column in itHi All, We are migrating to V3 Seniority Date from V1 Seniority dates. This migration is impacting our BIP reports which are using ‘ORIGINAL_DATE_OF_HIRE’ column from 'P…Manikya H M 25 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Join GL and RCV_TRANSACTIONS in Fusion/ERP CloudSummary: HI All, We are looking a solution to create a SQL query for BIP report to Drill down Join from GL To RCV_TRANSACTIONS in Fusion/ERP Cloud where JE_Source='Recei… -
Is there any way to track Tile clicks by Users in HCM ?Hello Experts, Has anyone implemented or come across a supported method in Oracle Fusion HCM to track how often Home page tiles (e.g. Team Activity center) are accessed … -
BI Publisher Run report Rest API Call Unsuccessful.Summary Trying to access the Run Report Rest API for BI Publisher but without success.Content Hi there, I'm trying to run a POST request against the RunReport task withi…User_2025-02-05-10-38-08-223 189 views 7 comments 0 points Most recent by da.beretta Reporting and Analytics for ERP -
How To Join XLA_AE_HEADERS and RCV_TRANSACTIONS in Fusion/ERP Cloud?Summary How To Join XLA_AE_HEADERS and RCV_TRANSACTIONS in Fusion/ERP Cloud?Content How To Join XLA_AE_HEADERS and RCV_TRANSACTIONS in fusion? I could link XLA_TRANSACTI… -
How to display Success Criteria Text without HTML tags from Transaction tablesSummary: How to display Success Criteria Text without HTML tags from Transaction tables We have a requirement to display the Success Criteria Text in the report as plain…RajuT 34 views 2 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM -
Oracle HCM: How to change existing Host Key Fingerprint in BI AdministrationHi Team, We have a requirement to change the Host Key Fingerprint because of change in SFTP hostkey due to recent changes within SFTP application. Are we able to change …Chaitra Lakshmi Krishna 495 views 6 comments 0 points Most recent by User_IL4CK Reporting and Analytics for HCM -
We need a tables or Query to get Opt-in Features for Financial in oracle fusionSummary: Hi Team, Could you please provide us the Query or Tables to get Opt-in Features for Financial in oracle fusion. We could find the below table, but these are not… -
26A Upgrade | Learning | Impact on Database value changeSummary: I have identified a potential impact following the 26A upgrade, based on the Community post (https://community.oracle.com/customerconnect/discussion/948343/data… -
Course/Offering Status Code Change Impacting BIP Report Output Across EnvironmentsSummary: We created a BIP report in DEV2 using the status codes ORA_COU_ACTIVE (Course Status) and ORA_CLS_ACTIVE (Offering Status). The report had been working correctl… -
How to add custom archival data to the GTN report?Summary: A customer needs to add custom deductions to the Gross to Net summary report, just as they can in the Payslip, which include this feature. The XML does not cont… -
Turkey E-ledger requirementSummary: Hello Team, Our customer requires Turkey E-Ledger report to be developed as part of Turkey Localization. Please check and let us know if we have any out of box …Narayanan M S-Oracle 56 views 3 comments 0 points Most recent by AndresGlz2109 General Ledger & Intercompany -
Restrict Quick Payment and Allow only Manual PaymentIssue: There ate no apporvals for Payments created via create payments tab. So, Business wants to restrict the users only to make manual payments from Create Payments Ta…Jagjit Singh Arora 403 views 8 comments 0 points Most recent by Sampath Kamtala Payables, Payments & Cash Management -
Is it possible to see the Old Value and New Values for Project Management Changes in Audit Data?Summary: I am trying to identify Project Management changes in BIP tables, specifically Project Org or "CARRYING_OUT_ORGANIZATION_ID" . We need to include the historic d…Kimberly Showman 24 views 2 comments 0 points Most recent by Kimberly Showman Reporting and Analytics for ERP -
How to restrict users from accessing cost centers that doesn't belong to them in FRS?I enabled a Segment Value Security Rule to restrict users from seeing cost centers that don’t belong to them. The users are correctly restricted in the Journals area — t…Jibin 13 views 1 comment 0 points Most recent by Global Oracle Support-Oracle General Ledger & Intercompany -
Download Excel template BIP Report using SOAP Web ServicesSummary: We are currently using the following two web services to schedule and download BIP reports: soapWsdlUrlSchedule: https://{instance-name}.oraclecloud.com/xmlpser… -
Tables to pull the data for the eligibility profiles under compensation profile usage.Hello Team, The requirement is to pull the data for the eligibility profiles under compensation profile usage which are assigned to grade ladder. Please suggest the tabl…Saurabh_Mharolkar 96 views 18 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Supplier master Alias name tableSummary: Need a query to get the Supplier master Alias name Content (please ensure you mask any confidential information): Hi, we are maintaining some naming conversion …Mamdouh Ahmed 13 views 2 comments 0 points Most recent by Mamdouh Ahmed Reporting and Analytics for SCM -
Can you send me a sample of email notification for payment approval workflowWe are not yet using the payment approval workflow. I only want is to see the format or template and details when we received the notification for approval.GRACE SORIANO 2 views 3 comments 0 points Most recent by Venkatesh Padamwar Payables, Payments & Cash Management -
Standard report to see the default expense account of an employeeSummary: The client is looking for any standard reports to check the default expense account assigned to an employee Content (please ensure you mask any confidential inf… -
Can we customize Print Receivables Transactions report Bursting query from emai To FTP/SFTP ?Summary: Client requirement is to receive AR transaction PDF to FTP location rather sending it via email so want to customize Print Receivables Transactions Bursting que…RupaliGahalot 327 views 17 comments 0 points Most recent by User_NF6P4 Reporting and Analytics for ERP -
Image in Email Body of BI bursting query along with static AttachmentSummary Image in Email Body of BI bursting query along with static AttachmentContent Hello All, I have a report that needs to be bursted I have a static attachment in it…AvishekNandi 538 views 5 comments 0 points Most recent by Amit_Ekbote Reporting and Analytics for HCM -
P60 reprint blank in document records but showing in flow correctlySummary: An employee had set their document delivery preferences to not have an online copy for a P60 produced. This resulted in the employee not having a P60 created in… -
Payment method details in the tables on the providersSummary: I need to identify which Oracle Cloud Fusion table stores the “Default” and “Payment Method” attributes within the Payments section of a supplier's main site (s…Cristian Rojas 39 views 3 comments 0 points Most recent by Md_Anees-Oracle Payables, Payments & Cash Management