Reports
Discussion List
-
PO Change Order Amount Changed column detailsSummary PO Change Order Amount Changed column detailsContent Hi Friends, Can you please help me to get Amount Changed column details when PO Change Order action performe… -
Is it possible to add Approve and Reject buttons in payment process request tabSummary: Is it possible to add Approve and Reject buttons in payment process request tab in payables dashboard Content (please ensure you mask any confidential informati… -
Query to Find Privillages under Role and its Inherited RolesSummary: Need query to get privileges assigned under Role and its inherited Roles. Content (please ensure you mask any confidential information): Tried Below query but l…Nishanth B Jain 8 views 0 comments 0 points Started by Nishanth B Jain Reporting and Analytics for ERP -
Working report stopped and throwing an error ORA-01722: invalid numberSummary: I was able to use a custom BI Report a week ago. But it stopped working and throwing an error "ORA-01722: invalid number" when running. I am not sure what is ca…
-
Is there a function to get the display name from the username?Summary: Content (required): I'm looking for a function where you can pass the username and get the display name returned? I know I can do a query to the per_users table…
-
I am looking for a database table from oracle fusion for resourc override screen from work executionHi All I am looking for a Oracle fusion table for Resource Override screen from Work Execution. Also, need to know how we can join it with shift exception table 'rcs_pla…
-
Matrix Report with Pre-Defined Excel FormulasSummary: Once the report is downloaded if user modifies any value in a column then the dependent columns should recalculate the values based on the new value and excel f…Ripendra Kumar-Oracle 4 views 0 comments 0 points Started by Ripendra Kumar-Oracle Reporting and Analytics for ERP
-
How can we accurately pull the unpaid invoice amount in an analysis reportHi All, We have an analysis report that was made to assist with pulling the unpaid invoice amount, however it is pulling 3x the value for some invoices and other invoice…FlatFish534 11 views 1 comment 0 points Most recent by Shivam Chauhan-Oracle Payables, Payments & Cash Management
-
How to download pdf report in oracle apex?Summary: There is a provision to upload report layout and report queries in shared components in Oracle Apex application . We need a alternate method to call that report…Ajay Penkey 38 views 4 comments 0 points Most recent by Sylvain Martel Reporting and Analytics for ERP
-
How to monitor who and when ran a BI report that was not scheduled?We need to see who and when people run the BI Reports without scheduling.Kristel Janssens 18 views 1 comment 1 point Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
I want to restrict last line of any receipt line to be printed in EDI Etext template for the clientWe have 2 new BIP report enhancement requirement To restrict every receipt's last line to be restricted in the query, please see screenshot below for your reference the …Shahid Qureshi 17 views 1 comment 0 points Most recent by Shahid Qureshi Reporting and Analytics for ERP
-
How to remove special characters in the output of a e-text templatesSummary: We want to send all the open POs to a third party system in .txt format. The item description have a lot of special characters, how to remove it in the output w…SuniChacko 218 views 5 comments 1 point Most recent by suamanch-Oracle Reporting and Analytics for ERP
-
How to pass last 2 quarters as period parameters in General Ledger-Transactional Balances Real TimeHow to pass last 2 quarters as period parameters in General Ledger-Transactional Balances Real Time We are trying to create a Analysis report based on General Ledger-Tra…
-
How to find number of days for a month in FRSHow to find number of days for a month in FRSLakshmiVanarasi 2 views 0 comments 0 points Started by LakshmiVanarasi Reporting and Analytics for ERP
-
Are there any fusion tables that store the Daily Amount and Days on ExpensesAs in "Expenses - Expense Transactions Real Time" Subject Area Daily Amount and Days these fields are not present so is there any fusion table where we can get these det…
-
BI Publisher Pivot Table Limit/Configuration of able to add only 5 columnsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…S Javir 13 views 3 comments 0 points Most recent by Thulasipriya K-Oracle Reporting and Analytics for ERP
-
Unable to export the report in text format Windows (CRLF) UTF-8Summary: Hi We have a custom report. When we export the report in text format, should be export in Windows (CRLF) UTF-8 format but it is exported in Unix (LF) format. Ex…
-
Can multiple trees/hierarchies for the same segment be use in a single report?Summary: We are currently converting from PeopleSoft to Oracle ERP/EPM and are trying to understand the reporting and any potential limitations. We have multiple hierarc…Shannon Short 143 views 4 comments 0 points Most recent by Akash Verma Reporting and Analytics for ERP
-
How can we use multiple account hierarchies for a single segment in a FRS report?Hi Team, Our client is looking to create another hierarchy for Primary balancing segment which would be date effective from 1st of Jan 2025. They want to keep using the … -
Unwanted Linefeed characters getting returned in eText outputSummary: Linefeed characters getting returned in eText output Content (please ensure you mask any confidential information): I am having an issue where there is both Lin…
-
A SQL query of privileged resources in the role FSD sectionSummary: Hi All, Can anyone share a SQL query on how to retrieve privileged resources? inside the role of the FSD section oracle provides information about the privilege…Eliran Hadad 21 views 4 comments 0 points Most recent by Eliran Hadad Reporting and Analytics for ERP
-
Unable to proceed to create Dataset using webservice in Oracle BIP ReportSummary: Unable to create dataset with Webservice while creating custom BIP report Content (please ensure you mask any confidential information): below are the steps to …SireeshaJaladi 53 views 4 comments 1 point Most recent by fusion.integration Reporting and Analytics for ERP
-
How can we query the error message in BI Server's Report Job History?Summary: Error Log Report that will display the error message like in the Report Job History Content (required): Hi, We wanted to create a custom report that will output…
-
We need some assistance to create a report from the budgeting systemSummary: There is a requirement to create a report from the budgeting system with the fields 1.Budget year 2.IT Budget allocated by Business Unit 3.IT Budget - Actual vs…Priyanka Amjuri 2 views 0 comments 0 points Started by Priyanka Amjuri Reporting and Analytics for ERP
-
eText BIP Template inserting blank row at top of output fileSummary: eText BIP Template inserting blank row at top of output file Content (please ensure you mask any confidential information): Hello, We have a BIP eText template …
-
I have created one BIP report, Output is .csv file. I am getting String values in Double Quote.Summary: I have created one BIP report, Output is .csv file. I am getting String values in Double Quote. I want to have the values without double quotes. I have tried it…VaibhavChavan20_ 12 views 3 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
Unable to create a report combing planning and item category information with 2 subject areasSummary: Unable to create a report combing planning and item category information with 2 subject areas Content (please ensure you mask any confidential information): The…Sudhir Behera 12 views 1 comment 0 points Most recent by Yann Consolin-Oracle Supply Chain Planning and Collaboration
-
Getting the data in un-structured formate in excel file while extracting the dataSummary: Hi Team, We are trying to export the data for IBY_SYS_PMT_PROFILES_VL in excel format and we are getting in un-structured formate. Means some rows data are not …
-
Need a sql query to fetch approver history for contract managementSummary: Need a sql query to fetch approver history for contract management Content (please ensure you mask any confidential information): Version (include the version y…Dilip.Murugan-Oracle 11 views 1 comment 0 points Most recent by Akanksha Srivastava-Oracle Enterprise Contracts
-
Extract Report OutputSummary: Extract Report Output and populate standard attachment table for Payables Invoices Content (please ensure you mask any confidential information): I'd like to kn…