BI Publisher
Discussion List
-
Inconsistent Display of Chart of Account (COA) Segments in Expense Approval NotificationSummary: We are experiencing inconsistent behavior in the content of Expense Approval Notifications sent to supervisors and managers. The Chart of Accounts (COA) details… -
Oracle hcm cloud seeded reports what is the list of reports and their locationHello, I would like to know please, what is the list of Oracle hcm cloud seeded reports ? and where they are located ? for example : employee contact ,employee address ,…Revital Mefano 755 views 7 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Trade Reference Letter aka Credit Reference Letter - Available?Does Oracle have functionality to generate a trade reference letter aka credit reference letter? If so, from which module? I am not asking about a letter of credit but i… -
Fast Formula retrieving Date formatSummary: Hello experts, we built the following formula to retrieve a date to be used in compensation plan in date custom field. However, when testing it the attached err… -
Can we add parameters to the Standard ESS Job "Print Commercial Invoice Report"Summary: Hi Team, Business needs a parameter on the report which allow them to change the Title of the Proforma Invoice based on user selection like parameter Document T…
-
HCM Extract Email Bursting/DOR is getting failed when no data is returnedSummary: We have a requirement to burst the pdf file to employees and have the same added to DOR. When the extract returns data, the delivery option Email bursting and D…
-
Generate Nutrition Facts Panel / Label in Oracle Fusion CloudIs there a way to generate and print nutrition facts panels or labels in Oracle Fusion Cloud? Maybe using BI Publisher or other tools.Srinivas Somanchi 2 views 1 comment 0 points Most recent by Andrew_Schmitz Reporting and Analytics for SCM
-
Print Receivables Transactions – multiple invoices for same customer in one email or PDFSummary: We are using the standard Print Receivables Transactions job in Oracle Cloud ERP to generate and burst invoice PDFs to customers via email. The standard process…
-
Looking for guidance on custom email solution for Oracle Fusion - Receivables Print TransactionsSummary: We are currently using the standard Oracle bursting process (Job: Receivables Print Transactions) in Oracle Fusion Cloud Receivables to generate and email custo…
-
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 15 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…
-
How to handle single quotes within an if statement value in Oracle BI Publisher RTF templates?Summary: How to handle single quotes within an if statement value in Oracle BI Publisher RTF templates. Content (please ensure you mask any confidential information): To…
-
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 38 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 21 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 183 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
-
DML Operations like (Update,Delete) not working on ATPDB database table which is hugeSummary: DML Operations like (Update, Delete) not working on ATPDB database table which is huge. Archive table that is present where i want to do the operation and clear…Mahmoud Elbestawy 2 views 1 comment 0 points Most recent by Gaurav Kumar-100036 General Ledger & Intercompany
-
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 478 views 6 comments 0 points Most recent by User_IL4CK Reporting and Analytics for HCM
-
How to track email delivery status for the emails (invoice, dunning) sent to customers?Summary: Oracle Fusion Accounts Receivable (AR) sends high volumes of customer emails daily, such as Invoices, Customer Statements, and Dunning Letters. However, there i…
-
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…
-
Issue in fetching review_user_access column from PER_ALL_ASSIGNMENTS_M tableI’m trying to fetch the REVIEW_USER_ACCESS column from the PER_ALL_ASSIGNMENTS_M table in Oracle Fusion HCM, but I’m not seeing it populated. While terminating an employ…User_DNVLS 5 views 1 comment 0 points Most recent by Peeyush Chandel Reporting and Analytics for HCM
-
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…