BI Publisher
Discussion List
-
Custom FolderSummary: We have created a folder named "Reports " - it is not in the custom folder - will this folder be preserved when doing an upgrade or do we need to put all custom…Vinayak Walse-Oracle 61 views 5 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP -
ARGENTINA - SICORE. REPORTING OF WITHHOLDINGS IN ACCOUNTS PAYABLESummary: what is the structure that this report should handle according to your country reg Content (required): Argentina SICORE, what is the structure that this report … -
Audit HistorySummary: Hi Team, We have inserted a few invoices through the REST API and updated some invoices manually. When we check the Audit Report page, we can only see event typ…Venkateswari 11 views 1 comment 0 points Most recent by Vinay Galithoti-Oracle Payables, Payments & Cash Management -
How to get all Active and Inactive Records Regardless of Assignment Type Except for Inactive PendingSummary: Hi All, I have a report that get all Active and Inactive Records but I want to Exclude Inactive Pending Worker only. Any one have already tried this? Trying to … -
Resource to learn Extract.Summary: Hi All, I am complete beginner to Extracts. Would like to have standard and simple resources to learn. Thanks in Advance! Version (include the version you are u… -
Payroll run exclusion GroupSummary Identifies employees who are in an exclusion group and will not be included in the payroll run.Content Hi, Can you please suggest if Payroll exclusion group is a…User_2025-01-30-20-59-13-989 42 views 4 comments 0 points Most recent by Nitin.Goswami Reporting and Analytics for HCM -
BI Report for Invoice in Receivables Manage Transaction PageHi Experts, Kindly if anyone knows from where in BI publisher we are able to see the template and data model used to view the invoice in Manage transaction page in Recei…Yuvraj S-Oracle 32 views 6 comments 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections -
Worksheet Proration ReportSummary: Worksheet Proration Report Content (please ensure you mask any confidential information): Hi All, Greetings! This is about the reporting requirement including c…Parag Hiremath 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Person Type LOV not containing values in Manage UsersSummary: Content (required): Currently, we are using Oracle Fusion ERP. The Person Type LOV when trying to create an employee (Setup & Maintenance - Manage Users), is bl… -
formatting currency through DM or RTF?Summary: when customizing a DM and RTF, I need to format the currency into $****,****.XX format. Content (please ensure you mask any confidential information): Should I … -
Office 2019 Oracle BI Publisher ErrorFor example when I try to load a xml data ı got this message Hello I just downloaded Oracle BI Publisher but at my publisher area there is an error . I tried to install …Kaan Can Calkan 31 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Is there a report I can run with earnings history?Summary: Is there a report I can run with earnings history? Content (please ensure you mask any confidential information): Version (include the version you are using, if…User_2025-11-21-00-15-21-711 1 view 2 comments 0 points Most recent by User_2025-11-21-00-15-21-711 Reporting and Analytics for HCM -
Image in BI Publisher template spills into attachment when sent to e-mail outputSummary: Image in BI Publisher template spills into attachment when sent to e-mail output Content (please ensure you mask any confidential information): In BI Publisher …Robert of STAU 41 views 7 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP -
Need to convert string into hash valueHi, I need to convert 'AKEBSTEST-700(2.1)' string into hash value i.e '561956564' using sql or Plsql. Is any function we can use to convert this value.vikram khengare 31 views 3 comments 1 point Most recent by Lee Eslick-Huff Reporting and Analytics for ERP -
Asset Otbi Report with Po NumberHI Guys I have been developed OTBI Report for F Asset to Display (Asset Number, Asset Cost, Date Placed In Service, ETC) and i need To add PO Number but when added Po Nu… -
Need Custom Advance Shipment Report fileSummary Need Custom Advance Shipment Report Sample fileContent Need Custom Advance Shipment Report fileNageshwaran1 28 views 1 comment 0 points Most recent by Mahmoud Abdulghany Reporting and Analytics for ERP -
Production to Stage for BIP ReportsSummary Easiest way to copy BIP reports from Production to Stage environmentsContent Hi all - we have two ways that we use BIP reports on our dashboards: 1) Embedded Con…Prudence K 48 views 6 comments 4 points Most recent by Nivya Mathire Reporting and Analytics for HCM -
Does BI Publisher allows dates in dd/mm/yyyy format?Summary: Does BI Publisher allows dates in dd/mm/yyyy format? Content (please ensure you mask any confidential information): I see only these formats: I need dd/mm/yyyy …Stefano_Mazzocca 41 views 5 comments 0 points Most recent by Stefano_Mazzocca Reporting and Analytics for HCM -
How to print overflow pages for AP Check Print on regular pages instead of Check paper StockSummary: How to print overflow pages for AP Check Print on regular pages instead of Check paper Stock from application directly. Content (required): Hi Team. We have a r…SwatiB22 221 views 3 comments 1 point Most recent by Ramprakash09 Payables, Payments & Cash Management -
job history reporthi Experts, From the below table I am able to get only the history of past one month. Does anyone now the table names to get the report for more than month ? fusion_ora_…Nivya Mathire 31 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Export audit logs through OTBI\BI publisherHi, need assistance on how to pull mass audit logs from the OTB?I\Bi publisher. thank you in advance.Gal Shani 41 views 1 comment 0 points Most recent by Satyabrata Nanda Reporting and Analytics for HCM -
Course CategorySummary: Hi, Do you know where can I find the course category either in BI Publisher or in OTBI? Content (please ensure you mask any confidential information): Hi, Do yo… -
PO Matched Invoices where retainage are not calculatedSQL query to get PO Matched Invoice are created but retainage are not entered or calculated automatically from Purchase OrdersMr.Bilal 11 views 1 comment 0 points Most recent by Vinay Galithoti-Oracle Payables, Payments & Cash Management -
Query for Person Security Profile ReportHi team, we need a person security profile report. can someone help me to provide the query of this if anyone has already gone through this type of requirenment. Thanks!Pushpendra Patle 11 views 3 comments 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM -
OTBI: Prompt Link not workingHello All, When prompt link is generated either from edge or chrome browser it error out as Bad Gateway. Any help would be appreciated! Thank you.Gail Wilmoth 21 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
How to output a list of all reports and their folders in Production environmentSummary: We are trying to map all reports in our production environment, with their folder locations. Does anyone know of an administrative tool that might be able to ou…Rich R 1.4K views 28 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
SQL query to get transaction date on statement lin, joining CE_BAT_TRANSFERS with CE_STATEMENT_LINESI'm trying to create a query where I want to find the transaction date of an Internal Bank Transfer. The goal is to create a report which is used for reconciliation of b… -
previos salary after correctionSummary: Content (please ensure you mask any confidential information): Hi all, I need to fetch current salary and the previous one, when i do it on the regular way - it…Hadassah Friedman 1 view 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Query to extract ElementEntry SourceSystemID and ElementEntryValue SourceSystemIDSummary: Content (required): Hello experts, do you have a query to extract ElementEntry SourceSystemID and ElementEntryValue SourceSystemID? We need to recover both keys…Valerio Curzi 41 views 4 comments 0 points Most recent by Raju Sandepogu-Oracle Reporting and Analytics for HCM