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
-
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… -
Unable to find the table and column in which "Grouped construction in progress" flag at project ExpContent Hi All, I am able to find the "Grouped Construction in Progress" flag at project expenditure level. please find the navigation attached. I'm unable to find the f…
-
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…
-
Unexpected Automatic Submissions of "ESS Job for Bulk Ingest to OSCS"We have observed that the "ESS Job for Bulk Ingest to OSCS" is being submitted multiple times daily by various users. Upon checking with several of the listed users, the…
-
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…
-
OTBI Case Statement excludes some of the row from StatementsSummary: After adding Transaction code formula as follows CASE WHEN ("- Line Information"."Statement Line Transaction Code" = '165' AND "- Line Information"."Statement L… -
Invoking the runReport operation of the ExternalReportWSSService with reportData supported in FusionSummary: Is invoking the runReport operation of the ExternalReportWSSService with reportData as input a supported approach in Oracle Fusion? Content (please ensure you m…
-
"HRC_TXN_TAC_HISTORY" - Audit report for corrections to transactionsSummary: We have enabled the editing function within the Transaction Console. Users can now adjust the transactions to make corrections while not yet approved. Is there …
-
otbi is fetching the amount details for only USD currencies not for all currenciesotbi is fetching the amount details for only USD currencies not for all currencies do we need to enable any profile options, apart from USD we are unable to get the amou…
-
BI Publisher Bursting Email Sent Even When Report Has No DataHi Oracle Support, Bursting emails are being sent even when the report output is empty. How can we prevent emails from being sent when there is no data? -
how to update CLOB Column of Custom Object from OIC IntegrationHi, We have a Custom Object and we have create a field with Data Type "Long Text". We are not able to update the value in this field using REST API. We are using below U…
-
FRS Reports erroring out intermittentlySummary: FRS Reports erroring out intermittently Content (please ensure you mask any confidential information):These are the errors received trying to run the Fin report… -
Purchasing Documents Pending ApprovalSummary A Report showing purchasing documents which are currently pending approval and the person they are currently assigned to.Content - If you want a report that simp…
-
How to customise Requisition Approval E-Mail ReportSummary: We customized the “Requisition Approval E-Mail Report” to display the supplier name in the purchase requisition approval email and in the notification content. … -
Email Oracle seeded ESS Job:Import Costs: Generate Output Report outputSummary: We have requirement to email output of 'Import Costs: Generate Output Report'. We find it challenging as this is child job for 'Import Costs' . This report 'Imp…
-
Suppliers with Duplicate Taxpayer ID Report not Available to RunSummary: No capability to open or schedule the Suppliers with Duplicate Taxpayer ID Report Content (please ensure you mask any confidential information): Our business us…
-
BI Publisher PCL Printing Issue: Layout Output Appears Scaled DownI would like to ask for your advice regarding the output of a BI Publisher printing. When we register the printer in the ERP and issue the print job using PDF to PCL fil…
-
Getting duplicate records from AP subledgerSummary: Getting duplicate records from AP subledger Content (please ensure you mask any confidential information): Hi All, I have a requirement where i need to fetch th…
-
How Purge Interface Tables Program selects submitted by user?Summary: How Purge Interface tables select the user to schedule maintenance Purge with following arguments? Argument1 =1111 Argument6 = ORA_MAINTAIN Argument7 = SYSTEM A…
-
Changes to expense approval template does not reflect after 24hoursHi all, We have a requirement to modify expense approval template to add the account number to show up on the email notifications. To achieve this, I have modified the '…
-
Tools for generating the Income Statements and Balance Sheet “out of the box"Is there any tool provided by Oracle for generating the Income Statements and Balance Sheet “out of the box”. If FRS is going to be sunset ->is there a tool already in t…