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
-
Moved: Reporting on Approval Transactions outside HCMThis discussion has been moved. -
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… -
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…
-
Moved: Connect Oracle HCM to AlteryxThis discussion has been moved.
-
Scheduled process listWe would like to know the list of ESS jobs are scheduled with start date, end date and email address of users. Oracle suggested to get the time using Oracle customer con…
-
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…
-
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…
-
Set BIP folder/report permissions by RoleSummary: I'm trying to set the permissions on a folder in Reports & Analytics based on Application Role. The specific role I want to use doesn't appear in the list of va…
-
Is it possible to change the date to be used in aging transactions in the seeded AR Aging report?Summary: Is it possible to change the date to be used in aging transactions in the seeded AR Aging report? Content (please ensure you mask any confidential information):…
-
Can I change the default attributes of a BICC extraxt file stored in UCM?Summary: I'm creating 2 extracts of BICC sourced from the same PVO for 2 different purposes, this is creating files with the same name. I need to download the files and …
-
Can I change the default attributes of a BICC extraxt file stored in UCM?Summary: I'm creating 2 extracts of BICC sourced from the same PVO for 2 different purposes, this is creating files with the same name. I need to download the files and …
-
Is there a not equal operator for Query By Example?Summary: Is there a not equal to operator for query by example? Content (please ensure you mask any confidential information): We've had a few users request a not equal … -
Query to fetch accounting period on project cost page in fusionSummary: Query to fetch accounting period on project cost page in fusion Content (please ensure you mask any confidential information): Hi Team, I am looking for query /…
-
How to join from Subledger Accounting (XLA) to transaction application entity code PJBACCOUNTINGSummary: Hi, How do we join to get transaction details in the subledger application from XLA_TRANSACTION_ENTITIES where SOURCE_APPLICATION_ID = '10036' (Project Accounti… -
Unable to view the data in data model with lexical parameterSummary: Unable to view the data in data model with lexical parameter Content (please ensure you mask any confidential information): Hi, We are trying to create a BI rep…
-
How to extact segment 2 from code_Combination_description in my xml fileSummary: How to extact segment 2 from code_Combination_description in my xml file Content (please ensure you mask any confidential information): My xml stores the code c…
-
How we can invoke multiple templates/Grids in FRS reporting based on the input parameters ?how we can invoke multiple templates in FRS reporting based on the input parameters. Unfortunately, we have not found any functionality to invoke multiple templates like…
-
Moved: BI Report Migration Not Captured in Audit LogThis discussion has been moved.
-
How to get the IP address of OTBI to add to a SFTP whitelistI am trying to get my OTBI environments IP address so I can whitelist it on a SFTP site. I found documentation on all the IP address, but I don't know which server I am …
-
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…
-
Customization of 'Print Receivables Transactions' and 'Print Receivables Transactions: Invoices'Summary: Content (please ensure you mask any confidential information): Hi, This is regarding ESS Job 'Print Receivables Transactions' which in turn calls another ESS Jo…
-
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
-
Sql Query to get data security applied on Chart of AccountsHello, I need an sql query to get my user's data security on the chart of accounts values. Thanks,
-
How to pass current ESS Process ID as a Parameter in custom BIP reportSummary: How to pass current ESS Process ID as a Parameter in custom BIP report Content (please ensure you mask any confidential information): Hi Everyone, We have a cus…
-
RTF Template with multiple sheetsSummary: RTF Template must push out results in Excel with mutiple sheets Content (please ensure you mask any confidential information): I have put in place a rtf templat…
-
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… -
Output tab when scheduling a processHello On some standard reports, they don't have Output tab when scheduling the process but some do. Anyone know if we can set the Output tab to display or this is what i…
-
how to create pivot table in a BIP report ?I am creating a work in progress report using BIP. I have projects with costs and revenue distributed on months. how can i get an output like this image. does anyone hav…
-
How to archive entire catalog (Shared and Users)?Summary: With an administrator role, I would like to archive the whole analytics catalog to backup all Analytic Objects (even the objects in users folders). During P2T o… -
R23 ERP OTBI subject areas to database tables mapping spreadsheetsSummary: I am looking for the R23 ERP OTBI subject areas to database tables mapping spreadsheets, R23 SCM OTBI subject areas to database tables mapping spreadsheets and …