BI Publisher
Discussion List
-
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 43 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 26 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 188 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…
-
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 520 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 51 views 3 comments 0 points Most recent by AndresGlz2109 General Ledger & Intercompany
-
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 46 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 33 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 114 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 14 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 5 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 349 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 564 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 61 views 3 comments 0 points Most recent by Md_Anees-Oracle Payables, Payments & Cash Management
-
How to read csv from content server?Summary: Content (please ensure you mask any confidential information): I need to show in report results from csv uploaded in content server, what is the table to query?…Stefano_Mazzocca 4 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Invoice Approval Notification: Task details aren't available for this task. (FUN-720809)Summary: Our Invoice approvals are based on mail & one user has been getting "Task details aren't available for this task. (FUN-720809)" & notification is empty without …Sujatha Kumari 92 views 7 comments 0 points Most recent by Larissa Meid Payables, Payments & Cash Management
-
SQL query to get position in performance documentSummary: SQL query to get position in performance document Content (please ensure you mask any confidential information): Could you please advise on the SQL query needed…
-
Need Help on Source Table for Manage Common Options for Payables and Procurement:Summary: need to find table for Manage Common Options for Payables and Procurement. want value for default distributions -liability, prepayment Content (please ensure yo…