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
-
Where to find customer GST number field and from which tableSummary Where to find customer GST number field and from which tableContent I need to find customer GST number field and from which table to get it -
How can I either hide or remove columns easily in a data model?Summary data model bi publisher reportContent I have a data model that I have copied this over. I am trying to remove and/or hide some of the columns, and then move some…User_2025-02-08-08-55-02-564 171 views 8 comments 0 points Most recent by User_2025-02-08-08-55-02-564 -
Unable to find the table and column in which "Grouped construction in progress" flag at project ExpContent Hi All, I am able to find the "Grouped Construction in Progress" flag at project expenditure level. please find the navigation attached. I'm unable to find the f… -
OTBI Costing - Receipt Accounting Real Time subject area missing a transaction type on filterSummary I am trying to create a report in OTBI to record items I can see withing Supply Chain Execution > Receipt Accounting > Review Receipt Accounting DistributionsCon…
-
Exit the Foreach Loop after fetching once value in XSL TemplateSummary We have an requirement where if there are multiple Invoice lines with PO numbers,but we have to fetch any one of the PO number from lines in XSL template from Pa…
-
GL Journal Workflow notification template customizationSummary GL Journal Workflow notification template customizationContent In latest release oracle allows editing the workflow notification template. We are trying to custo…saravana maneeian subhramaniun 40 views 1 comment 0 points Most recent by Gergana Radoutcheva-Oracle
-
Need recommendation of enterprise structure for 2 separated businesses under one legal companyContent Hi Guru, customer has one company (one legal entity) with 2 separated businesses. People are also totally separated for these 2 businesses. The only relationship…
-
Query result shows duplicate records, what is the issueSummary Query result shows duplicate records, what is the issueContent Query result shows duplicate records, what is the issue? select a.ORG_ID , d.PARTY_SITE_NUMBER , c…
-
Schedule recurring ESS job to start immediately after the previous job has completedSummary Is it possible to schedule recurring ESS job to start immediately after the previous job has completed?Content Hi there, I am trying to understand what is the be… -
BI Publisher - How to generate the postal bar codeSummary BI Publisher - How to generate the postal bar code and standard payment barcode on billsContent I have a requirement to generate customer correspondence that inc… -
Financial Reporting Studio Install not available in WorkspaceSummary Financial Reporting Studio Install not available in WorkspaceContent I am trying to download the installation for FRS following the instructions (Implementing En…User_2025-10-31-01-06-05-525 38 views 6 comments 0 points Most recent by User_2025-10-31-01-06-05-525
-
Descriptive Flexfields on Business Unit definitionContent Does anyone know how we can define descriptive flexfields on Business Unit definition? I can't the relevant object in the Manage Descriptive Flexfields task and …
-
Drill Down from the Master to Detail via Action Link using case formula columnSummary I am trying to drill from the Master report to the detail report, I am fetching the count of rejected invoices with respect to each statusContent Dear Friends, M… -
Depreciation Projection Report in Oracle Fusion CloudSummary Depreciation Projection Report in Oracle Fusion Cloud in Fixed AssetsContent Hi Friends, In Oracle Fusion, is there any report to project depreciation, similar t… -
Cloud Revaluation White PaperSummary Please provide Cloud Revaluation White PaperContent Is there a White Paper for the Cloud Revaluation process? Also, does Cloud now calculate the Period Average r…
-
Column returning no value when combining Payables Invoices and Payment History subject areasContent Hi all, I have created a summary analysis for AP with a pivot table view that users can drill through to a detailed analysis and then drill down into the manage … -
Getting started videos for end users who haven't accessed the system in over a yearSummary Basic training pre go-live for users who completed KUT >12m agoContent We are 12 weeks away from go-live having unfortunately having had to delay our go-live a n…User_2025-02-04-17-55-18-744 38 views 4 comments 0 points Most recent by User_2025-02-04-17-55-18-744
-
Show Declaration while running BI ReportSummary Show Declaration while running BI ReportContent Hello Experts Is there a place where we can show declaration before running/scheduling a report ?A checkbox will … -
Need SQL join to show bank assignment to supplier siteSummary We assign bank accounts to supplier sites, I need the table joins to allow me to create a data model to show which bank account is assigned to each supplier site…User_2025-02-04-14-03-09-386 309 views 2 comments 0 points Most recent by User_2025-02-04-14-03-09-386
-
OTBI Reporting reporting Invoice Summary + checking hold statusSummary Wanting to report on Invoice summary (outstanding, in progress etc) but need to be not on holdContent Hi I am using the Payables Invoices Transactions Real Time …
-
Tables in which Printer name and details are savedSummary Tables in which Printer name and details are savedContent Whenever any Customer facing document/report is sent through a BIP report to the printers, is there any…
-
user getting error while clicking on Browse catalog under Reports and AnalyticsSummary User not able to access Reports and AnalyticsContent One of the client user not able to access reports page, he is getting error when he clicks on browse catalog…
-
Tables of ESS/BIP jobs and their parameters in Oracle fusionSummary Please share the tables in which the parameters of the ESS and BIP Jobs submitted are saved.Content Please share the tables in which the ESS and BIP Jobs, and th…
-
Need relation between WSH_DELIVERY_DETAILS & DOO_FULFILL_LINES_ALLSummary Need relation between WSH_DELIVERY_DETAILS & DOO_FULFILL_LINES_ALLContent Need relation between WSH_DELIVERY_DETAILS & DOO_FULFILL_LINES_ALL
-
BI Publisher Group filterSummary BI Publisher Group filterContent I am getting the attached error when i am trying to add two filters. any idea why ? -
BI Tables to fetch Chart of Account segment dimensionsSummary BI Tables to fetch Chart of Account segment dimensionsContent Hi, Does anyone know how to fetch the Chart of Account value sets in fusion Saas? I tried the FND_I… -
Year-End closing processSummary What are the Year-End closing processes best practice?Content We are in the process to close the year in the system (for the first time) wondering what are the Y… -
20A/20B New Feature Session for Financials Cloud_For China CustomersSummary Reply and materials of 20A/20B New Feature Session_For China CustomersContent This is reply of FIN Cloud 20A/20B New Feature Session held by China CSM team and S…
-
Multi-factor authentication for Fusion FinancialsSummary Can Multi-factor auth be enabled for Fusion?Content Can Multi-Factor Authentication be enabled for SaaS / Fusion Financials or Fusion in general? If not, what wo… -
Viewing USD AmountSummary Viewing USD AmountContent Hi, We have many companies in different countries that have different currency. We designed an pivot table using OTBI for Purchase Orde…