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
-
Excel template with multiple sheets in outputSummary: I require my excel template to push out multiple sheets. One for each business unit with underlying customer transactional data per business unit sheet. Content… -
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… -
Burst to multiple email addresses stored in a parameterSummary: Burst to multiple email addresses stored in a parameter Content (please ensure you mask any confidential information): I would like to have Bursting to multiple…
-
how to display clob data in oracle in readable formatSummary: My results are not as expected even i I followed the below link https://docs.oracle.com/middleware/12212/bip/BIPDM/GUID-6C8C333C-FF56-4376-9914-C298DF0DCE83.htm…
-
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