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
-
Need to generate and include a sequence number in custom BI publisher eText template for position baSummary Need to generate and include a sequence number in custom BI publisher eText template for position based payment file to BankContent Hi Experts, We have a require… -
Increment Date Parameter on scheduled jobs - workaround neededSummary Increment Date Parameter on scheduled jobs - workaround neededContent When scheduling jobs like: Create Accounting, or Payables Cash Requirement Report, these re…
-
Converting Parameter Timezone on Input - UTC Database vs BST Local IssueSummary Converting Parameter Timezone on InputContent Hi All, We have an issue relating to the database time being on UTC, where our current local time is BST, though I …
-
Payments Subject AreaContent Hi, As attached in the screenshot please advise which subject area need to be used for Payments Thanks -
Search not working for LOV in BI Publisher ReportSummary Search not working for LOV in BI Publisher ReportContent Hi Team, I have created LOV through SQL in BI Publisher Report. If i am using value without transforming…
-
Cash bases accouting reportsSummary Cash bases accouting reportsContent Hi - Any one come across reports requirement on cases bases?if yes, how you Achieved? pls suggest..
-
AR Account Profile ClassSummary Linking 2 AR Subject Areas.Content The AR Account Profile Class is not available in the 'Receivables - Payment Schedules Real Time' subject area (19C) and it is …
-
Dyanmic BI Publisher Page EntrySummary Page Entry for BI Publisher ReportsContent Hi, We need to have a dynamic page entry(one click navigation for report) to be created dynamically i.e it should not …
-
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…
-
on bi convert number to character but on Arabic formatContent i user but character is english , i need a character with arabic .
-
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… -
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… -
BI Publisher Procedure call that populate temp tableSummary BI Publisher Procedure call that populate temp tableContent Is it possible to create BI Publisher Procedure call that run one of the customeraging Requests that … -
Syntax help for a BI ReportSummary Need field to display 'All' when nothing is selected, but also need to format this field as a date.Content Hello all. I'm looking for a bit of help with my synta… -
Ledger not visiable in FRSSummary Ledger not visiable in FRSContent Hi, We have 15 ledgers,out 15 only 3 ledgers are available in Financial reporting studio.We are web reporting studio. We have C…
-
BIP Report to get the Payment pending for ApprovalSummary BIP Report to get the Payment pending for user ApprovalContent Hi All, We have enabled a Workflow approval for Payments in ERP Cloud. We have a created a Specifi…
-
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 … -
OTBI Analysis filter by max date valuesSummary I want to filter a subject area, where I get only the max date, as the record is duplicated for different datesContent How to do below in OTBI Analysis, Data Set…
-
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…
-
Is it possible to add a calculated SQL-based column in an OTBI Analysis?Summary Need to return a segment value name in a column from an OTBI analysis using a SQL QueryContent Hello, Our Financial users have created several OTBI reports based… -
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…
-
How to add OR condition in the input of the OTBI analysisSummary How to add OR condition in the input of the OTBI analysisContent There are suppliers whom we create only invoices and there are suppliers whom we create only PO … -
Custom ESS Parameter with TextBox and SearchSummary How can we have a Custom ESS Job with parameter as Textfield with Search option.Content One of the standard ESS Job has a parmeter which is a TextBox with a Sear…
-
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
-
SQL Cash Advance Report from ExpensesSummary SQL Cash Advance Report from ExpensesContent Hello I was wondering if you can share with me any SQL regarding open Cash Advances from Expenses. Thanks for your h…
-
Is it possible to create a data source for ERP Cloud from Oracle Analytics Cloud (OAC)?Summary My company is moving to Oracle ERP Cloud, but end users want to still use OAC as the primary source for Reporting and AnalyticsContent My company is moving to Or…
-
After 20C OAC DataSync from ERP Cloud fetching 0 recordsSummary We are observing in Data Sync the PVO's are getting 0 records while fetching data from ERP cloudContent We are seeing this currently in all instance where the Da…Kammarapalli Venkatesh-Oracle 45 views 2 comments 1 point Most recent by Kammarapalli Venkatesh-Oracle
-
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…
-
Dynamic List of Values for ESS JobSummary Dynamic List of Values for ESS JobContent Hi, How to create a 'Dynamic List of Values for ESS Job' , I cant use the lookup and table type valueset is not working… -
Generate SAFT Data Extract Norway is not populating with any dataSummary Generate SAFT Data Extract Norway is not populating with any dataContent The ESS job 'Generate SAFT Data Extract' is not populating with any data. Parameters scr…