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
-
Not able to add Budget Values(amount) column in FRS Report.We have an FRS Report for Profit & Loss Account where the accounted values are reflected. We have a requirement to add Budget Values also in the FRS, but we have tried e… -
General Guidance on BICC/BIP for PVO JoinsSummary: General guidance on Fusion BICC/BIP for PVO joins & if Fusion supports AI/ML analytics? Content (please ensure you mask any confidential information): My unders…
-
removeposted to the wrong place!
-
Link between XLA, FA and supplier detailsSummary: Link between XLA, FA and supplier details Content (please ensure you mask any confidential information): We have a requirement to fetch the XLA accounted DR, CR…
-
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…
-
Issues with Expense Report DFF's in BI Publisher?Summary: In our expense reports, we have several DFF's set up to pull information regarding miles travelled for airfare, car and rail. The fields show up in OTBI, but no… -
Need Help on Source Table for Manage Common Options for Payables and Procurement:Summary: need to find table for Manage Common Options for Payables and Procurement. want value for default distributions -liability, prepayment Content (please ensure yo…
-
How to change hyperlink of Report on dashboard?For one of my customer on test instance, report icon on dashboard is navigation to production report link. Need to change the link hyperlink for the report. Please help …
-
Statement of Change in EquityHi, Can we generate Statement of Change in Equity in Oracle Cloud Financials, like refer to below link https://docs.oracle.com/en/applications/jd-edwards/localizations/9…
-
Sql to reconcile Receivable Invoices' balances with their applied receiptsSo, I have constructed a sql query to look at Receivables balances using ra_customer_trx_all and ar_payment_schedules_all. I have another query which I tried to summaris…
-
Recommended properties/parameters for an image to be used in RTF template of BI PublisherHello Oracle Experts, We are working on with updating the template for PO print to add logo/images. As such, may we know if there are any recommended properties for the …
-
Looking for some prebuilt dashboard for AP productivity metric in FAW(FDI)Summary: Productivity metrics like no. of invoices by processor Content (please ensure you mask any confidential information): Version (include the version you are using…
-
Unable to see the DFF attribute which are based on Table type value set in the OTBI subject areaHi All, We have created a few custom DFF attributes under Manage Customer Account Descriptive Flexfields. Few are based on independent value sets, and few use table-type… -
Oracle will update BI Publisher-based notifications to Redwood-based BI Publisher.Summary: We have received the notification that in Oracle Fusion Cloud Update 25A, Oracle will update the few BI Publisher-based notifications to Redwood-based BI Publis…
-
The following KFF segments has set up issues and needs to be resolved before BI extender can be runSummary: We are running: Import Oracle Fusion Data Extensions for Transactional Business Intelligence Output file shows this error: Why are we seeing these errors?. We a…
-
Assets - The following segment labels have misspelled BI Object Name setSummary: Hi What are correct spelled BI Object Name set for Assets. I have hit the following error: Regards, Bo Content (please ensure you mask any confidential informat…
-
Can an OTBI report have a sub-total lines?Summary: I have created an LD Schedule OTBI report where I need to insert a sub-total by Employee the percentage of effort. Can someone share how I can add that in the A… -
When passing a parameter to OTBI analysis in Page Composer it is not filtering as expectedhttps://us.v-cdn.net/6034893/uploads/VNVUPJS8577O/obti-analysis-embedded-into-bpa-change-order.docx Description: I am trying to do page customization using the page comp…
-
Getting 403 Forbidden calling BI Pulisher service (ExternalReportWSSService) ?Summary: While calling BI Publisher soap service (ExternalReportWSSService) using JAVA API (jax-ws), we are getting 403 forbidden error. This was working fine earlier, Q…
-
R13.x HCM BI Cloud Adapter BI View Object to Database Lineage Mapping SpreadsheetSummary: 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 Reduce Sftp Bursting completion times.Hi Team, We would like to inquire if there are any options to reduce SFTP bursting completion times. Currently, we are trying to place 10K files into an SFTP folder usin…
-
INV_MATERIAL_TXNSSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Set default value for LOV to NULLI have a BIP report with multiple LOV parameters. When data-model/report is opened all LOV parameters are set to ALL by default, I need these parameters to be set to NUL…
-
Nees SQL query to get the transaction status of Intercompany transactionsHi team, I'm creating a BIP report to extract intercompany transactions and related details. I need to join 'AP_INVOICES_ALL' or 'XLA_AE_LINES' table to 'FUN_TRX_HEADERS…
-
How to schedule a custom weekly GL report, which includes date parameter of "PostedDate-7"Summary: Custom GL Report which needs to run at 12:05 AM weekly on Tues night and include data only from the previous week. If PostedDate = Aug 6, the report should incl…
-
Best approach to create a report templateHi everyone, I’m seeking advice on the best approach to create a report template with the following requirements (Bi Pulisher report): Year-to-Date (YTD) totals Subtotal…
-
ERP Sofware Version and NameSummary: I need to include the ERP application name and version in a custom report. Does anyone know if this information can be queried? Specifically, I'm looking for th…
-
CUPS Server Printer Setup in ERP BIPSummary: Hi Team, we have below requirement and need to understand. Can some one please help on this. The print server has been installed in Azure with the CUPS service …
-
Digital Signature showing invalid for Adobe Acrobat ReaderSummary: Digital signature showing invalid when viewed in Adobe Acrobat Reader Content (please ensure you mask any confidential information): Digital Signature showing i…
-
ESS Job to default the output to Email address when submitting the job on demandSummary: Hello ! We have a BI report as an ESS Job, the requirement is to default the email address and the subject and the BI report output (XLS) in this case needs to …