Reports
Discussion List
-
Reconciliation Report using Supporting Reference segmentsWe have a reporting requirement to track a transaction (together with natural account) from GL to subledgers. A DFF is created at Journal header level to capture 'Transa…Kalyani-Oracle 36 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
How to create a new KPISummary: How to create a new KPI Content (please ensure you mask any confidential information): Hi Team, How to create a new KPI reports for Finance? Could anyone guide …Venkatesan 6 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Different Checklist IDSummary: Checklist_ID is always equals to Task_ID for the task associated with the particular checklist. do there is some cases where it can be different, please help. C…Yashpal_Mahto 17 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
FR WEB: What is the audit option in FR EPBCS?Summary: What is the audit option in Financial Report EPBCS ? Content (please ensure you mask any confidential information): What is the audit option in Financial Report…
-
Allocation percentage for resources in the projectSummary: Hi everyone, We're looking to gather details on project resources, specifically allocation percentages. It's important that these resources are currently assign… -
Why OTBI report output file in excel is not showing morethan 25000 recordsSummary: Is there any OTBI Developer can help me resolve this issue. If the output excel file of AD PO ALL PURCHASE ORDERS Report is morethan 25003 records it is skippin…
-
Oracle Fusion Workflow Report for all pending transactionsSummary: Is there any seeded Report available for all pending Workflows (PR,PO,AP Invoice, Payment, GL Journals, Expenses, HCM, PPM, OTL,etc). The report should show tra…
-
The search is not working in the drop down menu in Data set BU publisher reportI have this parameter that is related to a list of value that give all the contract number. the query i am using for the list of value is: select DISTINCT TV.CONTRACT_NU…Omran Zeaiter 68 views 1 comment 0 points Most recent by Andreea Versanu-Oracle Reporting and Analytics for ERP
-
can we fetch report for how many times a report runHi Everyone, we have a requirement to fetch the all custom reports in the fusion, along with their information of how many times that report run in 2024 and what is the …
-
open PO report with receipt datesSummary: We are trying to build a report with open POs and their associated receipts. Content (please ensure you mask any confidential information): Requirements are ori… -
How to export 500K rows from OTBI report into ExcelSummary: We have a report where total data is coming close to 500K and we are only able to export 25K in Excel, is there is any way to do this? If I develop this in BI P…Sam Samaddar 72 views 4 comments 0 points Most recent by Sam Samaddar Reporting and Analytics for ERP
-
What is the field where I can check the inactivated date of user in fusion.Summary: I want field where inactive date of user gets stored . Also if I delete some role from user I want to have when did I delete the role. Also in Front end I am ab…
-
How to print a barcode in BIP report?Summary How to print a barcode in BIP report?Content How to print a barcode in BIP report? Version 19D -
Not able to rename or delete existing folder in BI catalogSummary: Content (please ensure you mask any confidential information): Hello All, Hope you are having a great day. We are facing an issue while renaming a folder in BI …Lucky Sharma 50 views 5 comments 0 points Most recent by Lucky Sharma Reporting and Analytics for ERP -
OTBI scheduled reports/analyses "From" email changedHas anyone else noticed a change in the "From" email address for scheduled reports/analyses from OTBI? I have rules in my Outlook to filter these to a specific folder an… -
Is there a way to modify the Online report submission console while executing a BIP report online?Is there a way to modify the Online report submission console while executing a BIP report online. Our customer has about 28+ parameters and the requirement is to always…Aparna N-Oracle 15 views 3 comments 0 points Most recent by Aparna N-Oracle Reporting and Analytics for ERP
-
How to create language (billto-site language) dependent BIP invoice template?Summary: We try to find a way (Oracle supported or best practice) on how to use multi language templates depending on our customers bill-to-site language setup. Oracle F…Frank.Steinjan 88 views 5 comments 0 points Most recent by Lucky Sharma Reporting and Analytics for ERP
-
Limit Scheduled Process access to only Custom ESS jobSummary: We have created a custom ess job that runs a BI report. The privilege created along with the custom job has already been added to the custom role and our user a…
-
Does anyone have a template for annual retirement plan audit information?Summary: I need a report to show Total Gross Earnings, Deferral Eligible Earnings, Employee Contributions, Employee Roth Contributions, Employer Matching Contributions a…Chris West 6 views 0 comments 0 points Started by Chris West Payroll and Global Payroll Interface (GPI)
-
split Interactive BIP report into multiple excel sheet outputHi, I have an interactive BIP report which needs to generate output into 2 different formats for which I need outputs to be in 2 separate excel tabs How can this be done…Ninad Joshi 123 views 4 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Rounding in RTF Template FormulaDear All, I am attempting to round the total of X/Y numbers in a sum, but it's not working using the RTF template. This is my formula: I need to round this equation (cu…George Mattar 112 views 2 comments 0 points Most recent by George Mattar Reporting and Analytics for ERP
-
Employee Job HistoryHi I am looking for a data mart/query I can use that provide employee job history. For context, here is what I am looking to do. If we hire an employee into a specific r… -
Report for supplier invoice with address not pullingWe are developing a supplier invoice report BIP report using the below listed tables. Admin users are able to get the data, but the end user with access to just this BIP… -
Need help to modify SQL to retrieve the journal approver field pleaseSummary: I am trying to update the GL Ledger script to include the following additional fields Journal Approver name beginning and closing GL account balances for the se…
-
Is it possible to generate a list of Oracle Fusion users and the method they use for authenticationSummary: Is it possible to generate a list of Oracle Fusion users and the method they use for authentication (SSO or Local authentication)? Content (required): Is there …snagavarapu 60 views 1 comment 1 point Most recent by EGISEDGE TECHNOLOGIES PRIVATE LIMITED Reporting and Analytics for ERP
-
How to convert date to Thai and Buddhist era in Custom BIP Report.Summary: Convert date to Thai and Buddhist era in Custom BIP Report. Content (please ensure you mask any confidential information): We have requirement to show dates in …
-
Query to get credit memo details applied for an invoiceSummary: Content (please ensure you mask any confidential information): I am looking for the details of credit memo applied for an AR invoice. For the invoice 1004830 he…Rahul K-Oracle 2.5K views 1 comment 0 points Most recent by Lucky Sharma Reporting and Analytics for ERP
-
Difference between Ess Job Derived attributes and AttributesSummary: Content (please ensure you mask any confidential information): We are creating Custom ESS job for one custom report requirement. We need know, what is the real-… -
Some columns have null values for certain records and record is not retrieved when the column is selSummary Some columns have null values for certain records and record is not retrieved when the column is selectedContent I am using "Fixed Assets - Asset Depreciation Re…
-
Can we enable or disable report one parameter field based on other parameter field input?Summary: We received requirement like, 1) Choose field say start date or end date from drop down 2) Choose Operator Prior/After/Between from drop down 3) Enter Date : Da…Nikatfusion 98 views 1 comment 0 points Most recent by Sridhar Gupta Yerram-Oracle Reporting and Analytics for ERP