BI Publisher
Discussion List
-
what is the equivalent table in Oracle fusion for wf_notification table in EBSSummary: We are looking to build a report to get approval details of delegated approvals . E.g: Workflow type, original approver , approved by , Approval Date Etc. Conte… -
How to fetch the survey section from Performance DocumentHello Experts, Does anyone know where in the tables to fetch the Survey section from performance document? Please Help! TIA
-
Query to get Scheduled BIP Jobs in Oracle Fusion HCMHi All, Is there a way to retrieve the schedule details of BIP reports like job name, report name, schedule start date, schedule end date, frequency etc. using a sql que…Dhanuka Chamal 1.3K views 4 comments 5 points Most recent by gclampitt Reporting and Analytics for HCM -
recommendation profiles to analysis report mapping table in BIPSummary: We are trying to build a report to show the "recommendation profiles" and their linked "Analysis Reports". But it is not always there in wlf_recom_context table…
-
How to hide Common Content folder under Shared Folders on BIP Catalog pageSummary: Before the quaterly patch 25A, system did not show "Common Content" under Shared Folders on BIP Catalog page. But somehow system shows "Common Content" under Sh…Tomoyuki Hyakutake-Oracle 93 views 5 comments 1 point Most recent by Nathan CCC Reporting and Analytics for ERP
-
BI tables for standard compensation plan columns regarding salarySummary: Content (please ensure you mask any confidential information): Hello experts, which BI tables store the following standard compensation plan column fields? New …Valerio Curzi 32 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
UI End-Date and Database Records for Bank AccountsSummary: Hi everyone, I recently inactivated a bank account using the checkbox, and now I see a mismatch with the end date. The UI shows it as 01/07/2025, but the tables…
-
Query to fetch Approvals Groups Across Workflow ModulesSummary: We need to update a workflow approval group. I’d like a query that shows, by module, every workflow rule that will be affected by this change. Exemple: Approval…usr_a.nv 41 views 6 comments 0 points Most recent by Kate D.B-Oracle Payables, Payments & Cash Management
-
retrieving timestamp is not giving correct date and timestamp from Table PER_EXT_APP_IDENTIFIERSSummary: retrieving timestamp is not giving correct date and timestamp from Table per_ext_app_identifiers Content (please ensure you mask any confidential information): …
-
Repeating Groups - Excel Template BI PublisherSummary: Hi, I am trying to create a PO History Report and I am wondering if there is an easier way to group the data by a specific PO? Right now I have PO Number and PO…Simranjeet Singh 136 views 2 comments 0 points Most recent by missy_21 Reporting and Analytics for HCM
-
HDL - DeleteSummary We are trying to remove Matrix Managers via HDL; but DELETE removes all historyContent Hello! We are implementing Matrix Managers and I've been tasked with updat…User_2025-01-23-21-24-21-434 117 views 5 comments 0 points Most recent by Jagdish Kolli Reporting and Analytics for HCM -
Query to fetch the CARRIER_NAME, DELETE_SOURCES and DELETE_EXCLUSION for Sourcing RulesHi Everyone, Can you please help me with the SQL query or the Fusion tables/columns required to fetch the following fields for Sourcing Rules in Oracle Fusion Cloud (25D…
-
Can we submit ESS job using BIP Report ??Summary: Can we submit ESS job using BIP Report ?? Content (required): Can we submit ESS job using BIP Report by setting data set as Procedural call ? Version (include t…Sandeep19rm 51 views 8 comments 0 points Most recent by Ranga Swamy Ediga Reporting and Analytics for ERP -
AP Check print squares instead of MICR Numbers at bottom of the CheckSummary: AP Check print squares instead of MICR Numbers at bottom of the Check BIP Report = Downloaded the Disbursement Payment File Formats Shared Folders > Financials …
-
Issue with Views in HCM cloud Learning Management (WLF_LRNR_COMPLETION_DETAILS_V) in SpecializationSummary Joins are missing in the Specialization item type part in the Views WLF_LRNR_COMPLETION_DETAILS_V and WLF_LRNR_COMPLETION_SUMMARY_VContent In the code of the vie…Rajesh Ravikumar 58 views 3 comments 1 point Most recent by R Ravichandran Reporting and Analytics for HCM
-
How can I schedule a BI Publisher report with dynamic date parameters for the previous 3 months?Summary: We have a report used by many business areas. One particular business area would like to schedule this report to pick up the previous 3 months of data. How can …Holly Wells 1.5K views 10 comments 0 points Most recent by Neil Wanags Livingstone Reporting and Analytics for ERP
-
Import Oracle Fusion Data Extensions for Transactional Business Intelligence having an impact.Summary: There's an issue with HCM Reports having said that some columns were not available and the root cause of it was when Import Oracle Fusion Data Extensions for Tr…Franz Marcelo 978 views 8 comments 1 point Most recent by Rich Merkel Reporting and Analytics for ERP -
Enabling Pay Group in Payment File - 23A FeatureSummary: Reviewing some earlier What's New Features - I came across this in 23A: VAT PAYMENT IN LOCAL CURRENCY FOR POLAND FOREIGN CURRENCY INVOICES As part of this - I n…
-
Headerless csv output in oracle fusion BI reportingSummary: Hi Team, We have a requirement to get the extract in CSV format without header fields in the Oracle BI report. Content (please ensure you mask any confidential …
-
SQL Query to get Approval group name , approval sequence for General Ledger in Oracle FusionSQL Query to get Approval group name , approval sequence and Business Node for General Ledger in Oracle FusionChitti Damoder 31 views 5 comments 0 points Most recent by Chitti Damoder General Ledger & Intercompany
-
How to join CE_STATEMENT_LINES, CE_RECON_HISTORY, CE_RECON_HISTORY_ITEMS, AP_CHECK_ALLWe are building a BI publisher report to list Bank Statement Number, Bank Statement Line, Statement Line Amount, AP Payment Number Using the tables CE_STATEMENT_HEADERS …Pradeep Kumar Reddy V 98 views 3 comments 0 points Most recent by luke.syv8 Payables, Payments & Cash Management
-
Unable to fetch the State, County and City values through "Payroll - Calculation Cards Real Time"Summary: Unable to fetch the State, County and City values through "Payroll - Calculation Cards Real Time" subject area Content (please ensure you mask any confidential …
-
BIP report, for identifying the missing Time EntriesSummary This will be useful If we are expecting to see missing time entries in report or infolets. This SQL query logic is based on the Working hours of the User.Content…Praveen Chandra-Oracle 643 views 4 comments 5 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
1099k reportingSummary: As there is a requirement for suppliers to generate the 1099-K form, is it possible to handle 1099-K reporting within Oracle Fusion? If so, how can this be achi…Dhruba 44 views 3 comments 0 points Most recent by SherameAnderson Payables, Payments & Cash Management
-
What is the impact of having multiple tree version names on Oracle Fusion General Ledger performanceIs having multiple hierarchies (tree versions and tree versions names) impacting the reporting performance of Oracle Fusion General Ledger? By reporting, I mean opening …
-
SQL runs in query tool but not Data ModelI need to calculate the number of days a person will work during a pay period. To do this I am calculating the the days from the last day of work through the end of the …Jason Snipes 12 views 6 comments 0 points Most recent by Jason Snipes Reporting and Analytics for HCM -
Required table to get Ad Hoc resource name in activities under OfferingsSummary: Hi All, We need a table to get Adhoc Resource name, quantity and description in activities under Offerings in fusion HCM Content (please ensure you mask any con…
-
There is a image placed in Custom/Image folder. How to access this image in the BI report template?Unable to access images from Custom folder in BI report template. We have placed the test image in Custom/Image folder and tried to access this image in the template but…
-
Natwest Directline Supplier Payment FormatSummary: We are planning to implement Natwest Directline Functionality for supplier payment. The suppliers have asked about the payment Message and will it be Bacs18 or …Sharon O'Malley 11 views 0 comments 0 points Started by Sharon O'Malley Payables, Payments & Cash Management