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 SCM
Discussion List
-
Need to get a report for PO's where we can filter by BU'sSummary Need to get a report for PO's where we can filter by BU'sContent Hello, Grateful if you can help on how to get a list of all GRN's for Received Shipments for a S…
-
How to schedule a job which will autogenerate a report on monthly basisSummary: We have a business requirement where we need to create a job that will automatically schedule and fetch the data from previous month on the first week of every …
-
Why Front Infolets Source to Settle it does not show any data?Summary: Analytics Source to Settle Infolets section in front not show any data (blanket) users only can see results into Expanded view. Content (required): Procurement …
-
Supplier(vendor name) table in Manage Serial screenSummary: Hi Supplier (vendor) table in Manage serial screen . Is there any query for BIP? Content (required): Version (include the version you are using, if applicable):…
-
Query to get Item Name and its CategoryContent Hi, Please can you share query to get category name for a given item code. Thanks
-
OTBI report - Pending PR list for all buyersSummary: Currently Buyers can view the pending PR for his/her requests. But it needs to view all the Purchase Requisitions by the buyers including his/her requests. Cont…
-
Is it possible to create new/custom infolets ?Content Is it possible to create new/custom infolets ? Version 19C
-
How to Remove Edit Option for OTBI Report.Summary: Content (required): Hello Friends We have made a custom role and added duty role -"Receiving Transaction Analysis Duty". Assigned this role to a user. But I do …
-
Moved: Error while loading Sales order through FBDIThis discussion has been moved.Aravindan Sankaramurthy -Oracle 1 view 0 comments 0 points Started by Aravindan Sankaramurthy -Oracle
-
Is there a Rest API to fetch report (OBIEEE reports)Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
Customising Purchase Order Data ModelSummary: How to customise the purchase order data model Content (required): The Line.NOTE_TO_VENDOR column appears in the PdfArchivePurchaseOrderLine dataset but not the…
-
Can we use decode or if-else in excel templateSummary: Hi Team, Can we use decode or if-else in excel template for BI report. If yes. can you please share sample example. Regards Nidhi... Content (required): Version…
-
Request to share solution to display SO Header attachment URL on BIP report output and download itSummary: We have a requirement to build a custom BIP report in Oracle Cloud ERP (SCM Module). If there is any attachment at Sales Order Header Level, then we want to get…
-
Org LOV throwing error in Standard Report - Exception Summary by ItemSummary: Org LOV throwing error (Attached Screenshot) in Standard Report - Exception Summary by Item. Content (required): Org LOV throwing error (Below Screenshot) in St…
-
Plan to Produce Infolets are not appearing on Home PageSummary Plan to Produce Infolets are not appearing on Home PageContent Hi All, We are not able to see any infolets on Plan to Produce Infolets section. Please let us kno…
-
Table and column for Firm DateSummary: The supply planning UI shows Firm Date as a column in the supplies and demands table. This date reflects when the product is expected to arrive. What is the tab…
-
How to schedule a report that requires more than 25k linesSummary: When I schedule a report I am finding that I only ever get a maximum of 25k lines. This is not sufficient for the reports that we run regularly Content (require…
-
Report services are not working post 22A upgradeSummary: REST services related to OTBI are failing in the system which worked fine until the 22A upgrade. Content (required): One of them is 'runDataModel' which we use …
-
In oracle fusion which table have Item Threshold QtyDear , I need item Threshold qty but i cant find a table in which they have. Could you please guide me where it is? For reference i attached a picture also Thanks
-
How to run a customised seeded bip report from the Report and Analytics folder/catalog folder.Summary: Greetings, Team — Is there a way to make the 'Open' hyperlink button enabled for a customised BIP Report? We customised the PO PDF Report for two different clie…
-
Convert DATE from UTC to EST in RTF template pdf ReportSummary: Hi All, I have created PDF report using RTF template, in backend I am using BI analysis and SQL queries in data model. There are many date fields in the report …
-
Replicate Data in FusionSummary: We are looking for a tool or an app that can help us extract data from Oracle Fusion (Financials/SCM). Content (required): We currently create BIP reports to ex…
-
How to Restrict Custom BIP Report Business Unit Wise without using Secured Table ViewSummary: How to Restrict Custom BIP Report Business Unit Wise without using Secured Table View Content (required): How to Restrict Custom BIP Report Business Unit Wise w…
-
The BIP Catalog page search box is inoperable.Summary: I've been looking into it for a long time, but I've never figured out why the BIP catalog page search box doesn't work. I tried the same thing in multiple insta…
-
OTBI/BIP catalog refresh/modified dateHI Team, After a refresh/upgrade/patch getting applied does the folder last modified date change for each folder. We could see some folders have different last modified …
-
How to print Current User name and time in RTF PDF reportSummary: Hi All, I am creating pdf report using Data Model and RTF template. I want to print current user who is running report and time when he ran the report in final …
-
Ability to run BI report from Isupplier portalContent Hi Experts, We have built one custom report related supplier performance in BI. Requirement is Suppliers should be able to access the reports in iSupplier Portal…
-
How to give access to Reports & Analytics but not to the UISummary: Hello, We would like to create a user with ONLY access to Reports & Analytics. The user should not have access to any module in the User Interface (UI). Is it p…
-
Need a query to get details from Review Cost Accounting Distributions UIContent Hello all, I need to get the highlighted fields as per the screenshot I have attached for the Account Alias Issue transaction. In the UI,78001 Account Alias Issu…
-
OTBI Report view as Transpose RowsSummary: Content (required): Hello Friends, How I can get a Transposed view display for OTBI report (based on subject Area)? For Example: Currently I am getting output a…