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
-
Is there any possibility to increase number of threads in ESS job (through JMS Configuration)Hi Team, Loading balances into FCCS from Oracle ERP Cloud application through ESS Job ‘Extracts General Ledger Cube Balances’ ends in error intermittently. It is fixed t… -
Auditing the data access set accessesWe have enabled Audit for Oracle Platform Security Services. However, we are unable to see the data access set access changes/updates in the Audit Report. We want to aud…
-
how to add months 24 to a date field in the OTBI Report FilterSummary: I would like to add 24 months to length of service date field using case when. Please provide the code how to write in OTBI Content (please ensure you mask any …
-
Some columns have null values for certain records and record is not retrieved when the column is selSummary Some columns have null values for certain records and record is not retrieved when the column is selectedContent I am using "Fixed Assets - Asset Depreciation Re…
-
Can we enable or disable report one parameter field based on other parameter field input?Summary: We received requirement like, 1) Choose field say start date or end date from drop down 2) Choose Operator Prior/After/Between from drop down 3) Enter Date : Da…
-
Unable to find custom ESS job created in the scheduled job screenI have created ESS job but unable to find the same in scheduled job screen to run, I have ran "Import User and Role Application Security Data" and "Retrieve Latest LDAP …
-
How to get 'Payment date' on the Procure to Pay Real Time subject areaSummary: How to get 'Payment date' on the 'Procure to Pay Real Time' subject area Content : I am trying to build a report using the 'Procurement - Procure to Pay Real Ti… -
How to find the information of different view objects using same tableSummary: Hi, We have used the "Rel13_23D_BICC_FSCM_Database_Mapping_with_ViewObjects.xlsx" provided by oracle. We have looked for VO using the table GL_JE_LINES. The spr…
-
Purchase Order PDF Using Sub TemplatesSummary: We have multiple entities and developed a custom data model and appropriate custom purchase order PDF's. All working fine for PdfDraft and PdfArchive sections. …
-
How to implement the Column Group in OTBISummary: I am checking a seeded report "Top 10 Requisitions Breakdown". can anyone help me how to implement the below column group functionality in OTBI report? Also, Ho… -
Max columns display in BIP dynamicallySummary: Hello, We have a requirement to display more columns dynamically in BIP, would like to know any limitations in MAX columns display. If not, please suggest us. T…
-
Trouble with GaugesSummary: I'm trying to create a simple gauge that shows the percent balance left, but the gauge is not reflecting the correct information. Content (required): I'm using … -
How to see the list of ESS Jobs scheduled using BICC and UCMSummary: How to see How to see the list of ESS Jobs scheduled using BICC and UCM and their start time Content (please ensure you mask any confidential information): Vers…
-
Parameter getting defaulted automatically - BI publisherSummary: When I run a report, one of the parameters is unusable because, after I select one value, it gets defaulted to "All" The data model works fine before running th…
-
BI report cannot be restricted with data access setSummary: A user without a data access set(where only ledger A is attached) is able to select ledger A as the report's parameter, and view its data as well. (the user is …
-
Looking for query to get details of Review Budgetary Control Balances screen informationSummary: Content (please ensure you mask any confidential information): I am creating a custom report to get the details of Review Budgetary Control Balances screen. Ver…
-
Unmask Bank Account number in BI Reports only based in certain user roleSummary Unmask bank accounts in reports based on user rolesContent Hi , I have been able to generate a simple report to show some Suppliers details with bank accounts fo…
-
How To Join XLA_AE_HEADERS and RCV_TRANSACTIONS in Fusion/ERP Cloud?Summary How To Join XLA_AE_HEADERS and RCV_TRANSACTIONS in Fusion/ERP Cloud?Content How To Join XLA_AE_HEADERS and RCV_TRANSACTIONS in fusion? I could link XLA_TRANSACTI…
-
Is there any Supplier Statement Report?Summary: Is there any Suppliers Statement Summary Report? including Opening and closing balance paid and unpaid invoices. Content (required): Supplier transactions Versi… -
How to convert Customer TRX ID into textHi Team, We have developed Invoice Extract report and the output is in the CSV format. In the report having the column as Customer trx id which is the length of 8/9numbe…
-
AP check template MICR Font is showing as square boxesSummary: I am working one of the Saas Customer and trying to customize the AP check template. Existing custom template was build by Solution Implementation team is worki…
-
Query to identify BPA changesSummary: Query to identify BPA changes Content (please ensure you mask any confidential information): I am building a query to identify BPA's that have had their UNIT_PR…
-
How to convert the “Amount in words to be changed to Millions and hundreds?We need to get the “Amount in words to be changed to Millions and hundreds instead of Crores and Thousands for all non INR invoices.
-
Create an AP invoice using supplier number instead of supplier name in the REST API payloadSummary: Currently the payload to create AP invoices requires to enter the supplier name to create the invoice, since the source system is not Oracle the characters may …
-
Adding a parameter to custom data model of a seeded reportSummary: We need to customize a seeded report and add a new parameter. But when we create a copy of seeded Data model and add a parameter in the custom data model, it gi… -
Render images in BI Publisher PDF outputSummary BI Publisher: how to render images residing on UCM (represented by URL) in BI Publisher PDF outputContent We have a requirement wherein we need to render the ima… -
Migrated AR report returning an error which has DFFsSummary: I have migrated 3 AR OTBI reports from one instance to another and earlier I was not able to find those DFFs in OTBI though it was configured but post running t… -
GL Detail Report w/ Subledger DetailsSummary: Finalize/Tweak built custom OTBI report to export the last bits of data needed by our auditors. We've built a custom OTBI report that exports GL and SLA numbers…
-
Receivable Invoice Report returns nullHi, When I ran the query it returns no rows -
Customer require to extract FRS report data in XML or SQL format. Is this possible?Hi All, Customer require to extract FRS report data in XML or SQL format. Is this possible?