BI Publisher
Discussion List
-
Need to know the logic behind the seeded report parameters of Payables Trial Balance ReportSummary: Just wanted to know the logic behind seeded 'Payables Trial Balance Report' parameters which are mentioned below 1.Include Bills Payable 2.Negative Balances Onl…SireeshaJaladi 112 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
How to report for those absence leave requests which are in denied statusHi, Can you please suggest how to report for those absence leave requests which are in denied status. Thanks in advance. -
Employee Assignments Processed in a 'Calculate Payroll' RunHi, does anyone have an SQL/Data Model to list all employees processed through a 'Calculate Payroll' Run or know which tables i would need to use?
-
Tables lock or obsolete statisticsSummary: Hello experts! It's possibile to verify if it's present a lock on a table o the statistics are obsolete? We have a BI query of a scheduled job that times out ra…Gian Luca Triglia 1 view 2 comments 1 point Most recent by Alexandru-Catalin Serban-Oracle Fusion Applications Administration
-
Can we import data via API to be included in OTBI dashboardSummary: Is there a way to import data via an API and have this data be available on a OTBI dashboard? MJ
-
Required table for component group rules setupSummary: Hi Team, Could ypu please provide us the table where payroll component group rules stored in oracle fusion Payroll module Setiup name > Component Group Rule. fo…
-
Query to link between State and component group ruleSummary: what is the link between component group rule and this state through SQL query or backend table. We got one table HZ_GEOGRAPHIES where GEOGRAPHY_TYPE = 'STATE' …
-
Need inputs to get the DFF fields in Worker folder in OTBI analysisSummary: Need inputs to get the DFF fields in Worker folder in OTBI analysis Content (required): We have few DFF fields in Employement and Person UI/Screen. As of now we…
-
SQL query to retrieve additional manager types at the employee levelSummary: Content (please ensure you mask any confidential information): Hello experts, we need to retrieve hierarchies loaded in core hr for additional manager types (no…Valerio Curzi 11 views 1 comment 0 points Most recent by Shikha Agarwal Reporting and Analytics for HCM -
BI Publisher Packages in Datamodels for ReportsSummary: In Fusion ERP, several BI Publisher reports use packaged procedures within the data model. For example, the Fixed Assets Reserve Summary and Detail reports refe…Swapna Alluri 11 views 0 comments 0 points Most recent by Swapna Alluri Reporting and Analytics for ERP
-
Need to build a BI publisher report on Document of recordsSummary Reporting on Document of record filenameContent Hi, We recently uploaded documents under document of record for all employees. We need to write a query to valida…User_2025-01-31-02-27-22-166 549 views 12 comments 0 points Most recent by Subbarao B-Oracle Reporting and Analytics for HCM -
Receive Expected ShipmentsSummary: which table / tables store the data for this screen? Receive Expected Shipments Content (please ensure you mask any confidential information): 24b Version (incl…Daniel Martin-Oracle 1 view 2 comments 0 points Most recent by Shubhashree R Rajanna Reporting and Analytics for ERP
-
Invoke REST endpoint Integration in BIP report BurstingSummary: HI Is it possible to invoke Integration BIP report bursting? if yes then please give information integration configuration ? Content (please ensure you mask any…MayurM 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
How to get the Base Price of an Item from the Price List corresponding to the Customer Ship to SiteSummary: Hello All, Could you please help me to get the base price of an item from the Price List corresponding to the Customer Ship to Site. And I have prepare an query…Deepak Bhatt 12 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
Parameter is not passing correctly to integration via HTTP(XML feed)summary: Hi I am trying to call integration using BIP with data model HTTP (XML) feed but it seems parameter is not going correctly in integration and getting one error …MayurM 11 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Conversion UOM columns From and To Code from INV_UOM_CLASS_CONVERSIONS Showing Interchanged ValuesHi, I have observed an interchanged outputs in column- FROM_UOM_CODE, TO_UOM_CODE in table INV_UOM_CLASS_CONVERSIONS. What could've been the cause of this? Regards, Mikamikaromo 14 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Which Oracle table is used to store the valueProduct Line Description under Product Line InformationSummary: Hi @everyone Can anyone have any idea that which Oracle table is used to store the exact value of below Product Line Information in the backend and how it shoul…Deepak Bhatt 2 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
SQL error - discounted price | BI publisher multiplication issue.I'm in the process of generating the cost price list, but I'm encountering a runtime error. The error message doesn't provide specific details, so the root cause is uncl…Misato Yoda 11 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Can we use invalid custom 'From email address' for BI Report Notification?Hi Everyone, We are trying to personalize 'Email From Address' for BI Reporting Delivery. We have changed 'Email From Address' by navigating to /xmlpserver → Administrat…BinduTammineni 1 view 0 comments 0 points Most recent by BinduTammineni Reporting and Analytics for HCM
-
SKIP ROW based on an attribute in one sheet of a multi sheet excel templateSummary I have a summary and detail excel template. I need to suppress rows which have a value of zero on one particular attribute of the row.Content I have inserted the…User_2025-02-05-18-28-58-388 185 views 12 comments 1 point Most recent by Bal C. Reporting and Analytics for ERP
-
Table name to get packag unit details for a shipment/deliveryDelivery line is performed with a Pack. I need to retrieve the package unit details to display on my Custom BI report. Can you please help me obtain the Package Unit Det…Dinesh K89 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
CSV file bank statement importSummary: We have reached out to our BANK, but they are unable to provide statements in the BAI2 format. One BANK can provide statements in CSV format, while the other do…Naresh12345 21 views 3 comments 0 points Most recent by Naresh12345 Payables, Payments & Cash Management
-
Issues while displaying Calnedar View in OTBISummary: Unable to call https://www.gstatic.com/charts/loader.js using Narrative view in OTBI Content (please ensure you mask any confidential information): We have a re…Sahil_Makhiza 11 views 0 comments 0 points Most recent by Sahil_Makhiza Reporting and Analytics for HCM
-
Burst to Documents of RecordSummary BI publisher report bursting to DoR possible?Content Hey, We would like to create a BIP report (containing the approved notice period and other relevant data) in…Ann Van Roosbroeck 381 views 4 comments 2 points Most recent by Tara Samari-237472 Reporting and Analytics for HCM -
Conditional Region for Pictures on BI PublisherSummary: Difficulty Applying Conditional Region for Displaying Different Logos in BI Publisher Word Add-In Content (please ensure you mask any confidential information):…
-
How to generate a BI Publisher URLI need to create a direct URL for the PayablesTrialBalance.xdo report in BI Publisher that will display the report with the correct parameters and formatting in the brow…
-
Does Oracle Fusion Allow a Link to Microsoft Power BI?Summary I'm looking to see if Fusion would allow Microsoft Power BI to link to the Servers In Order to Build ReportsContent My company uses Microsoft Power BI for alot o…Brian Burns 87 views 5 comments 5 points Most recent by daniel.valdovinos Reporting and Analytics for ERP -
Oracle Fusion (HCM) Allow a Link to Microsoft Power BI to get dashboards?We are currently implementing Oracle Fusion HCM and the client has several dashboards already developed in Microsoft Power BI. These dashboards are published in Power BI…daniel.valdovinos 43 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
How to create an ER diagram that illustrates the relationship between tables within Oracle Fusion?Summary: How to create an ER diagram that illustrates the relationship between the PER_LOCATION_EXTRA_INFO_F table and the LOCATION_ID and LOCATION_NAME columns in HR_LO…Dhilip Kumar P. 32 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
What Tasks are done in Print Receivables Transactions and Child Jobs?Summary: Hello, we are having a customized Print Receivables Transactions process (Datamodel and Templates are customized) in Oracle Fusion cloud. To be able to do some …