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
-
sql for material transaction reportContent i need to create a material transaction report between 2 dates the first i need open balance quantity (sum quantity before the first date) transaction between 2 … -
Financial Reporting Web Studio BookContent Hello: We have page inserts in our financial "book" for manually inserted pages. One of the Inserts is using a 2 page insert and needs a 3 page insert (so the pa…
-
OTBI AP Report including approversSummary Can I access a field containing approvers in an OTBI Payables transaction report?Content We have a report that returns all payables transactions for the prompted…User_2025-02-11-03-09-13-126 26 views 2 comments 1 point Most recent by User_2025-02-11-03-09-13-126 -
OTBI multi-language support Release 13Summary Multi-language support for OTBIContent Hi Has multi-language support been enabled for OTBI Release 13? Thanks
-
Received Not Invoiced Liability ReportSummary Need an OTBI report for Received Not Invoiced LiabilityContent I am looking for an RNI report that will tie out the uninvoiced receipts to my GL liability. So fa…
-
Cross validation Rule extract by report / SQL querySummary Need report/SQL query for extracting Cross validation rulesContent I am looking for Cross-validation report or SQL Query to extract all cross-validation rules at…
-
Receivables_ how join different subject areaContent i try to do a report for ar transaction invoice with receipts; i try to create a new analysis. I was able to view the invoice data, I tried to link the collectio…
-
Supplier Profile syntax has been excluded from the most recent version of the "ERP OTBI Report to FuContent Supplier Profile syntax has been excluded from the most recent version of the "ERP OTBI Report to Fusion App Drill-Down Actions" white paper (which had most rece…User_2025-01-28-16-10-52-033 25 views 1 comment 3 points Most recent by User_2025-02-06-21-15-08-830
-
Joining two subject areas OTBIContent Hello: I feel like I'm so close. I have the two subject areas and the criteria columns completed. But I'm getting an error when I run each one of them (worked wi…
-
Due Date Calculation Formula based on Terms Date and Terms Name in OTBI ReportSummary Looking for a formula to derive Due Date based on Terms Date and Terms Name in OTBI RepoertContent Hi All, I have a requirement to derive Invoice Due Date based …
-
Financial Reporting Web StudioContent Hello: I opened the Grid of a report we are currently using to make a change (report currently runs fine from the Financial Reporting Center Catalog) and immedia…
-
Created new CVR and receiving inconsistent testing resultsContent We are wanting to use CVR to only allow users to post to valid account combinations. We have about 1850 new rules that would need to be created and moving forwar… -
How to remove header from the last page i.e. terms and condition page of the RTF template in BIP?Content Hello All, We have a requirement to remove the page header from the last page i.e. terms and condition page of the Invoice print in BIP report using rtf template…
-
Set Date FormatContent Hi, In OTBI reports is there way to setup the date format globally for all users ? Thanks -
Linking 2 or more subject areas in an OTBI reportSummary We would like to build OTBI reports but will require to use 2 or more Subject Areas in some reports. What are the key fields to linking subject areas and are the…
-
Procure to Pay dashboard not displaying invoice amount on Invoices tabContent We have just discovered the Procure to Pay dashboard and are very interested in the Invoices charts and metrics however every reference to a display which involv…
-
BICC Extract job timestamp used to extract data when there is a failureSummary What extract timestamp is used for each incremental job after a failureContent When there is a failure in BICC incremental job which timestamp is used to start t…
-
What is the risk of copy any seeded report, add two columns on a table already in the data model, keSummary What is the risk of copy any seeded report, add two columns on a table already in the data model, keeping in the custom folder with a new name and new ESS Job on…
-
How to display data of a column horizontally in RTF?Content Hi all, I have a requirement where I need to display some data that comes from a column horizontally on RTF.Hereby, I'm attaching a screenshot of the RTF and wha… -
How can I Remove Create/Catalog for some usersSummary How can I Remove Create/Catalog for some usersContent How can I Remove Create/Catalog for some users, because I need buttons enable specific users -
Need table name which store Fiscal Classification CodeSummary Need table name which store Fiscal Classification CodeContent Hi Guru's, Please let me know which table store the Fiscal Classification Code which comes under "M…
-
Quality Assurance Testing for UpgradesSummary I'd like to connect on QA and Automation Testing practices, Tool use etcContent I'd like to connect with others on QA practices, Testing Tools and Automation Too… -
Need a SQL Query For Segment Value Data SecurityContent Hi there Building a report that show the charts of account data security condition and value. Please advise. Thanks.
-
"Procurement - Requsition real time" x "Workforce Profiles - Model profiles real time"Summary Relate procurement with workforce to get department nameContent Hi, We are trying to relate the procurement requisition real time subject area with the workforce…
-
Can we call Lookup value in OTBI analysis?Summary Calling up Lookup value in OTBI analsyisContent We are setting up an OTBI analysis using 'Subledger Accounting- Journals real time'. We want to call look up valu…
-
Passing comma seperated parameter values through SOAP requestSummary Passing comma seperated parameter values through SOAP requestContent I running a BI Publisher report through SOAP request. the BI Publisher data model contain th… -
Query to check if an invoice have a prepayment included or notContent Hi all, I want a query that can provide me with a flag whether an invoice has an applied prepayment or not. I checked if a flag is available in the invoice table…
-
Count of attribute column in Learning Real TimeContent Hi there I want to have a count of an attribute column in Learning Real Time. For instance, I have a table with the names of the users and a course name. I want … -
21A Unable to see historical ESS jobs e.g. from last year or previous years, is this a limitation?Summary 21A Unable to see historical ESS jobs e.g. from last year or previous years, is this a limitation?Content Hi Experts, We would like to ask 21A Unable to see hist…
-
OTBI Issue - Costing - Receipt Accounting Real TimeSummary OTBI Receipt Accounting -- Concatenated SegmentsContent Hi All, Appreciate your inputs or suggestions on the below issue. OTBI Report having timeout issue Subjec…