To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for ERP
Discussion List
-
Prepayment BalancesSummary Query for Prepayment BalancesContent Hello, We are looking to build a report that lists all current prepayments and balances, there was a Prepayments Status Repo… -
Oracle Fusion ESS - Scheduled Processes - Schedule Monthly By Date - ClarificationSummary: While Scheduling an ESS Job in Oracle Fusion: If we want to run the process once a month every month on a particular day, for example, 29th or 30th of every mon…
-
How can I create this formula for a custom column in OTBI?Summary: I'm attempting to create an asset replacement report with the ability to drill back to the replaced asset (DFF). I need to create a formula to compare two colum…
-
Etext negative number paddingSummary Etext negative number paddingContent Hi All. We have a requirement to dispay a number like -123 as -00012300. Please suggest how this is possible in Etext templa…
-
OTBI users are able to edit the report when they have only Read permissionSummary: OTBI users are able to edit the report when they have only Read permission Content (please ensure you mask any confidential information): Version (include the v…
-
Any way to automatically backup OTBI Custom directory?Summary I am trying to think up a way to do backups on the custom reports directory in OTBIContent As the title states, has anyone come up with a way to automatically ba… -
AFLOG enabled at site level post 23DSummary: We see that AFLOG profile option is enabled at site level in all of our environments post 23D update by Oracle. We would like to know if this change was done as…
-
Make every report output display date in PST timezone instead of UTC in Oracle FusionSummary: Hi Team , is there a way that you are aware of in oracle cloud that we can make the report to run in California timezone instead of default UTC timezone of clou… -
Merge Two OTBI Subject Area For PO receipt dateHi , We have a requirement to develop OTBI report for the following fields ( promised date, Requested Date and Receipt date) for po using two OTBI subject areas we are u…
-
Can we end date a role that has been assigned to a user in Oracle Fusion rather than revoking it?Hello Experts, Can we end date a role that has been assigned to a user in Oracle Fusion rather than revoking it? Thanks.
-
How to deliver BI Report output to share point locationSummary: Is it possible to create a share point connection in BI administration so that BI Report output can be delivered directly to share point location.
-
Custom Calculated Measure to Sum Two Calculated Measure Fields Not Calculating CorrectlySummary: I want to have a column called, "Total Costs" which sums the amounts from two calculated measure fields but for values where one of the calculated measure field… -
Replacement for FscmTopModelAM.ItemCostDailyAM.ItemCostDailyPVOSummary: With the loss of data availability for this PVO in 24A (see Document 2998181.1 (oracle.com)) our PECSV files are coming back with 0 rows, i.e. the table is no l… -
Moved: How to provide a Procurement Requester access to OTBI report creation?This discussion has been moved. -
Inquiry- Extracting data from Essbase cube and database tables.Summary: Inquire data from essbase cube balances based on mappings stored in database table. Content (please ensure you mask any confidential information): We have a req…
-
ERP Adaptor service to get Parameter Values of ESS JobHi, Is there an out of the box service (in ERP adaptr or REST API) to get the parameter details of the ESS Job if we provide the ProcessID ErpIntegrationService --> getE…
-
OTBI Performance - Project Cross Subject Area - Date Filters Affecting Performance very badSummary: Using Projects - Cross Subject Area Analysis - Real Time there are severe performance issues filtering by accounting date less than or equal to. There is same … -
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…
-
User Role Memberships Report - possible location in OTBI?Apart from the scheduled process, the report can be seen. Is it also possible to locate this in OTBI?
-
Inactive User Report - Is it possible to see this in OTBI?Inactive User Report - Apart from the scheduled process, the report can be seen. Is it also possible to see this in OTBI? If yes, where is the path name?
-
how to add attachment column in bank account creation of register supplier page in fusionSummary: how to add attachment column in bank account creation of register supplier page in fusion Content (please ensure you mask any confidential information): Hi All,…
-
Merging Prompts in Financial ReportSummary: Merging prompts from two grids in Financial Reporting Studio Hi I have a Financial Report developed in Financial Reporting Web Studio with two grids and I am wo…
-
Moved: Cost Accounting subject areaThis discussion has been moved.
-
How to default the Parameters in Job set while schedulingwe have created a jobset and if we want schedule that we need to pass parameters. But unable to default the parameters and not able to schedule it.
-
Moved: How to create AOR based transaction console BI report in oracle fusion hcmThis discussion has been moved. -
Moved: Dashboard access and rolesThis discussion has been moved.
-
Deliver BIP report to sharepointSummary: Ability to deliver BIP report to sharepoint seems possible, but documentation is from 2007 and doesn't seem to line up with current sharepoint screens. Content … -
Define a global function in BI reportsDear All, Is there a way to define a global function in BI reports to use it across all reports? For instance, NLS_NUMERIC_CHARACTERS?
-
Error when invoking ESSWebService submitRequest method from SoapUiHi, I'm trying to submit a request to run the job "ItalianSalesVatRegister" and I receive the following error: oracle.as.scheduler.RuntimeServiceAccessControlException: …
-
End date or disable a primary ledger in FusionSummary End date or disable a primary ledger in FusionContent Hi Team, There is a requirement from client to remove the not required ledgers from the system. Is there a …