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
-
Fetching Tax Lines Based on AP Distribution Lines and Ship To LocationSummary: I'm trying to determine the correct, delivered method for linking AP_INVOICE_DISTRIBUTIONS_ALL with ZX_LINES in order to retrieve tax amounts at the individual … -
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 …
-
How To Change The Date Format For Date Columns In BICC ExtractSummary: Hi Team, My requirement is to insert the values from the date columns of BICC extract into ATP using DBMS_CLOUD.COPY_DATA functionality. COPY_DATA is not workin…
-
Edit template and add new column in the existing templateHi We have an existing date model with 20 columns and all are selected in the report template. I have added one more column in the DM as per requirement but am not able …
-
Zero values in Finance GL-profitability subject area in FDIWe are getting zero values in net income column, can you please suggest if there is any data load issue in FDI? or suggested any workaround is helpful.
-
How do I create an aged report for open transfer orders in OTBISummary: I am trying to create an OTBI Analysis for Open Transfer Orders. We would like to see a count by destination, date, cost of inventory item and possibly the GL A…
-
In Job Details need Travel Required fieldSummary: 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 Remove Blank Spaces Appearing from Hidden Conditional Tables in RTF TemplateI have an RTF template with 3 separate tables that display conditionally based on a parameter (ITEM, ASSET, WorkOrder). When one table is selected, the other two are hid…
-
Which exact privilege or duty role allows user to access Security dashboard?Summary: We want to give user access to below seeded reports. Currently "Application Implementation Consultant" gives that access but we cannot assign the role due to ot…
-
Fetch OTBI report output in csv format to transfer to 3rd party serverHow can we fetch OTBI report output in csv or any other format(not xml) and transfer to 3rd party vendor server(using OIC SFTP adapter). Tried to use ****.oraclecloud.co…
-
Error generating view. Error getting cursor in GenerateHeadSummary: We are stuck with this error: I have executed these processes: Publish Chart of Account Dimension Members and Hierarchies to Balances Cubes Create Rules XML Fil…
-
Sql query to get PO Change Order line Details.Summary: https://us.v-cdn.net/6034893/uploads/BATNEQXAX0VY/change-order-fields.docx Required sql query to get following PO Change Order line Details. Columns: Attribute …
-
What is the Business flow for Direct debits receipts up on bank acknowledgmentSummary: While creating a receipts in AR using PAD(Preauthorized debit)method, we need to know the status of receipts and invoices status when bank subsequently sends ba…
-
Custom Purchase Order template works fine when PO is in Draft status but does not work when PO movesSummary Custom Purchase Order template works fine when PO is in Draft status but does not work when PO moves to Open statusContent Hi, The Custom PO template works as ex… -
I need to find a way to Audit who deleted a folder in Reports and AnalyticsWe are live on Oracle Fusion, and we have a bunch of Reports and Datamodels in Custom folder in Reports and Analytics. Someone deleted one of the folders and we need to …
-
Query to fetch project and Time card entries(OTL)Summary: Hi Team, We need a table where the project number and time card entires details or SQL query Content (please ensure you mask any confidential information): We n…
-
Is there an Oracle standard report that lists the permissions for all folders in the BI Catalog?Summary: Is there an Oracle standard report that lists the permissions for all folders in the BI Catalog? Version : 25D -
Data replication from Oracle Fusion, OTM and WMS to external data warehouseWe have a requirement to replicate Oracle Fusion, OTM and WMS data (full load and incremental) to an external datawarehouse/ data lake at Microsoft Fabric on nightly bas…
-
RTF line alignment issue in BIP Report.Summary: Hi Expert There is a requirement from customer that in one purchase order approval report if the amount is more than 2500 Euro than there should be red flag aft…
-
Can Oracle provide listing of object changes to Journal and transaction Details Report after 25A?Hello, Our auditors are asking why the delivered Journal and Transaction Details report was modified on 4/4/2025. This is a delivered report so our company does not have…
-
Static URL for an analysisI am creating a tile on the My TEam page for a report, how do I build the static URL for an out of the box analysis that I have created a report from? I was able to do s… -
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 enable Export options when analysis added to Reports and AnalyticsSummary: Enable export options below a report from an analysis Content (please ensure you mask any confidential information): We have created custom analysis and made th…
-
How can i Improve performance in ReportService API CallsSummary: How can i Improve performance in ReportService API Calls Content (please ensure you mask any confidential information): https://****:443/xmlpserver/services/v2/…
-
How to download all attachments from a Projects Invoice workflow transactionSummary: How to download all attachments from a Projects Invoice workflow transaction Content (please ensure you mask any confidential information): Approvers are attach…
-
what is the previlege for Workflow Transactions ListingSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Budgetary Control Carry Forward Sample BIP ReportsSummary Sample reports to identify transactions that impact budget account balances, and also facilitate the identification of transactions and balances that need to be … -
Adding Project Classification (Class Code) to OTBI report duplicate Costs RowsSummary Adding Project Classification (Class Code) to OTBI report duplicate Costs RowsContent Adding Project Classification (Class Code) to OTBI report duplicate Costs R… -
Get FRS report results in different currencySummary: Is it possible to get all FRS report output in a group currency? Content (please ensure you mask any confidential information): We have a requirement to calcula…
-
Is there any API to read files from UCM serverWe have to build integration in MuleSoft to read the file from Oracle fusion UCM server. Is there any API which we can configure in MuleSoft to read the file from Oracle…