BI Publisher
Discussion List
-
HZ Classification ReferenceContent Hi Team, I'm looking for Classification Orginal System Referenc, If I join OWNER_TABLE_ID from HZ_CODE_ASSIGNMENTS and OWNER_TABLE_ID from HZ_ORIG_SYS_REFERENCES… -
Is there a way to pass parameters to an Infolet?Summary Need to convert a report that passes a parameter into an infolet so I can easily share it with many users that are not familiar with running BI Publisher reports…Fede SD 143 views 9 comments 0 points Most recent by User_2025-01-22-19-56-59-022 Reporting and Analytics for ERP -
Modifying Configurable Expense Report TemplateSummary Access in current user detailsContent Hi,We want to access current logged in user details in configurable expense report template,1. Is it similar to how do it i…Mohak Kirtane 41 views 0 comments 0 points Most recent by Mohak Kirtane Reporting and Analytics for ERP
-
jai_tax_lines_all & jai_tax_types tables in oracle fusionSummary jai_tax_lines_all & jai_tax_types 2 tables which are in r12. Please send relevant tables for these.Content jai_tax_lines_all & jai_tax_types 2 tables which are i…Nageshwaran1 978 views 3 comments 0 points Most recent by Nageshwaran1 Reporting and Analytics for ERP -
OTBI Dashboard Prompts are not visible in Google Chrome BrowserSummary OTBI Dashboard Prompts are not visible in Google Chrome BrowserContent Hi All, When we open OTBI dashboards in google chrome ( Version: 80.0.3987.149), the dashb…Siva Kumar-Oracle 42 views 4 comments 0 points Most recent by Siva Kumar-Oracle Reporting and Analytics for ERP -
How to add one day to the PaymentDate in XSL Template?Summary Need to add one day to the PaymentDateContent I am trying to customize XSL Stylesheet (HTML/XML/Text) tempalte, My requirement is add one day to the payment date…OraFusionworld 61 views 0 comments 2 points Most recent by OraFusionworld Reporting and Analytics for ERP
-
Supplier address withholding tax tableSummary Supplier address withholding tax tableContent Hi, Which view contain the Withholding Tax Exemptions details and how to connect it with POZ_SUPPLIER_ADDRESS_V vie…Shlomo Elnekave 57 views 8 comments 0 points Most recent by Shlomo Elnekave Reporting and Analytics for ERP -
What is the limitation for BIP output to SFTPSummary What is the limitation for BIP output to SFTPContent Hi Team, What is the file size limitation to send the BIP output file from BIP server to SFTP. Thanks in Adv…ArunKumarDammalli 162 views 1 comment 1 point Most recent by Médéric Chauvin Reporting and Analytics for ERP
-
How to send BIP output to SFTP in Zip formetSummary How to send BIP output to SFTP in Zip formetContent Hi Team, We have a requirement to Send the BIP report output in ZIP to SFTP. is there any way to achive this?…ArunKumarDammalli 70 views 1 comment 3 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP
-
Calculation Between two Presentation Analysis ReportSummary Calculation Between two Presentation Analysis ReportContent Hello i have two analysis report in BI Publisher one for Revenue and other for Cost of good sold i ne…Mahgoub S.Mohamed 31 views 7 comments 0 points Most recent by Mahgoub S.Mohamed Reporting and Analytics for ERP -
BI Publisher - looking for project status tableContent Hi, Does anyone know where I can find a table that holds the history data for a Project Change status? On the front end the popup appears on our Manage Financial…
-
Misaligned columns and lines in reportSummary When published in Excel, reports lines and columns are misalignedContent Hello everyone, Sorry if this topic was already created before (I didn't find it), but I…User_2025-03-28-01-07-13-341 43 views 8 comments 2 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
Adding Project Classification (Class Code) to OTBI report duplicate Costs RowsSummary Adding Project Classification (Class Code) to OTBI report duplicate Costs RowsContent Adding Project Classification (Class Code) to OTBI report duplicate Costs R…User_2025-01-30-23-00-53-497 80 views 2 comments 1 point Most recent by User_2025-02-04-13-08-33-519 Reporting and Analytics for ERP -
Subledger job inquiry for up to date reportingSummary Subledger job inquiry for up to date reportingContent We are just starting to develop reports in BI/OTBI Oracle Fusion as a newer client. We've previously only m…User_2025-02-04-18-03-15-131 39 views 3 comments 1 point Most recent by User_2025-02-04-18-03-15-131 Reporting and Analytics for ERP
-
How to extract all project parties via a report?Summary Looking for a way to extract all project parties information via an analytics or bi publisher report.Content In the Project Financial Management web page, throug…J.C. AUF 70 views 1 comment 0 points Most recent by Meredith Bickell Reporting and Analytics for ERP -
Scheduling Cash to GL Recon BI Publisher ReportSummary Has anyone had any success with scheduling the Cash to GL Reconciliation BI Publisher Report?Content We have a request from business users to schedule this repor…
-
BIP Expense Report ApproverSummary Looking to find the appropriate SQL that will give me the approver name for Expense Reports using BI PublisherContent The goal of this report is to utilize burst…User_2025-02-04-18-47-46-124 95 views 3 comments 2 points Most recent by Andrew_Schmitz Reporting and Analytics for ERP
-
rtf template - summarize column within groupSummary rtf template - summarize column within groupContent Hi, I created simple table ( see attached files ) and i want the column values to be presented on one row. wh…Shlomo Elnekave 39 views 5 comments 0 points Most recent by Shlomo Elnekave Reporting and Analytics for ERP
-
Carriage Return in scheduled jobSummary Manual run of report has no Carriage return - scheduled run of job does - Tab delimited file.Content Hi all, Has anyone seen this behavior and overcome it? we ar…User_2025-02-04-12-06-59-807 24 views 5 comments 0 points Most recent by Patricia Gonzalez Reporting and Analytics for ERP
-
Drill down GL to subledgerSummary Drill down GL to subledgerContent Hi all, Is there any standard OTBI reports to drill from GL to subledger like AP and AR? or not possible customize is the work …User_2025-02-04-05-26-22-197 145 views 2 comments 0 points Most recent by User_2025-02-04-05-26-22-197 Reporting and Analytics for ERP
-
Lookup Details from Subject AreaSummary Custom Lookup Details from Subject AreaContent Is it possible to fetch any custom lookup information from any Subject Area? The use case is like below: An analys…
-
Positive Pay Template ConfigurationSummary I'm looking for detailed instructions for how to break down and configure a positive pay template.Content By and large I'm looking for a guide for setting up a P…David Rabalais 45 views 7 comments 0 points Most recent by Glen Ryen Reporting and Analytics for ERP -
Syntax Error While Using Evaluate in OTBI AnalysisSummary Evaluate function generates a syntax error when using REGXP_SUBSTRContent I am attempting to trim the following column in the General Ledger - Journals Real Time…User_2025-02-05-07-37-39-271 46 views 10 comments 2 points Most recent by User_2025-02-05-07-37-39-271 Reporting and Analytics for ERP
-
BIP PO rtf Template archive querySummary Displaying the Line Level Notes to Supplier in the PO Template in BIPContent Hi, I have a requirement to display "Notes to Supplier" field on to PO rtf Template …User_2025-02-05-10-39-37-202 38 views 8 comments 1 point Most recent by User_2025-02-05-10-39-37-202 Reporting and Analytics for ERP
-
How do i put in multiple columns in the x axis of a rtf chart?Summary X axis contains values coming from a column and rtf does not allow multiple entries into the x axis label.Sumanth Kunimakki-21932 34 views 0 comments 1 point Most recent by Sumanth Kunimakki-21932 Reporting and Analytics for ERP
-
Reports ListSummary get the list off all reports under CatalogContent Hello all, I am not sure this is the right section to ask this question, but I will give it a try: Does anyone …User_2025-02-04-08-34-10-102 125 views 8 comments 1 point Most recent by Nathan CCC Reporting and Analytics for ERP
-
Cash Flow StatementSummary Availablity of out-of-box Cash Flow StatementContent In 19D version, is there any out-of-box report (BI or FRS) available for generating Cash Flow Statement? Sam…
-
Advanced CollectionsContent Hello All, Do we have any OTBI subject area which gives data related to Collections. Ex: Collector wise collections. Thanks, NishanthNishanth B Jain 119 views 7 comments 0 points Most recent by Veronica Dumitriu Reporting and Analytics for ERP -
Adding LOV in ESS Bi Publisher ReportSummary Adding LOV SourceContent Someone can help in Adding LOV of BiPublisher Report in Custom Enterprise Scheduler Job with LOV SourceBilal Ahmed 76 views 9 comments 1 point Most recent by User_2025-02-05-01-59-04-941 Reporting and Analytics for ERP
-
OTBI bar graph formatting for gradient not workingContent I've created a dashboard and saved the supporting analyses and prompts in My Folders. When I copied it to a shared custom folder, no one in my company could view…Mike Burnett 24 views 5 comments 0 points Most recent by Senthilrajan V Reporting and Analytics for ERP