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
-
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… -
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.9K views 87 comments 10 points Most recent by ERP & EPM Cloud -
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… -
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… -
How to implement FTP Bursting for Print Receivables TransactionsSummary: How to implement FTP Bursting for Print Receivables Transactions Content (please ensure you mask any confidential information): How to implement FTP Bursting fo… -
BI Publisher Report Returns Data Manually but Outbound Report from OIC Is EmptyI am trying to generate an outbound report for recently imported invoices that were processed through the Import Payables Payment Requests job. I created a BI Publisher … -
In an OTBI analysis, results are different for different usersSummary: In running an OTBI analysis, my manager and I get one set of full results. The user gets only the results that they created (expense reports). How can I see whi… -
Test1-ShivanandThis is temporary Descriptions for all the PDFs and Zip Files -
If a client discontinues HCM but using Finance and SCM, how will user and employee records managed.Summary: Our client is currently using Oracle Fusion applications, including HCM, Finance, and Supply Chain Management (SCM). They are now planning to discontinue Oracle… -
Redwood roadmap for Oracle FinancialsSummary: We would like to know Redwood implementation roadmap for Oracle Financials. It involves lots of planning and effort sooner we know the roadmap it will help cust… -
Bulk report to identify users and roles with access to custom BI Publisher reports.We have over 100+ custom BI Publisher reports across different folders under /Custom . We need an audit extract showing each report’s catalog path, directly assigned and… -
Customizing the standard Negotiation Award Decision Notification doesn't work after upgradeSummary: I customized the standard Negotiation Award Decision Notification by: Adding new columns to the data model and using them in the layout. Adding new sections and… -
Error after migrating FRS report between two lower environmentsSummary: When running report in target environment we get this error: Balance Sheet V1- Error executing query: Error: Internal Essbase JAPI error: [Cannot perform cube v… -
SQL Query to extract username along with roles, data access and security Context in oracle fusion .Summary: I need the table to get security context column values in oracle fusion tables. Currently I am using the table FUN_USER_ROLE_DATA_ASGNMNTS but in this table ins… -
How to create custom folders under General Ledger – Transactional Balances Real Time subject areaSummary: Hi All, There are custom folders created & included like '****_BANK' , '****_ACCOUNT' under the General Ledger – Transactional Balances Real Time subject area. … -
subject area for getting open pick slip detailSummary: subject area for getting open pick slip detail for OTBI report Content (please ensure you mask any confidential information): Version (include the version you a… -
BI user licensing consumptionSummary: Can we provision named users with access exclusively to OTBI and BI Publisher for read-only reporting over Oracle Fusion Financials data, without those users co… -
How to implement Segment Value Data Security in BI Publisher ReportContent Hi All, Can someone provide insights on how to implement implement Segment Value Data Security (SVS) in BI Publisher Report. We have a requirement to create BIP … -
Can we default a parameter with dynamic value in ESS Job definition?Hi, We have a custom ESS Job defined for a BIP Report with a parameter Period Name and attached a custom LOV data source defined which lists the periods from gl_periods.… -
Customize Bill of Lading Report and Packing List ReportSummary: Hello. Has anyone here experienced customizing Bill of Lading Report and Packing List Report to add more fields? How do you get the XML for these two reports an… -
BI Publisher empty column missing from csv outputSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
ORA-01438: value larger than specified precision allowed for this column with BSO to BSOSummary: Hi Oracle Community, We are facing an issue while running a BSO to BSO data integration in Oracle Planning/PBCS. The data extraction from the source BSO cube co… -
Missing Sequence Number in Account Analysis CSV formatSummary: Missing Sequence Number in Account Analysis CSV format Content (please ensure you mask any confidential information): Hi, There is a issue raised where the sequ… -
Manage Receipt Page Customization issueSummary: Content (please ensure you mask any confidential information): Hi All, We have received the following business requirement to customize the Manage Receipts (Cla… -
Is there a field in otbi for the total invoiced amount against a POSummary: When trying to create an analysis in OTBI for Purchase orders, the Invoiced Amount field just brings back the total invoiced value for ALL invoices, not just th… -
Custom ESS job is erroring when there is no data to burst data to FTPCustom ESS job is erroring when there is no data to burst data to FTP. I want the job to be successful when there is no data to send. -
Purchase Order Deeplink does not work for some PO status - BIP ReportsSummary: We are implementing Purchase Order deep links in a BI Publisher report so that users with requester access can navigate directly from the report to the correspo… -
OAuth/JWT for BI Publisher web services before Basic Auth retirementSummary: We call Fusion BI Publisher web services from OIC Gen3: /xmlpserver/services/v2/SecurityService (login), then the ReportService, ScheduleService and CatalogServ… -
Query to fetch the employee assignment history.We require a report that captures the complete assignment change history for employees, along with the associated action codes, details of the attributes that were chang… -
Ledger not visiable in FRSSummary Ledger not visiable in FRSContent Hi, We have 15 ledgers,out 15 only 3 ledgers are available in Financial reporting studio.We are web reporting studio. We have C… -
Requisition List ReportSummary: Requirement to have a report for the requisitions as the manage requisitions page doesn't show the full list of requisitions. Content (please ensure you mask an… -
Encountering below error while adding Segment Description columns.Summary: Encountering below error while adding Segment Description columns. State: HY000. Code: 77031. [nQSError: 77031] Error occurs while calling remote service ADFSer… -
How to send an ESS job output on email?Summary: Need to send an ESS job output (ex: .pdf) on email, to certain people Content (required): Needed functionality: send ESS job output on email. Tried from: Schedu…