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
-
Combine OTBI and BIP report, role issue/quesitonSummary: I have created a report where I combine OTBI and BIP report in one BIP datamodel. This is due to missing information on OTBI side. Report works as a charm but l… -
Is it possible to BICC Export a file to FTPSThe client need a way to download/export the BICC file from UCM to client File Transfer Protocol Server. Is there any way to do this? -
Table to find PO line level attachmentsSummary: We can see line level attachments on the PO page. However, we don't see the attachment details for all the lines in the fnd_attached_documents table. We also ch… -
Can we assign bulk roles to user accounts ( not employees)Summary: Hello All, Can we bulk assign roles to users those are not employees in fusion? Content (please ensure you mask any confidential information): Version (include … -
Conditionally display columns in an BIP etext rtf template.Summary: Example out of 50 columns, first 30 and last 10 columns will show up always and 10 columns in the middle will show up only on a certain condition. Note: The req… -
What tables should I consult to relate the details of budget control associated with obligations ...Summary: We are developing a report in Oracle Publisher related to budget control, but we are unable to find the necessary documentation. We need information on Budget T…
-
FRS report for particular ledger and Period not returning Data. What may be the reasonSummary: FRS report for particular ledger and Period not returning Data Content (please ensure you mask any confidential information): Summary: FRS report for particular…
-
Oracle SaaS metric-descriptions-fusion-offeringsSummary: Hello Team, We are in a need of support to get information on following points. Scenario: We are in a need of adding these 2 privileges in our custom role ‘View…
-
display hyperlink in messagesHello I am creating a new message from Manage messages and I am retrieving this message from BI query. I would like to have a hyperlink in the message when I am creating… -
GL Account Analysis Report lexical parameter valuesI would like to explore the option of splitting the report output file into multiple files for the account analysis report. Could you please provide the values that need… -
OTBI Prompt - Default Programmatically setting dateSummary: When adding in an accounting period, I'm not able to programmatically set a date with the format YYYY-MM. I've tried a few different things but I can't seem to …
-
talent profileSummary: hi, Could I get the pending transaction data (includes items data) which is under approval for employee talent profile. Content (please ensure you mask any conf…
-
BI Publisher Pivot Table Limit/Configuration of able to add only 5 columnsSummary: 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 output of a BIP Report in multiple excel sheets in XLSX format?Hi we would like to know if there is the way to output of a BIP Report in multiple excel sheets in .XLSX format. Currentry we can see only .XLS format is avaiable when E…
-
Is it possible to create a customer index on Oracle Cloud ERP seeded tables?Summary: We are currently using a BIP report to extract recently created transactions from ra_customer_trx_lines_all, relying on the last_updated_date field. The report …
-
How can I add the from date of a role and the user that gave the role to a report?Summary: I am looking to add the date a role was given to an employee and who gave the employee that role to a report for security. The date would be the auto populated …
-
concatenate data elements with line break in BI excel templateSummary: It is concatenating with supp_name,supp_name2,supp_name3 columns separated by ',' . In my case comma "," also displaying for null cases. Hence i am trying to d…
-
Request for Custom SQL Query for SaaS Service Usage Metric Report (Oracle Fusion Expenses)Hello Team, We are in a need of a custom sql query which Oracle uses to populate a count for the below service in the SaaS Service Usage Metric Report, as we got to know…
-
Is it possible to enable audit and tracking of all user activity?Summary: Business requires all user activity regardless of module and transaction within the Fusion SAAS ERP to be tracked. Is there a way to achieve this functionality?…
-
Is it possible to set separate Permissions for My Folder and Custom folder (under Shared Folders)?Summary: The requirement is to provide access to create Data Model, Report and Analysis under My Folder in Oracle BI Catalog and for the same user provide read-only acce…
-
Any one has idea on Pivot table in rtf, need some help on itAny one has idea on Pivot table in rtf, need some help on it. It is allowing only 5 columns, can we extend it more than 5 columns and also grouping data , need it to be …
-
Oracle BICC not providing PVO's for IEX tables of AR ModuleHi Team, Currently we are consuming Fusion FSCM data via BICC console for loading data to our warehouse. We are able to load all data related to Customer, AR Invoices ,R…
-
How to have a fixed table for stub before check regardless of the number of invoicesSummary: We have a business requirement to create a custom in-house check wherein the remittance table is causing the check to shift and overflow to the 2nd page. We nee…
-
How to run Audit Type Reports by EPM Automate or by RestAPI for EDMCSSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Which table contains future budget period amount details?Summary: Hi Experts, We need to retrieve budget amount, actual amount and commitment amount for future budget periods for a report, these are the fields we see in the be…
-
Why the printing from the fusion is different from a laptop to another ?!Summary: I've tried to print a report from the fusion (its layout is made by the word in a RTF format) and it's been printed correctly on my laptop but the other laptops…
-
sSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Oracle OTBI Report View does not run for wider searchThe only table/view I have been able to identify, that provides OTBI report usage statistics is the BIPUBLISHER_V view as provided by Oracle. This view consistently eith…
-
Fetching Flow Through Funds fields under Grants module in Base tablesWe are unable to fetch values in Base tables for Flow-Through Funds fields like Sponsor , Reference Award Name, Amount under Grants module. PFB the required fields viewe…
-
How to get count in pivot table in rtf templateHow to get count in pivot table in rtf template