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
-
NEW REPORT: Journal and Transaction Details ReportSummary: The Journal and Transaction Details report lists general ledger journals and subledger transactions activity along with header, line, and distribution-level det…Abhijit Dhakephalkar Gr Manager Financials Product Management-Oracle 3.6K views 87 comments 10 points Most recent by ERP & EPM Cloud -
Budgetary Control Balances OTBI with Deep Link Sample ReportSummary: Content (required): The Budget Balances OTBI with Deep Link Sample Report Kit contains a sample report embedded with a deep link to Review Budgetary Control Tra… -
Open-source fonts to replace licensed Monotype fonts in BIP and OTBI in 24AIn 24A, open-source fonts will replace the Monotype fonts currently available in Oracle Transactional Business Intelligence. You can use the open-source fonts available … -
Sample OTBI dashboard and reports for Joint Venture Management TransactionsSummary An OTBI dashboard with a detailed and summary report for Joint Venture Management Transactions. Content You can import the attached catalog file into a Cloud ERP… -
Query to audit delegation for requisitionsSummary: Query to audit delegation for requisitions Content (please ensure you mask any confidential information):Hello, I want to prepare an Audit report for Delegation…
-
how get query manage locationsCan someone help me with the query to obtain the information shown in the "manage locations" option? Basic details name status code Main address Main address usage type …
-
SOAP Web Service to download attachmentsSummary: I'm trying to download attachments using ERP Object Attachment Service (https://docs.oracle.com/en/cloud/saas/financials/24a/oeswf/erpobjectattachmentservice-d1…
-
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 … -
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 …
-
line managers are unable to view any data from my team - team skills centerSummary: line managers are unable to view any data from my team - team skills center although one of his directs has skills data be he is even unable to view his directs…
-
Tables of ESS/BIP jobs and their parameters in Oracle fusionSummary Please share the tables in which the parameters of the ESS and BIP Jobs submitted are saved.Content Please share the tables in which the ESS and BIP Jobs, and th…
-
in the account analysis report when the category payroll the line description is blankedSummary: in the account analysis report when the category payroll the line description is blanked, from where we can fill the data for Line description Content (please e…
-
How to search/ filter two columns with single Table Prompt in OTBI analysisProblem: There is a business requirement to search Bank Account Number (which can be set up either at Customer Account level or Customer Site level) using single Table P… -
ERP Period Close White Paper with Runbook Considerations (Doc ID 2506148.1)Summary Updated documentation availableContent Hi, Please note that we have posted an updated Period End document (21C) onto MOS 2506148.1 today. Also, based on customer…
-
R13.x FSCM BI Cloud Adapter BI View Object to Database Lineage Mapping SpreadsheetSummary This posting includes R13 FSCM BI Cloud Adapter BI view object to database lineage mapping. Content This spreadsheet is published by Oracle BI Cloud Adapter Deve…
-
OTBI - Retired Fixed Asset with Source Line DetailSummary: In Asset Transactions Real Time we would like analyze retired assets with the source line details (project number, invoice number,etc.). The source line detail …
-
How can we assign ESS jobs (request Groups) for scheduling without adding Roles to user account?Summary How can we assign ESS jobs (request Groups) for scheduling without adding Roles to user account?Content In EBS we used to assign Custom Request Groups to a speci…
-
Use the ESS web service to schedule a job for running the BI cloud extractsSummary: We have been attempting to run a BICC based job from a SOAP\API call using something similar to the ErpIntegrationService submitESSJobRequest SOAP function but …
-
How can I access the list of EU countries?I have a query; SELECT * FROM hz_geographies WHERE geography_type IN ('ECONOMIC REGIONS') I want to question the countries within the EU. However, when I run the query, …
-
Smart View handled an unknown exception thrown by Microsoft OfficeSummary Smart View error using ExcelContent Hi, I'm using Smart View version 11.1.2.5.910 with Microsoft Office Standard 2016, I'm constantly receiving this error "Smart… -
Smart View handled an unknown exception thrown by Microsoft OfficeSummary: Smart View Error - Smart View handled an unknown exception thrown by Microsoft Office Content (please ensure you mask any confidential information): Steps to re…
-
Latest Invoice Date by Supplier - OTBISummary: I need a report that shows the latest supplier activity by either invoice date or po creation date, in aggregate form Content (please ensure you mask any confid… -
Issue Fetching Accounting Period in FRS Report HeaderSummary: Hello, While attempting to use the MemberName function in the header of an FRS report to display the Accounting Period selected in the grid, I am encountering t… -
Inactive User Account shows as 'Active' and 'Suspended' on all HCM ReportsSummary Inactive User Account shows as 'Active' and 'Suspended' on all HCM ReportsContent Hi, I have business requirement to inactivate a person user account, but not re…
-
SQL Query or table for User CategorySummary SQL Query or table for User CategoryContent I need to create a query that extracts the information of the user and the user category it's under
-
OTBI - Issue while submitting Custom report - Asset Cost DetailSummary Error while selecting parameters for Custom OTBI report which was copied from Asset Cost Detail reportContent Error while selecting parameters for Custom OTBI re… -
Cross validation Rule extract by report / SQL querySummary Need report/SQL query for extracting Cross validation rulesContent I am looking for Cross-validation report or SQL Query to extract all cross-validation rules at…
-
Ljava.lang.Object; is passed when multiple values are seleted in parameter in oracle BIP reportSummary: Hi Everyone, We have created a custom BIP report that will trigger the OIC integration from the Data model. We are passing a few parameters to the report. One o… -
How to get data for Audit Reasons column in OTBI like the Expense Auditor Dashboard ?Summary: We are working on a custom dashboard for Expense auditors and one of the fields requested in 'Audit Reasons'. The subject area 'Expense- Expense Transactions Re… -
Journal approval and rejection reportSummary: Do we a report in Oracle that provide information on journals which were submitted for approval and have been rejected. If not can anyone share any queries wher…
-
Table name that holds the Supplier Site Purchasing Tab dataSummary: Table name that holds the Supplier Site Purchasing Tab data Content (required): I'm trying to create a BI Report to monitor when PO's are not communicated out t… -
Create Data Model From View ObjectSummary: We are in an Oracle Fusion Saas environment. I have been looking at the View Object Data Model, We have Data Sources that populate for ERP and HCM in the dropdo…
-
How can i get the underlining sql query for this PVONeed the backend query for this HcmTopModelAnalyticsGlobalAM.HCMExtractAM.AssignmentBiccExtractAM.AssignmentSupervisorExtractPVO in ISSUE SQL it's not coming for this
-
BI Publisher - how to add watermark based on condition in RTFSummary: Content (please ensure you mask any confidential information): Dears , We have a requirement that a watermark to be appeared based on condition , like if the st…