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
-
Report on inception to date activity on the Revenue aspect/Invoice aspect Development SOW projectsHello, We have a required to build a BIP report on inception to date activity on the Revenue aspect/Invoice aspect Development SOW projects. We need to fetch the financi… -
OTBI time out for regular user super user runs in 22 secondsSummary: We have an OTBI analysis that we built. Content (please ensure you mask any confidential information) For a super user it runs in 22 seconds, but for a regular … -
How to format date column in Excel Template without adding another columnSummary: I am able to format date column in excel by adding another column and using =DATEVALUE function as suggested in below link, but I want to format date in current…
-
Is there any method to output a certain number of lines without destroying BIP Excel template layoutSummary Is there any setting/method to output a certain number of lines without destroying the BIP Excel template layout? Content Hi, We are conducting feasibility verif…
-
How to give Unarchive option in Custom folder which is read only for a user in BI Catalog?Summary: We have a custom role which gives read only access to the Shared Folders > Custom folder. We also want to provide Unarchive access under the Custom folder. The …
-
query to get a tax registration number for legal entitySummary: query to get the tax registration number for legal entity Content (please ensure you mask any confidential information): I want to create a SQL to retrieve a ta…
-
There is a need to show GL Account and Description in 2 separate columns in FRS ReportThere is a need to show GL Account and Description in 2 separate columns in FRS Report Is there any way to split Account into Account and Description column in FRS report
-
Need sample query to get Original transaction number from credit memosSummary: Need sample query to get Original transaction number from credit memos Content (please ensure you mask any confidential information): need to know about the bac…
-
while creating the custom roles, getting unwanted subject areas in analysisSummary: Hello Experts, Our client has a requirement to create a custom role for restricted access to business users. While doing so, we could see in reports and analyti…
-
Unable to find create data model option after adding related BI rolesSummary: Hi Team, To one of the user account, we wanted to provide access to BI Currently after providing 'BI Administrator Role' and 'BI Publisher Data Model Developer …
-
BIP SFTP Bursting vs BIP SOAP API calloutSummary: Advantages of BIP API download option (for data reports) Vs BIP report sent to SFTP channel Content (please ensure you mask any confidential information): We us…
-
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?…