Category 129
Discussion List
-
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…twinkle talreja 2 views 0 comments 0 points Started by twinkle talreja Reporting and Analytics for ERP -
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… -
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… -
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…Aseef Babujan-Oracle 2 views 1 comment 0 points Most recent by Aseef Babujan-Oracle Reporting and Analytics for ERP -
"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 … -
Assistance required to create Requisition Bucket with Bar graphHello, I am seeking assistance in developing a Requisition Aging Bucket in OTBI. The goal is to create a bar graph to present summarized requisition data on a dashboard.…Shubham Kadam 11 views 1 comment 0 points Most recent by Deepak Pai-Oracle Supply Chain Financial Orchestration -
Method to Bulk Retrieve and Review Job DefinitionsSummary: Method to Bulk Retrieve and Review Job Definitions Content (please ensure you mask any confidential information): Task Name: "Manage Enterprise Scheduler Job De… -
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…Akhila.Allagadda 49 views 8 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
BPM Approval Group tables to fetch the approval informationWe are trying to fetch the approval group for which an approval task is triggered. We are able to fetch the approver name and task details in the table - FA_FUSION_SOAIN…Anishka Agarwal 28 views 2 comments 0 points Most recent by Sreenivasulu Elluru Payables, Payments & Cash Management -
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… -
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… -
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 2.9K views 78 comments 9 points Most recent by Pratiksha Sawandkar Reporting and Analytics for ERP -
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…Mohammed Boucanna 29 views 1 comment 0 points Most recent by Mohammed Boucanna Reporting and Analytics for ERP -
Upload Image in Financial Reporting CenterSummary: Upload Image in Financial Reporting Center Content (please ensure you mask any confidential information): Hi, How to upload the image such as logo into FRS and … -
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…Manjusha ERP Tech09-Oracle 3 views 0 comments 0 points Started by Manjusha ERP Tech09-Oracle Reporting and Analytics for ERP -
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…AnuragGandhi 17 views 1 comment 0 points Most recent by AnuragGandhi Reporting and Analytics for ERP -
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…Pritam Das 47 views 10 comments 0 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP -
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 '… -
Subject Area to capture Employee detailsSummary: Content (required): Hi, Can someone please let me know the subject area to be used if the requirement is to capture the username, employee first name, employee … -
OTBI Analysis Error: ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversionHello, I'm getting the error in my OTBI Analysis: ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion when I add a column Called "Requirement Text" fr…JessSantos 29 views 7 comments 0 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP -
Query to get PPR pending approver nameI need to extract data for Payment Process Request ( PPR ) with pending approver name. -
Can we data mask certain fields within BICCSummary: As Oracle provides BICC as a tool to extract data from Oracle Fusion Cloud through UCM for customers to further analyze or report this data. We have a legal req… -
BIP Report Interactive LayoutSummary: We have developed an interactive layout in our report. We are looking to see if we can do below, How to add scroll bars to table data in the layout How to align…Nagarjuna Nudurupati 9 views 0 comments 0 points Started by Nagarjuna Nudurupati Reporting and Analytics for ERP -
Subject area for FND Flex valuesWe have a flex set defiend with values for categories. This flex field is used as source on invoice as DFF. Payable Subject area is used to design a report and we are us… -
Can you explain the purpose of the BIPUBLISHER_V view and how the IAU_AUDITUSER column fits into itSummary: Can you explain the purpose of the BIPUBLISHER_V table and how the IAU_AUDITUSER column fits into it SELECT iau_resource , IAU_TSTZORIGINATING, IAU_INITIATOR , …KHALED IHADDADENE 110 views 3 comments 0 points Most recent by Debby P Reporting and Analytics for ERP
-
Which BICC PVO Stocked Purchase Order Receipts Information?Summary: Maybe someone knows or can give a hint where to find Stocked Purchase Order Receipts Information like Receipt Date in BICC extracts. So which PVO to use for thi…Frank.Steinjan 5 views 0 comments 0 points Started by Frank.Steinjan Reporting and Analytics for ERP -
help with if/then formula in EPM ReportI need help with a formula in a report. As soon as I add the subtraction part to the final part of the statement i get an error. This works: IF(IsMissing([G]), 0, [F]) T…