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
-
Create Rules XML File for BI Extender Automation under a custom roleSummary: How to allow ESS Job 'Create Rules XML File for BI Extender Automation' under a custom role (no privilege since a Java type program) Content (please ensure you … -
Change row output number on Oracle OTBI AnalysisHow I am able to change the output of the rows from 75000 to more on an Oracle OTBI analysis? -
How to get Branding Image URL for Course created in Oracle Fusion HCMHello Everyone, We are developing a custom report to list courses, and one of the requirements is to display or extract the URL of the uploaded branding image for each c…
-
Table for Bursting related information and Bursting Notifications to WorklistDo we have a way to track/report notifications sent from report Bursting? If so, what attributes can we capture (e.g., recipient(s), subject, body etc.)? Does the report…
-
Tables that store the errors in FAH when the import Accounting transaction process failsSummary: What are the tables that store the errors in Accounting Hub when the import Accounting transaction process fails ? Version (include the version you are using, i…
-
Permission for standard folderSummary: Hello, I'd like to know if we can set permission for Human Capital Management under shared folder(the standard folder) to specific users. I managed to do that i…
-
SQL to get the ESS job run details with Parameter ValuesSummary: We have a requirement to analyse the performance issues for some of Project application ESS jobs for our client. TO this end, I would like to see get an extract…
-
LACLS It is possible that DDF used in localization can be defined at the global attributes level?We are configuring the localization for Peru and have found that many of the descriptive fields are already in use by other companies operating in the system, so we have…
-
FRS report is going into error after migrating to UAT instanceFRS report is going into error after migrating to UAT instance. The migration was done by two different methods. 1. Archiving from SIT and unarchiving to UAT. 2. Exporti… -
Industry field for otbi subject aresSummary: Please help in getting industry field for otbi having subject ares: 1.order management-fulfillment lines real time 2.order management-order headers real time 3.…
-
Audit - On Folder Permissions ChangesWe have a requirement on Auditing folder Permissions Changes details on "Reports and Analytics --> Catalog --> Shared folder --> Changes on any of the custom folder perm… -
Payables Invoices –Transactions Real Time Subject Area is not returning correct Invoice line amountsSummary: Payables Invoices –Transactions Real Time Subject Area is not returning correct The OTBI Report with subject area Payables Invoices – Transactions Real Time has… -
How to burst and deliver a single CSV file to SFTP when no column has a common value for all recordsHi team, I am working on an Oracle HCM Cloud BI Publisher report where the requirement is to: Generate one CSV file Containing all records Deliver the file to SFTP locat…
-
Payables Invoices –Transactions Real Time Subject Area is not returning correct Invoice line amountsSummary: Payables Invoices –Transactions Real Time Subject Area is not returning correct The OTBI Report with subject area Payables Invoices – Transactions Real Time has…
-
Is there a way to identfy open subledger transactions in the general ledger?Summary: We have a custom report requirement to extract account balances for specific accounts for open transactions only. These are either receivables or payables that … -
Not able to create a custoemr with Jan 1900 as starting date in PROD environmentSummary: When we create a customer in TEST and other non‑production environments, we’re able to use 01.01.1900 as the start date at party, Account and site level, withou…
-
How to schedule BIP report in application composer ?Summary: I would like to use the application composer to schedule a BIP report I have defined the (https://****/xmlpserver/services/ScheduleReportWSSService?WSDL ) webse…
-
Report to monitor payables invoice rejections due to invalid approval rulesSummary: Any seeded report to monitor payables invoice rejections rejected due to invalid approval rules. These kind of rejections can be viewed only in Transaction cons…
-
Financial Reporting Studio Report displaying Error when no data is foundSummary: Financial Reporting Studio Reports fetching #Error when no data is found. We don't want want to suppress the column or row, rather want to display the value as …
-
Unable to link multiple subject areas in OTBI reportHi, I created an OTBI report with PO and Invoice details such as PO number, PO lines, PO amount, Invoice number, Invoice amount, Transaction currency and Ledger/Accounti…
-
Equivalent Standard AR Report not available in Fusion although Business uses standard reports in EBSEquivalent Standard AR Report not available in Fusion although Business uses standard reports in EBS - Need Oracle confirmation on the availability of standard Fusion AR…
-
Report Logo broken in Gmail but working in OutlookSummary: We are inserting the client logo for the Disbursement Separate Remittance Advice Report and it is working with Outlook but it is broken when being opened in Gma…
-
Why I am not able to see prompts when I navigate through Reports & AnalysisI created an OTBI report in Accounts Receivable with prompts. When I access the report through Browse Catalog, the prompts appear as expected. However, when I navigate v…
-
Multiperiod Accounting invoices amortization detailsneed help in getting details of MPA invoices, query to get details of MPA Invoices with1) Monthly amortization amount 2) Current Month amortization amount 2) Accumulated…
-
Do we have any subject area for custom role creation start and end dateSummary: Do we have any subject area for custom role creation and end date Content (please ensure you mask any confidential information): Do we have any subject area for… -
Missing Mapping for Attribute_Number1 from FUSION.GL_JE_LINES Table to BICC GL_JE_LINES PVOWe are unable to map the ATTRIBUTE_NUMBER1 column from the Fusion GL_JE_LINES table to any column in the BICC Journal Lines PVO (FscmTopModelAM.FinExtractAM.GlBiccExtrac…
-
Connection Timeout (Error 404/504) when connecting BI Publisher to OIC File Server via Port 10134.Summary: Connection Timeout (Error 404/504) when connecting BI Publisher to OIC File Server via Port 10134. Content (please ensure you mask any confidential information)…
-
What are the solution options for Audit Trail for Spend Classification?Summary: We need to have an Audit Trail for Oracle Fusion Cloud Procurement > Spend Classification. Oracle doesn't include the Spend Classification product as part of Ma…
-
Security for OTBI Subject Area "Projects - Labor Distribution Costs Analysis Real Time"Summary: We need to expose OTBI queries written against the subject area "Projects - Labor Distribution Costs Analysis Real Time" to a larger population. Right now, it i…
-
Hi, does anyone have a query on how to pull invoiced and non-invoiced receipts?Hi, does anyone have a query on how to pull invoiced and non-invoiced receipts?