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
-
Table to get user password expiration dateSummary: Table to get user password expiration date Content (required): Hi All, Which table stores the user password expiration date? The user wants to create a report. … -
campaign emails are still not being delivered to employeesSummary: Hi Team, I am facing an issue with HCM Communicate campaign email delivery in our DEV environment. I created and activated the campaign successfully, scheduled … -
How to include invoice attachments from UCM on bursted email outputI have created a custom email notification for invoices requiring receipts. I am using an RTF template for the email body and would like to include manually uploaded inv…
-
Query to fetch the report columns name in oracle fusion.Is there any query to find the Report columns Name , Report Path, Report Name Oracle fusion. There are various kinds of report present in the instance such as BI report …
-
Advanced CollectionsContent Hello All, Do we have any OTBI subject area which gives data related to Collections. Ex: Collector wise collections. Thanks, Nishanth -
ESS.REQUEST_HISTORY table state column meaningin which oracle fusion financials, Fusion_ORA_ESS.REQUEST_HISTORY there is a columns named 'State' which shows 12,11,10 values. What is meaning of it. It seems that ESS …
-
How to set static/Dynamic password generation for PO-PDF in Oracle FusionSummary: How to set static/Dynamic password generation for PO-PDF in Oracle Fusion A requester received a Purchase Order (PO) change notification, which included the PO …
-
unable to find the ESS Job while creating Request setSummary: Hello, We are creating a request set for an ESS Job. But while creating the request set the ESS Job name is not able to see. Kindly suggest on this for possible…
-
Rest API or SOAP service to list down user folders under /users folders of fusion BIPSummary: We have a requirement to get all user folders and objects under /users (my folders). Is there any way to extract the user folder list. Content (please ensure yo…
-
Where can I get OTBI sample seeded financial reports?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 does "Generate Revenue" determine what accounting date to assign to ProjectsSummary: How does "Generate Revenue" determine what accounting date to assign to Projects Content (please ensure you mask any confidential information): I am trying to u…
-
Is there a report or table which store history or audit on the data access sets granted and revokedSummary: Is there a report or table which store history or audit on the data access sets granted and revoked. We cannot see the any data access set once they are revoked…
-
Financial Reporting Center - Define Tags (GL_FRC_USER_ACCESS_REPORT_TAGS)Summary: Is anyone using the GL_FRC_USER_ACCESS_REPORT_TAGS table in a BI Publisher report? How are tags defined? https://docs.oracle.com/en/cloud/saas/financials/26c/oc… -
How to add dynamic logo to an OTBI analysis ?Summary OTBI Analysis & Dynamic LogoContent Good People, Is there anyway we can add dynamic logo to an OTBI Analysis ? Thanks, Soumya -
Facing performance issue with a query on gl_periods and per_calendar_events tables.On Fusion ERP I have a BIP report with complex query which involvers among others GL_PERIODS and PER_CALENDAR_EVENTS tables. Report parameters are GL Period From and GL … -
Clarification on Oracle AI Vector Search support within Fusion OTBI, FR and BI Publisher reportsWe are seeking clarification on the use of Oracle AI Vector Search (Vector Database capabilities) within Oracle Fusion reporting solutions. Specifically, we would like t…
-
In what subject area can i find the details of a Return Lines (Return to Supplier)Summary: Hi In what subject area can i find the details of a Return Lines (Return to Supplier), specifically the details of the receipt number, RMA, Document Number (PO)…
-
How to know who delete some reports in OTBIA folder containing reports has disappeared from my environment, and we want to know if it was accidentally deleted by a user or where the folder is located.
-
Cross subject area "Receivables - Transactions Real Time" and "Receivables - Customer Real Time", neSummary: Cross subject area "Receivables - Transactions Real Time" and "Receivables - Customer Real Time", need to join the subject area to fetch data as there is no com…
-
Why are some users receiving error:OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P ?Summary: Some users are receiving Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P when attempting to access a OTBI Dashboard. However, other …
-
Guidance Required – Executing Dynamic SQL in Oracle BI Publisher ReportSummary: We have a requirement where business users will maintain extract configurations through a custom Oracle VBCS screen. For each vendor, the users will configure d… -
Is there any way to identify the last usage date of a role assigned to a user in Oracle Fusion CloudHi Team, We have a requirement to identify the last usage date of a specific role assigned to a user in Oracle Fusion Cloud SaaS. We are looking for a way to determine: …
-
How to map new custom data model and Separate Remittance Advice template to PPR process.Summary: I have created new custom data model & template and added it in Disbursement Separate Remittance Advice Formats report. But when run the payrun, still output is…
-
Why OTBI Report export into csv does not keep custom formatted date in output csv fileTitle: OTBI CSV Export Does Not Retain Custom Date Format (MM-dd-yyyy) Description: Hi Team, I have developed an OTBI Analysis report and configured the Invoice Date col…
-
Changes to custom report, replicates in seeded reportHi all, I have encountered a problem while customising reports. -When I create a copy of a custom report ("customise it" using XMLP server) then the seeded object disapp…
-
How to embed logo or image in email body using email bursting querySummary: Need info on Parameter5 of email bursting query can be included with image file or Logo in it. We want company logo to be added along with email body .Please gu…
-
How to grant access to OTBI without granting access to datamodelSummary: Although a custom reporting role strictly restricts the user from creating or editing Data Models, a security gap allows them to delete existing Data Model obje…
-
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 … -
List of FDI seeded ERP groups and users neededSummary: I need below information for FDI, what are the seeded groups & users, will there be any native user and if any service account is required in FDI for integratio…
-
OTBI Reqs Real Time shows PO as blank-unprocessed for req lines that already have a PO createdSummary: We have an OTBI analysis built on the Procurement - Requisitions Real Time subject area used to track unprocessed/overdue PR lines. Several requisition lines ar…