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: 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 acces… -
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…
-
How can we determine if the BIP report has reached/hit a certain number of billion logical I/O?Summary: We received a notification from Oracle that the one of our report is running for more than 5 hours or exceeding 4 billion Logical I/O. Hence, the report needs t…
-
Moved: How to add background color BIP excel template row wise in HCMThis discussion has been moved. -
SQL query tunningHi, I have developed a sql query to get the balance for a couple of months ( it may be up to 12 months) and it's taking more than 40 mins and ended up with timeout error…
-
Moved: I can't find rest APIS to get some columns in work structures, person and assignmentsThis discussion has been moved.
-
OTBI how to assign roleSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
I want to be able to access the to address/recipient used in a delivered workflow notificationHi I want to be able to access the to address/recipient used in a delivered workflow notification from back end tables I tried using FA_FUSION_SOAINFRA.WFMESSAGEATTRIBUT…
-
How to find indexes really used in OTBI - Subject Areas ?Summary: How to find indexes really used in OTBI - Subject Areas ? The document R13_23D_FIN_OTBI_database_mapping_with ViewObjects.xlsx doesn't give really indexes used … -
Deeps links for payable invoicei want to create a payable report when i click on invoice number open a new windows have the invoice deatils i want a deeps link for the payable infoices
-
FRS with records exclusion for given company/PBSSummary: is it possible with FRS to exclude certain CoA records for one PBS value but include for other PBS value? Content (please ensure you mask any confidential infor… -
How Purge Interface Tables Program selects submitted by user?Summary: How Purge Interface tables select the user to schedule maintenance Purge with following arguments? Argument1 =1111 Argument6 = ORA_MAINTAIN Argument7 = SYSTEM A…
-
which table stores the information of Fusion Middleware Error Messages ReferenceWe wanted to find oracle Fusion Middleware Error Messages Reference code and thier meanings from backend tables. While performing any transaction in our fusion instance …
-
OTBI Report analysisSummary: I have created mostly Reports development in Oracle BiPublisher. Where i used to show prompt input parameters in Reports and formatting easily with multiple gro…
-
Moved: BI Publisher Notification - PO ApprovalThis discussion has been moved.
-
Executing dynamic queryHi, We have a requirement to execute dynamic query using BIP in oracle ERP Saas and was going through this (Doc ID 2636492.1) which says passing dynamic query as paramet…
-
Report output name incorrect when downloading scheduled job outputs after upgrade to 23DSummary: We scheduled reports and when downloading it is generating name with % instead of space , but when republished it gives correct name for output file after upgra… -
Slowness of report after upgrade to 23DSummary: A report which ran in less than a minute in 23c is taking 12 mins to complete for the same data post upgrade to 23D. We had 23D upgrade in all non-prod PODs and…
-
How to get green check mark and Time along with Digital Signature in Oracle BIPI have a requirement to print the Digital Signature with Green Check mark and Time using RTF Template in BI Publisher(Sample Attached). Let me know how can we achieve th…
-
Moved: Advanced Search hyperlink within LOV for VBCS screenThis discussion has been moved.
-
Unable to retrieve information stored in the user session variables can be retrieved via SQLSummary: We are creating custom infolets and deploying them on the landing page as a part of our implementation. These infolets have parameter prompts. We wanted to popu…
-
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…
-
Republish option not enabled in scheduled BIP reportsIn some of the scheduled BIP reports with excel template, the 'Republish' option is not enabled. Even after checking Save Data for Republishing, clicking on 'Republish' …