BI Publisher
Discussion List
-
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 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 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 23 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 246 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 176 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…
-
Identify OTBI / BIP reports using a particular columnSummary Identify OTBI / BIP reports using a particular columnContent Hi All, Is there a way to identify OTBI report and BI Publisher reports that are using a particular …User_2025-02-06-00-02-39-946 53 views 5 comments 1 point Most recent by Skolli-Oracle Reporting and Analytics for ERP
-
Paid Status for invoicesSummary Looking for the table that holds the field displaying the Paid Status for invoicesContent Hi, I am looking for the Oracle table that has the field that displays …
-
Report that tracks receipted PO'sSummary Does anybody have a report that tracks receipted PO's?Content Hi all Just wondering with the accruals of receipted items each month, which reports are being run …Tony Roff 52 views 5 comments 0 points Most recent by User_2025-02-01-08-03-13-309 Reporting and Analytics for ERP
-
Instance details for BI Publisher Report Template - Fusion ERP/SCMSummary Water marking Instance details on BI Publisher Report and EmailingContent We have a requirement to display the Instance name as watermark in some of the BI Publi…Senthilrajan V 57 views 2 comments 0 points Most recent by Senthilrajan V Reporting and Analytics for ERP -
Generate file name at runtime in BI publisherSummary Generate file name at runtime in BI publisherContent Hi We have a requirement to generate the output file name with some custom name appended with timestamp in B…ashishgupta0212 35 views 6 comments 1 point Most recent by Sudha KOVURU Reporting and Analytics for ERP
-
Daily Report that highlights supplier submitted invoicesContent Dear, Please can someone advise how to set up a report that can be scheduled daily to provide us with any new invoices that have been submitted by the supplier s…Tony Roff 37 views 4 comments 0 points Most recent by Koteswararao Yenikepalli Reporting and Analytics for ERP
-
GlTrialBalanceReport is not workSummary Standard report General ledger trial balance report giv error fileContent Hi when start run General ledger trial balance report from schadenfreude process error …Mahgoub S.Mohamed 26 views 2 comments 0 points Most recent by Mahgoub S.Mohamed Reporting and Analytics for ERP