BI Publisher
Discussion List
-
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( Supply Chain Planning → Ma…Sravanthi0310 14 views 1 comment 0 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP -
XDO_TEMPLATES_BSummary: I am not able to query XDO_TEMPLATES_B. Getting ORA-00942: table or view does not existhttps://docs.oracle.com/error-help/db/ora-0 Content (please ensure you ma…
-
Get candidate attachments for BIP Data ModelSummary: Option to get the URL for accessing a candidate's attachment in the Recruiting module Content (please ensure you mask any confidential information): Hello every…
-
How to get the USER_NAME or USERID into default value of a data model parameterSummary: How to get the USER_NAME or USERID (or exquivalent) into default value of a data model free form string parameter Content (required): In a data model I would li…Jbgood 2K views 5 comments 3 points Most recent by Humberto Martín-Oracle Reporting and Analytics for HCM
-
BI Publisher Server host and Port NumberSummary How to get BI Publisher Server host and Port NumberContent Hello Everyone, I'm unable to login to BI Publisher RTF template using following url. Does anyone know…
-
Expense Setup TablesCan anyone please help in identifying the backend tables where the configurations related to Manage Expense Report Audit Rules and Manage Expense Report Audit and Receip…
-
Issue while extending offerSummary: Dear All, We are trying to extend the offer for one of the candidate and getting below error: The job offer couldn't be extended. There was a problem with the j…Sayali Pawar-Oracle 884 views 7 comments 1 point Most recent by Subhojit31 Reporting and Analytics for HCM
-
Project Class Category Causes Duplicate Rows for Project Financial Information in OTBI and BI PUBSummary: When we want to report on the Project Classifications class categories for a project number there is no clean way to do it. The current solution we are doing re…
-
How to monitor the following reporting and analytics field : "Enable Monitor and Audit" fieldSummary: Under reporting and analytics, under Administration, Manage Publisher, Server configuration, under Monitor and Audit section How can monitor "Enable Monitor and…
-
While trying to open Manage BI Publisher Template, getting errorSummary While trying to open Manage BI Publisher Template, getting errorContent Hi, While trying to open Manage BI Publisher Template, getting below and attached error. …User_YCHHM 37 views 2 comments 1 point Most recent by SuniChacko Payables, Payments & Cash Management
-
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.4K 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 91 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 131 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 57 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 1.1K 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 …