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
-
Documentation on Complete list of available pre-built KPI/metrics in Fusion SCM Analytics (FAW)?Summary: Can you please let us know the link where we we can get to know the complete list of metrics/KPI available in SCM Analytics for OM, Procurement and Inventory? C… -
What is the formual to use when scheduling a report to pull data from the previous monthSummary: I am attempting to run a scheduled report. The report would run on the first of the month for the previous months cycle count program results. In past releases,… -
How to Send Multiple files in one mail using Bursting(BI Report-EText template).Summary: Trying to Send Multiple files in one mail using Bursting(BI Report-EText template). How can we achieve this? Version (include the version you are using, if appl…
-
UCM vs Object Storage for BICCSummary: UCM vs Object Storage for BICC Content (required): What is the recommended approach? Our end goal is to load the extracts into a database. Version (include the …
-
REST API services feature for Oracle BI PublisherSummary: We are trying to access BI report through rest API. When we try the Oracle BI Publisher REST resources using the following URL structure https://:/xmlpserver/se…
-
What DFF's or Flex fields are we able to bring into to OTBISummary: Looking for documentation about which dimension in OTBI we can extend with flex fields. We found in finance module that not all flex fields were eligible to com… -
Assign Printer to a UserSummary Assign Printer to a UserContent Hi, Can we assign a printer at user level without specifying any document. So whatever that user prints gets printed to a specifi…
-
Seeded pick slip report submitted from inventory UI in wrong languageSummary: Content (required): 1- Log in to Oracle in French (All the settings in French in manage user preferences) 2- Go to manage pick slip screen in the inventory modu…
-
In which table we can find reference type for costingDear , Can anyone tell me which table i can find Costing reference type i cant find these check picture for reference Thanks -
New Records in OTBI ReportNew Records are not showing OTBI Report as it's taking a couple of hours to show in reports Let's say, I create New categories under the same catalog and want to see the…
-
How to defaulted the current month in Analysis prompSummary: How to default the current month in Analysis prompt Content (required): Need to default the current month in the analysis prompt, so that each month the current… -
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