BI Publisher
Discussion List
-
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… -
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 69 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 69 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
-
Request Read Receipt while scheduling BI ReportsContent I have scheduled a BI report and enabled Request Delivery Status Notification and Request Read Receipt Option. But I havent received any email or notification af…Sabarish Reddy Ganda 106 views 0 comments 1 point Most recent by Sabarish Reddy Ganda 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
-
How to Import a signature and logo in UCM Server and Export a signature and logo in RTF TemplateSummary A requirement is to upload logo in UCM server and access that logo in RTF Template by using Payment Format(Check printing))Content A requirement is to upload log…Arpita Saha-137995 593 views 9 comments 1 point Most recent by Glen Ryen 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 144 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 41 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 45 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 35 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 -
BIP extract needs to be split into multiple files for a specific range.Summary Is it possible to split BIP extract file into multiple files for a specific range.Content Hi All, I need to extract Projects and related task information from Or…Sunil Kumar Mallina 70 views 6 comments 1 point Most recent by Soumya Prakash Parhi Reporting and Analytics for ERP
-
How to Publish New DashboardContent Hi i have new dashboard in BI and i need to publish after finish and i stuck in below error Destination same as source: /shared/Custom/_portal see in attached Th…Mahgoub S.Mohamed 43 views 1 comment 0 points Most recent by Senthilrajan V Reporting and Analytics for ERP -
Oracle Operational reports - CSV exportSummary Oracle Operational reports - CSV exportContent All, We are reviewing the OOTB cloud ERP operational reports (BI Publisher) with client and what they really like …User_2025-02-06-00-02-39-946 49 views 1 comment 0 points Most recent by Karthikeyan Sukumar Reporting and Analytics for ERP
-
Some users do not have the archive and unarchive optionContent Some users do not have the archive and unarchive option, any ideas? Please share if you know. Thanks.User_2025-02-04-05-26-22-197 45 views 6 comments 1 point Most recent by Karthikeyan Sukumar Reporting and Analytics for ERP
-
Can we still use API - APPS.iby_fd_extract_ext_pub to add custom XML tag? in Oracle Cloud FusionSummary Can we still use API - APPS.iby_fd_extract_ext_pub to add custom XML tag? in Oracle Cloud FusionContent Can we still use API - APPS.iby_fd_extract_ext_pub to add…Ananth surampudi 45 views 5 comments 1 point Most recent by Glen Ryen Reporting and Analytics for ERP
-
Custom ESS Job Parameters Display Issues on Submission FormSummary Custom ESS Job Parameters with Custom LOVs do not display correctly on ESS Job Submission ScreenContent I have created a custom ESS job from a Bi Publisher repor…Scott Madole 233 views 3 comments 0 points Most recent by Scott Madole Reporting and Analytics for ERP
-
Period Name- In OTBI reportSummary Need perod name should populate like DEC-FY-20 (DDDFFYY)Content Hello Team, We want to have the Period name in our OTBI report in the format 'DEC-FY-20', 'SEP-FY…Saurabh Sharma_HCL 158 views 1 comment 0 points Most recent by ndryden Reporting and Analytics for ERP
-
How to display VAT for an expense line/reportContent Hi, Between EXM_EXPENSE_REPORTS and EXM_EXPENSES how do I get to display the VAT paid for an expense line/report? Either through a data model/SQL or with an anal… -
line feed when displaying getclob() using data model in oracle cloudSummary line feed when displaying getclob() using data model in oracle cloudContent select sysdate, rtrim(xmlagg(xmlelement(e,id,',').extract('//text()') order by id).Ge…