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
-
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… -
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 locations nameDear , Can anybody guide me in oracle fusion which table have location name. i tried to find but i cant. Kindly check the attached pic i need these column in table where…
-
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…
-
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… -
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 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 …
-
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 …
-
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 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…
-
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… -
In which table Derived related items are stored in Oracle Fusion CloudHi , We have the item which has related item with reciprocal flag is Y and when i search the related item, i can see the actual part in the derived relation items. but s…
-
What is the PVO for Item Descriptive FlexfieldsContent: Once DFFs for Items (EGP_SYSTEM_ITEMS_DFF) are "BI enabled" and deployed, what is the associated PVO that can be used in BICC to extract those Flexfield values …
-
SCM & Procurement Standard reports templates ?Summary: am searching for a document that include fusion SCM & Procurement Standard reports templates Content (required): SCM & Procurement Standard reports templates Ve… -
Data not showing albeit correct rolesSummary: Data is not showing whilst creating an OTBI analysis Content (required): Data is not showing whilst creating an OTBI analysis for the Unit Cost Dimension althou…
-
Getting error while downloading larger amount of data in BI ReportSummary: We have observed one issue in BI Report wherein while extracting the report output, it only shows total 74701 number of records. After that it shows error as Ex…
-
Print ZPL labelsSummary Print ZPL labelsContent Hi, We have a requirement to print ZPL labels on non-local Zebra printers. The availability and configuration of a Zebra printer (using a…
-
SCM roles to create OTBI reportSummary list of roles is requiredContent Hi All, Kindly, I want to use OTBI to create reports specifically in SCM. I need the list of roles that facilitate this kind of … -
Unable to link Order Fulfillment and Item Cross Reference Subject AreasSummary Unable to link Order Fulfillment and Item Cross Reference Subject AreasContent Hi, Are there any documentation to identify what join is missing when we try to re… -
BIP performance recommendations guide v1.0 for FA SaaS (2800118.1) is available on MOS PortalSummary BIP Performance Recommendations Guide is intended for FA SaaS BI system integrators, BI report developers and admins. It covers advanced performance tuning techn…
-
BI Publisher Report Parameters Performance IssuesContent Hi, We have created a report with 15 LOV parameters such as Business Unit, Supplier, Location based parameters, GL Tree based parameters, Buyer, Currency and GL … -
need query to get link between grants-->awards-->projects to gl_code_combination tableSummary need query to get link between grants-->awards-->projects -->project budgets-->working versions-->period accounts to gl_code_combination tableContent need query … -
BIP Report Output as Text MessageSummary BIP Report Output as Text MessageContent Hello, Do we have any option to send BIP Report output as Text SMS message. Please let me know if you know if this is po…
-
Lot Experation Date Field in Subject AreaSummary Looking for the Lot Experation Date fieldContent I am using the Inventory - Inventory Transaction Real-Time subject Area. Under Lot there is no Expiration Date f… -
Query to find Product Family of ItemSummary Query to find Product Family of ItemContent Hi All I wanted to find the table or query which hold the Product_family details of an items: Below is the screenshot…User_2025-02-11-07-07-59-045 934 views 1 comment 0 points Most recent by User_2025-02-11-07-07-59-045
-
Logged in UsersSummary List of Users logged into the ApplicationContent Team, Trying to find a way to pull a list of current users that are logged into the system. Any thoughts? Thanks…
-
Is there a way to restrict BI Admin role user to Query only Supply Planning related tables to buildSummary BI Admin - Role restriction per moduleContent We are already live with HCM and implementing Planning modules. When a user having only supply chain roles get BI A…
-
Cost Accounting Distribution TablesContent Hi Team, Can anyone help me with table name for all the transaction types and the cost distribution details present on attached screen. Regards Nidhi...
-
Lot Number received based on POContent Hi Freinds, I am trying to get a report based on Analysis having two subject area, Inventory-Inventory Transactions Real Time and Procurement-Purchasing Real Tim…