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
-
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 …
-
List of seeded reports & analyses for Procurement Contracts/ Enterprise Contracts module in oracle fSummary List of seeded reports & analyses for Procurement Contracts/ Enterprise Contracts module in oracle fusionContent Hi, Is there any way to get the list of all the …
-
BIP report output with 0 KB.Summary: We have a custom BIP report with a datamodel. The data could be seen when viewed in the data tab of the DM. When the report was ran in the BIP (using the schedu… -
Moved: Analysis to retrieve total element amount per month and yearly trendThis discussion has been moved.
-
ISO Format for the positive pay templateSummary ISO Format for the positive pay templateContent Hello All, We got a requirement for the positive pay in the ISO format but as of now we have only an etext seeded… -
Moved: Pivot using Mulitiple groupsThis discussion has been moved.
-
-
Joining Subledger data with GL dataI need to build a query which joins subledger data table, xla_ae_lines to gl_je_lines. I am attempting this through gl_sl_link_id but the performance is awful, is there …
-
Moved: Supplier Recon reportThis discussion has been moved.
-
how to convert number in words in erpIn BIP report in cloud , we have to print one amount column in words. We have used the condition as below to convert it , but unfortunately it works upto one limit and l…
-
Performance impact while using standard viewsSummary: Is there any performance impact while using the standard views (in a BIP report) listed by Oracle. For eg. using standard view PJF_PROJECTS_ALL_VL, instead of t…
-
Moved: TOOLS > audit reports - ORACLE PLATFORM SS > ADD/REMOVE ROLE MEMBERSHIPThis discussion has been moved.
-
How to add below roles (ServiceDeveloper,BIACM_ADMIN,Image_Role) i don't see in those rolesHow to add below roles (ServiceDeveloper,BIACM_ADMIN,Image_Role) i don't see in those roles
-
Moved: Reporting on Approval Transactions outside HCMThis discussion has been moved.
-
Unable to find Award Open and Close date, and Award Approval Date in OTBIHello, I am working on an OTBI report that requires the following fields: Award Approval Date Award Open Date Award Close Date I was unable to locate them in the Procure…
-
Can you use temporary tables in cloud fusion otbi?Summary: Can we use temporary tables in cloud OTBI as a replacement for multiple union select statements Content (please ensure you mask any confidential information): W…