Category 129
Discussion List
-
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 find which attribute is being updated based on Order Attribute Updated business event.Summary: How to find which attribute is being updated based on Order Attribute Updated business event. Content (please ensure you mask any confidential information): Ver…User_9HG0E 24 views 2 comments 0 points Most recent by Prateek_16-Oracle Supply Chain Planning and Collaboration
-
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 convert Amount to WordsSummary: in EBS we Used Pacjage AP_AMOUNT_UTILITIES_PKG to convert Amount numbers into Word We see the same package in fusion but We do not understand how to use it - SQ…
-
Duplicate lines in PVO FscmTopModelAM.FinExtractAM.GlBiccExtractAM.JournalLineExtractPVOIn the Oracle Business Intelligence Cloud Connector (BICC) Console, the Support Incremental option is enabled under Manage Job for FscmTopModelAM.FinExtractAM.GlBiccExtr…Jaydeep_Chaudhari_1802 2 views 0 comments 0 points Started by Jaydeep_Chaudhari_1802 Reporting and Analytics for ERP
-
How To Design FRS Report That Shows all the transaction Balances For a specific account Periods?We want to create an FRS report that will prompted for the Account and Period and will show the all accounting entries with journal type for the input, is it possible?
-
OTBI results in errors saying "The specified criteria didn't result in any dataSummary: Error in OTBI report using the Labor Distribution Cost Analysis Real Time subject area I am using the Projects - Labor Distribution Cost Analysis Real Time subj…Anand.a.Gaurav-Oracle 2 views 0 comments 0 points Started by Anand.a.Gaurav-Oracle Reporting and Analytics for ERP
-
Help finding FND_ATTACHED_DOCUMENT table in ApBicc PVO in FDI?I need some help to find out if a PVO exists that is accessible in FDI that contains the FND_ATTACHED_DOCUMENTS table - namely I'm after a column called "URL Attachments…
-
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
-
Project Budgeting is done at resource level or task levelSummary: Hi experts, Is there a way or a flag or field which indicates if the project budget is done on the resource level or task level ? we are trying to identify that…
-
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…
-
Custom LOV search in ESS JOB is not case insensitiveSummary: Hi All, Is there a way to make the LOV search case-insensitive? I have an LOV for Supplier Name. When the LOV popup appears, users can enter a name in the searc…RupaliGahalot 135 views 16 comments 1 point Most recent by Ashwani Kumar Mallia Reporting and Analytics for ERP
-
REST API to extract database tableSummary: Hi Community, I’m exploring if REST APIs can be used to fetch all data from a table, similar to query like SELECT * FROM PO_HEADERS_ALL I came across that REST …
-
New Saudi Symbol CurrencySummary: Add new Saudi Riyal Symbol Content (please ensure you mask any confidential information): Saudi Arabia is starting to use a new symbol for the currency SAR, how…Mostafa AboElhassan 45 views 5 comments 0 points Most recent by Rami Kalasli Reporting and Analytics for ERP
-
report otbi general balances real time with hierarchieshow can i create a report balances with hierarchies in subject area? i can t see hierarchy
-
What is the SQL Query to fetch Asset Cost Center Code and Asset Cost Natural Account?Summary: SQL Query to fetch Depreciation method, Asset Cost Center Code, Asset Cost Natural Account and Depreciation Expense Account Content (please ensure you mask any …
-
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_ 14 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
-
How to hide Common Content folder under Shared Folders on BIP Catalog pageSummary: Before the quaterly patch 25A, system did not show "Common Content" under Shared Folders on BIP Catalog page. But somehow system shows "Common Content" under Sh…Tomoyuki Hyakutake-Oracle 12 views 1 comment 0 points Most recent by Mark_R Reporting and Analytics for ERP