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
-
GL reports on multiple ledgersContent Our client has close to 40 million journal lines across ledgers for a single period. They want a BIP report where they will only pass the ledger set and choose a… -
on bi convert number to character but on Arabic formatContent i user but character is english , i need a character with arabic .
-
Need Logic/Query to create below KPI's for Purchase Requisitions/OrdersSummary Need Logic/Query to create below KPI's for Purchase Requisitions/OrdersContent Need Logic to create below KPI's for Purchase RequisitionsWe have been trying to c… -
Join between wsh_deliveries and rcv_shipmentsSummary Join between wsh_deliveries and rcv_shipments to fetch shipment_num, invoice no & dateContent Join between wsh_deliveries and rcv_shipments tables to fetch shipm… -
GL_FRC_REPORTS_B and Custom Folder and Report ListSummary GL_FRC_REPORTS_B is not listing all the reports that are created or modified; Should we run a process to populate the table or does the data in the table gets po…
-
Basic General Ledger Transaction Report - Filtered By AccountSummary Does anyone have a robust Basic General Ledger Transaction Report - Filtered By Account that they could shareContent We are due to go live with Oracle Fusion (SA…User_2025-02-11-02-45-23-645 72 views 5 comments 0 points Most recent by User_2025-02-07-23-45-47-870
-
Unique Records via BIP for tables with Object Version NumberSummary I'm looking for a way to obtain the latest information for a given record via a BIP job, for tables with an Object_Version_Number columnContent Hi, As per the su…
-
AddIn is disable in VDI toolContent Hello, Can you help me out with this enable to AddIn in word in VDI tool. Thanks, Nupur Thakar Version VDI 5.4.3
-
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…
-
Are the BPM configuration tables exposed to OTBI?Summary Looking to query BPM configuration tables directly to support external audit change management populationContent Are the BPM configuration tables exposed to OTBI… -
VAT Reports for Russia in Scheduled process is resulting into warningSummary When I submit "VAT Reports for Russia:" this resulted into "Warning". It states that feature is not enabled. Please suggest.
-
FRS Reports AuditSummary Is there an audit available to see what happened to a FRS Report folder?Content Hello: We had a FRS folder in BI Catalog go missing, and we are wondering if ther…
-
List of all the recurring scheduled processes?Summary How to get a list of all the recurring scheduled processes?Content How to get a list of all the recurring scheduled processes? -
Error tables in Oracle for Unit of Measure Intraclass Conversion FSM importSummary I am trying to fetch the errors that occured while importing Unit of Measure Intraclass Conversion using FSMContent Hi, I am searching for tables where I can fin…
-
Suggest Some Price List table in oracle fusionSummary Please suggest some price list table in oracle fusion and where can we find themContent Please suggest some price list table in oracle fusion and where can we fi…
-
20c- BI Publisher Data Models No Longer Support Passing Dynamic SQL Parameters in Reference CursorsSummary 20c- BI Publisher Data Models No Longer Support Passing Dynamic SQL Parameters in Reference CursorsContent All, 20c- BI Publisher Data Models No Longer Support P…
-
R13 How to generate a Trial Balance Report from OTBISummary R13 How to generate a Trial Balance from OTBContent R13 How to generate a Trial Balance from OTBIHello : I was wondering if you can share with me any document ho…
-
From which customer table can we find order_type fieldSummary From which customer table can we find order_type fieldContent Please suggest from which customer table can we find order_type field
-
Supplier Spend ReportSummary Supplier Spend ReportContent Hi, As stated, we would like to ask for your help if there is a standard supplier spend report in Oracle. What we need is the actual…
-
Where can we get Percent Complete in Contracts Associated ProjectsContent Hello all, From where can I get the highlighted field . This is from which table? I checked contract lines tables there Percent Complete is coming NULL. Please s… -
Can we create a multiple selection paramter in the custo ess job?Summary Can we create a multiple selection paramter in the custo ess job?Content Hello , We have create a one custom job for the BIP report and now the users are excepti… -
COA value missing in the LOV in Payables invoices - Transactions real time subject areaSummary COA value missing in the LOV in AP invoices real time subject areaContent Hi Gurus, We defined a cost center long ago and had AP transactions created against it.…
-
ESS Administrator / Monitor / Operator rolesContent Hi I'm trying to find information on what exactly entails the roles: * ESS Administrator Role * ESS Monitor Role * ESS Operator Role Trying to give a user access… -
How to get invoice_number against transaction in RA_CUSTOMER_TRX tableSummary How to get invoice_number against transaction in RA_CUSTOMER_TRX tableContent Please help us to get invoice_number against transaction in RA_CUSTOMER_TRX table
-
Custom ESS job not visible to all EmployeesContent Hello, We have created a custom ESS Job , but its not visible to all employees. We need it to be visible for all employees. We have referred the following docume…User_2025-02-07-08-53-49-914 1.2K views 2 comments 0 points Most recent by User_2025-02-07-08-53-49-914
-
How to give an accees to a user to run custom ess jobSummary How to give an accees to a user to run custom ess jobContent Hello , I have created one custom report and i have creates custom ess job as well , Now i want to g…
-
Display The Limited Values Only On LOV Through User POV SettingSummary User would like to control the values that can be selected in the user POV of Financial Reporting StudioContent User would like to display the limited values on …
-
Reporting on Payment ApprovalsSummary BI Publisher or OTBI Report to extract Payment ApprovalsContent Hi Community Are there are any BI Publisher or OTBI Reports available to report on Payment Approv…
-
Cycle query for Structures and Components.Content Hi there. I'm trying to get a by level BOM with tables EGP_STRUCTURES_B and EGP_COMPONENTS_B. It's not so easy to relate as in EBS, you guys have any good cycle …
-
Session user for bursting BIP reportSummary Session user for bursting BIP reportContent How can i burst BIP report to the session user ( the user that run the BIP report ) ? what parameter i should add aft…