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
-
We need to perform a mass update of the Taxpayer Identification Number (TIN) for customers in OracleWe need to perform a mass update of the Taxpayer Identification Number (TIN) for customers in Oracle ERP, as per the requirement. We attempted to accomplish this using O… -
ORA-01652: unable to extend temp segment by 128 in tablespace FUSION_TEMPSummary: we have one custom report keeps failing with error ORA-01652: unable to extend temp segment by 128 in tablespace FUSION_TEMP in saas application. could you plea…
-
PVO BankAccountExtractPVO returns bank account data in OTBI - Issue SQL but no data via BICCNeed to identify missing privilege or profile. PVO FscmTopModelAM.FinExtractAM.CeBiccExtractAM.BankAccountExtractPVO not returning data via BICC. In Fusion > Tools > Rep…
-
OTBI Drill Down for AR_Transaction does not work with VIEW actionSummary: OTBI Drill Down for AR_Transaction does not work with VIEW action. It works with the EDIT action. It shows in Deep Links (under Tools) that it's a valid action.…
-
Active Invoice in Oracle Fusion with inactive Code combinationsSummary:3-37815901131 : Reports for Inactive GL Code Combinations Problem Summary: Assistance Needed with Invoice Approval Status I am seeking assistance in identifying …
-
How to join requisition and purchase order tablesI am using POR_REQUISITION_HEADERS_ALL and PO_HEADERS_ALL to get requisition data and related po data if present. But there is no join between given tables. Please sugge…
-
Is there a way to predefine calculations in oracle cloud ERP for FRS reportsMost of our Financial reports built using Oracle FRS Web studio are driven by calculations. Managing custom reports becoming more and more difficult whenever there is a … -
Data Extraction Approach for Oracle tables that doesn't have PVO'sProblem We need to understand what is the best Data Extraction Approach for Oracle tables that doesn't have PVO's Came across below approaches: Approach 1: Steps: 1. Cre…
-
TSA SQL filter not working when field has date AND timeSummary: Report requirement for all supplier sites set up in last 30 days - issue with TSA SQL filter Content (please ensure you mask any confidential information): I ha…
-
logo in OTBISummary: I am trying to load a logo image on an OTBI Report, I am getting this error. "The file uploaded may contain a virus or otherwise failed to be scanned for viruse…
-
Which table does PO notification report extract data fromDear support, I found in Purchase Order Notification report, sometimes the data is extracted from table PO_HEADERS_ALL and PO_LINES_ALL, sometimes the data is from table…
-
Access to Project Budget vs Actual and Project Capital Costs reportIs there a specific privilege or data policy to access Project Budget vs Actual and Project Capital Costs report? Project Accountant gives us access however it has too m…
-
Is Project Number for AP available in General Ledger or Subledger Accounting Subject AreaGood Day Experts, Is project number field for AP available in General Ledger or Subledger Accounting Real Time subject area? Just like the PO Number for AP where I can g…
-
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 …
-
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…
-
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…
-
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…