Sample Reports
Discussion List
-
How to add Hyperlink to BI Excel template fieldSummary: We have a requirement to show Oracle AR Invoice Page and when click on Invoice Number in BI Excel template. Excel template has list of Invoice Numbers and its d…SireeshaJaladi 5 views 0 comments 0 points Started by SireeshaJaladi Reporting and Analytics for ERP -
Need report that shows all approval assignees who have NOT approved invoiceSummary We are trying to build a report that provides only “open/incomplete” invoice approvals (i.e. only those approval assignees who have NOT approved yet)Content We a…Virginia Baez-Ponce 310 views 16 comments 2 points Most recent by Dahlia Gaggan Reporting and Analytics for ERP
-
Budgetary Control Balances OTBI with Deep Link Sample ReportSummary: Content (required): The Budget Balances OTBI with Deep Link Sample Report Kit contains a sample report embedded with a deep link to Review Budgetary Control Tra…Anne Wong -Oracle 494 views 7 comments 2 points Most recent by Bram F Reporting and Analytics for ERP -
Query for Business Units and Legal Entities mapping for Payables.Summary Need query to fetch Business Units and associated Legal Entities mapping for Payables.Content Hi All, I am having requirement to fetch all the Legal Entities ava…User_SJJQT 397 views 3 comments 0 points Most recent by Hemanth Kumar K N Reporting and Analytics for ERP
-
Sales Order Lifecycle ReportI am looking for end to end O2C lifecycle details in report. Do we have any sample report report with this requirement ? Below are the columns I am looking into it. Sale…Oracletechnofunctional 52 views 2 comments 0 points Most recent by ManojP_02 Reporting and Analytics for ERP
-
Looking for SQL query for Duty Role to Job Role mappingSummary: We have a couple of job roles and child duty roles and privileges assigned to the same job role. Can someone help me with SQL to fetch the same as we need to co…sailesh_cloudare 23 views 1 comment 2 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for ERP -
Child account not reflecting under Parent account in Smart ViewSummary Child account not reflecting under Parent account in Smart ViewContent After creating a new account, when refreshing Smartview report I noticed Its not reflectin…
-
BIP - For payment methods used by customers against AR invoicesSummary: Content (required): Need to write a BIP to find payment methods used by customers against AR invoices. Facing difficulty in finding link between RA_CUSTOMER tab…Maheedhar_Atmakuru 32 views 3 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
Excel template with summary and Detail and Detail sheet should split in to multi sheet, need helpSummary: Excel template with summary and Detail and Detail sheet should split in to multi sheet, need help Content (required): Excel template with summary and Detail ( D…A Dineshkumar-Oracle 2 views 0 comments 1 point Started by A Dineshkumar-Oracle Reporting and Analytics for ERP
-
Create List of Values for Dependent Segments in GL Custom BI Publisher Reports White PaperSummary: Your finance staff may modify standard GL BI Publisher (BIP) reports to address specific business requirements. They may need to run a GL BIP report by various …Helle Hennings-Oracle 322 views 7 comments 8 points Most recent by JatinderSingh Reporting and Analytics for ERP -
How to convert English language to Arabic in rtf templateSummary: how to convert below English text into Arabic language and split it into two lines in rtf template. Example input text: "EIGHT HUNDRED FIFTY-SIX BAHRAINI DINARS…SireeshaJaladi 64 views 2 comments 0 points Most recent by user1294915 Reporting and Analytics for ERP
-
eText Templates seeded sample templatesHi , From where can we download some of the seeded eText Templates used in Oracle for payment formats. Can anyone please share the exact path in the BI catalog. Thanks V…
-
How to translate Amount in Words from English to Arabic language in rtf templateSummary: we have a requirement to print Payment amount in Words (English) to Arabic language in check template. The expectation is that, translate below given English te…SireeshaJaladi 92 views 6 comments 0 points Most recent by AmitojSingh Reporting and Analytics for ERP
-
Template for large BIP reportHi Which template is it recommended to use if we need to generate reports which require layouts with many columns. Using the wizard for creating .xpt reports, it is diff…
-
Procurement OTBI DashboardsSummary ERP Procurement OTBI Reports and Dashboards uploaded for the CommunityContent Sharing a procurement to pay dashboard with multiple tabs containing example report…user799189-Oracle 501 views 13 comments 15 points Most recent by Remigious Reporting and Analytics for ERP -
Archive/Unarchive buttons missing in Catalog ReportsSummary Archive/Unarchive buttons missing in Catalog ReportsContent Hi All, Archive/Unarchive buttons missing in Catalog Reports Thanks, Dev Thota. Version 21BDevendra Thota 134 views 3 comments 3 points Most recent by Skolli-Oracle Reporting and Analytics for ERP
-
Viewing USD AmountSummary Viewing USD AmountContent Hi, We have many companies in different countries that have different currency. We designed an pivot table using OTBI for Purchase Orde…Eren Göktepe-155015 40 views 6 comments 0 points Most recent by Zehra M Reporting and Analytics for ERP -
Ctreating a report for my PPM moduleDear all I am creating a report for my PPM module I just want to list the project name - task name and number - Cost and Resource I found all the above except the Resour…mickel rmeily 12 views 1 comment 0 points Most recent by Anders W. Langholm Reporting and Analytics for ERP -
How to enable external directory in Oracle FRS schedulerSummary: How to enable external directory in Oracle FRS scheduler Content (required): We want to be able to send the output of FRS using a batch scheduler on an external…
-
Bold Style is missing for Arabic text in PDF output of rtf templateSummary: We have a check template (.rtf) developed with Payment Date, Payee Name, Payment Amount and Payment Amount in Words . In these fields, Payee name and Payment Am…SireeshaJaladi 104 views 11 comments 1 point Most recent by SireeshaJaladi Reporting and Analytics for ERP
-
Procure to Pay DashboardsSummary: Procure to Pay Dashboards Content (required): How can these be added to the home dashboard once the user is login, instead of going to reports and analytics and…CraigX 42 views 5 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
How to encode etext output file from UTF-8 to ANSI in OracleSummary: We have custom etext payment file for Citi Bank EFT. the output of Etext file is .txt and it is encoded in UTF-8 by default. how can i convert this text file fr…SireeshaJaladi 22 views 0 comments 0 points Started by SireeshaJaladi Reporting and Analytics for ERP
-
How to get output character set in ANSI for etext templateSummary: In Oracle etext template is set to "iso-8859-1", what value we need to provide to change it to ASCI. Content (required): Version (include the version you are u…SireeshaJaladi 32 views 1 comment 1 point Most recent by SireeshaJaladi Reporting and Analytics for ERP
-
IBY_AMOUNT_IN_WORDS.GET_AMOUNT_IN_WORDS is not working for khajakistan (KZT)Summary: IBY_AMOUNT_IN_WORDS.GET_AMOUNT_IN_WORDS is not working for only khajakistan (KZT) Example: select IBY_AMOUNT_IN_WORDS.GET_AMOUNT_IN_WORDS ('123.45','INR') from …SireeshaJaladi 63 views 9 comments 0 points Most recent by SireeshaJaladi Reporting and Analytics for ERP
-
Report to extract Payables invoice approval workflowSummary: Report to extract Payables invoice approval workflow Content (required): Need to know source of payables invoice approval workflow setup so that a report can be…Bernadette Dorris 32 views 0 comments 0 points Started by Bernadette Dorris Reporting and Analytics for ERP
-
Is there an option or XDO function to print country name using Country code?Summary: Currently, Client is using a DFF to capture country code for Invoices when the payment is made for a foreign professional. These are of type Payment requests an…Abhilash K - Deloitte USI 22 views 1 comment 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
OTBI report generating several months in 1 reportDear All I am trying to create an OTBI report that can give me a sequence of months in 1 report I have the PPM module I want to know for each month the cost and the reve…mickel rmeily 52 views 4 comments 0 points Most recent by mickel rmeily Reporting and Analytics for ERP
-
how to use listagg function in rtf template?Summary: Requirement to display a value (output of for loop) in a single row in RTF template, as of now its displaying each value in each row. Needs to be handled in RTF…Thanigainathan R 112 views 2 comments 0 points Most recent by Thanigainathan R Reporting and Analytics for ERP
-
Requisition Life-cycle report (OTBI)Summary Simple report showing creation date, approval date, PO creation date etc for purchase requisitionsContent See attached screenshot for details. Unarchive the atta… -
Calculate revenue % distribution for each project with in Business unitSummary: We have the below requirement Project1 Revenue amount-20 project2 Revenue amount-30 project3 revenue amount-16 Total BU revenue amount 66 (this is achieved by e…