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
-
OTBI report is taking very long time to complete.I have built one Payroll OTBI report. I have been able to run it successfully from my private folder in the Prod environment, but when we load it to the Payroll Team fol… -
User should be able to create a new OTBI Report(Analysis) but will not be able to edit the existing.Our requirement: We need to create a custom role in which a user should be able to create OTBI Reports by using subject area "Procurement- Procure To Pay Real Time" but …
-
Moved: can we audit Allowed Email Recipient DomainsThis discussion has been moved.
-
How to escape double quote character in .csv file of BIP ReportSummary: We have enclosed few columns of the BIP report within double quotes and output is expected in a csv file. This will overcome the columns having comma getting sp…
-
How to download entire Data ModelsHello, We have created an update of a very complex data model and would like to compare it with the old one. We remember that in the previous versions it was possible to…
-
Question about Fusion Applications Cloud Suite Maintenance Pack Documentation (Doc ID 2816277.1)Summary: Question about Oracle Fusion Applications Cloud Suite Maintenance Pack Documentation (Doc ID 2816277.1) Content (please ensure you mask any confidential informa…
-
We need to display the Tax Rate value of the Purchase Order line in OTBI.Summary: We need to display the Tax Rate value of the Purchase Order line in OTBI. So, we need to find out the subject area that we can create OTBI and display the value…
-
Auditing the data access set accessesWe have enabled Audit for Oracle Platform Security Services. However, we are unable to see the data access set access changes/updates in the Audit Report. We want to aud…
-
Is there any table to store the data model SQL query used while creating a reportSummary: Want to identify a particluar condition being incorporated in all the BIP data models ,once identified it can be replaced as per the requirement . Otherwise we …
-
BIP Schedule Data Parameters for the Previous MonthSummary: BIP Schedule Data Parameters for the Previous Month Content (please ensure you mask any confidential information): I am looking to use date parameters on a BIP …
-
Oracle Fusion Table for - po_employee_hierarchies and ap_cardsTeam, We are building the dashboard for procurement in the Oracle Fusion by referring to the Oracle note query - 'My Group's Requisitions In iProcurement ( Doc ID 312425…
-
Can provide READ ONLY option for report/ layout and data modelSummary: Can provide READ ONLY option for report/ layout and data model Can provide READ ONLY option for report/ layout and data model?
-
The Picture can't be displayed error in multi sheet excel templateI created an excel template which has multi tabs created dynamically. Logo in first tab displays fine while in rest of the tabs it displays error The Picture can't be di…
-
Asset cost and reserve detail ReportSummary: I am currently working on a custom report where I need to include asset cost, reserve details, and a summary report. However, I am unsure about how to obtain th…
-
unable to get BIP Excel output and ends with error file format and extension dont matchSummary: when BIP Excel output is generated, the xls output ends with an error as "the file format and extension 'filename.xls' dont match. when the dialogue button is a…
-
sql to use in custom BIP report to restrict data dynamically based on the users data security&accessWe are trying to build an custom BIP report/sql script to restrict data dynamically based on the users roles and their data access in fusion (for example, to query AP in…
-
How to go up from JELINE_ROW to CCID_S in my xml on my rtf templateSummary: Going up a level or two of my xml on my rtf template Content (please ensure you mask any confidential information): I have customised the Account Analysis rtf. …
-
How does user level data security work in Fusion Financials BI PublisherSummary: Trying to confirm if I understand the correct way data security works for BIP reports in Fusion as its not working as expected Content (please ensure you mask a…
-
How to find list of roles which gives access to specific task like 'Create Journal'Summary: How to find list of roles which gives access to specific task like 'Create Journal' Content (please ensure you mask any confidential information): Usually throu… -
Moved: Requisition Approval Rule Report that includes all other tasksThis discussion has been moved. -
Table name for auto provisioning data access setsWe have configured data provisioning rules for data access sets. While trying to download all the auto configured data sets rules, its downloads only 10% of the rules an… -
Moved: what is the link between main negotion number with negotion number whic has multiple rounds …This discussion has been moved.
-
Is it possible to grant access to a subject area from Administration/Security/Manage Privileges?Summary: If I want to grant access to all employees to one certain subject area (that really has no harmful or sensitive data 😄), is it then possible to give them access…
-
Risk Management Access Point Report was running more than a day. Is this correct behavior. ?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
How to merge customer names with transactions in a grouped SQL query?Hello, I have this customer ABC having multiple transaction i want to merge the cells that have the same customer name and make it appear one time, i am using select fro…
-
How to audit who assigned role to a userSummary: How to audit changes made for user. For eg : Adding or Deleted role for a user under SaaS Fusion Accounting Hub Content (please ensure you mask any confidential…
-
How to suppress '0' amount rows from the ess job 'Extracts General Ledger Cube Balances'Summary: Hi All, We are getting error while running 'Extracts General Ledger Cube Balances' ess job which is extracting the lines with '0' amount period activity as well…
-
Option to display Preferred Name in ERP ScreensHi, We would like to know if there is an option to display Preferred name in the List of Values in ERP(Finance and Procurement) Screens(Eg: in List of Values pertaining …
-
Burst to multiple destinationsSummary: Burst to multiple destinations Content (please ensure you mask any confidential information): Hello - We use Fusion BIP application for ERP. I wanted to know if…
-
segregation of access within BI Reporting (Reports and Analytics)Summary: Requirement to segregate the access in Reports and Analytics such that user who can deploy the reports to PROD, user who can manage the reports (edit/delete) an…