Category 174-2
Discussion List
-
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…abRoman83 12 views 1 comment 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for SCM -
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 …Ashish_Kumar 11 views 3 comments 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for SCM -
Error while loading Sales order through FBDISummary: Getting error while loading sales order. This error occurs in source order 1103-F65660TEST, on source order line 1, source item name 846581, source item 300,000… -
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):…Kammarapalli Venkatesh-Oracle 1 view 0 comments 0 points Started by Kammarapalli Venkatesh-Oracle Reporting and Analytics for SCM
-
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…Amit Sutar 3 views 1 comment 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for SCM
-
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…Jasvinder Singh-Oracle 1 view 1 comment 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for SCM
-
Need to report which Orgs have a common BOM added in OTBI reportSummary: When I run a BOM report in OTBI only brings up the master org when other orgs have the common BOM added Content (required): We have a group of products where th…
-
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…
-
Query for joining inventory transaction tables to costing transaction tablesSummary: I want to join INV_MATERIAL_TXNS table and CST_TRANSACTIONS to get the details of all the inventory transactions including costed transactions with their costin…AeeTee 12 views 1 comment 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for SCM
-
FBDI Import -Items (FBDISummary: High volume data in Products while loading Inventory Orgs Content (required): Hi Folks, We are in process of Loading Items in our projects we have 11 lakh recor…
-
OrderChargeComponentExtractPVO extract contains duplicates for primary key while extraction.Summary: OrderChargeComponentExtractPVO extract(via DataSync) contains duplicates for primary key. Content (required): We are extracting data using the OOTB PVO 'FscmTop…
-
LAST_UPDATE_DATE incorrect for PO_DISTRIBUTIONS_ALL - Creates issue for BICCC incremental loadsSummary: Has anyone faced th issue where the LAST_UPDATE_DATE is not being updated for PO_DISTRIBUTIONS_ALL/PurchasingDocumentDistributionExtractPVO even when the data i…
-
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…ALASTAIR BURNS 1 view 1 comment 0 points Most recent by Swapnil Kashid Reporting and Analytics for SCM
-
Can I compare archived versions of supply plan in OTBI?Summary: I am trying to build analytics/ reports in OTBI, where I can compare different versions of the same supply plan. Content (required): does that work similar to A…
-
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 …Goutham.Manthri 1 view 1 comment 0 points Most recent by Goutham.Manthri Reporting and Analytics for SCM
-
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…User_HAXNL 3 views 3 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for SCM
-
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 …Saurabh Muthiyan 2 views 3 comments 0 points Most recent by Sahil Makhiza Reporting and Analytics for SCM
-
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…sanjam1130 2 views 1 comment 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for SCM
-
Can we customize the Award Negotiation Spreadsheet?Summary: Is is possible to customize the Award Negotiation spreadsheet? Also , is this report a BIP report in OTBI? If yes can you share the location? If it is not what … -
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…User_HAXNL 1 view 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for SCM
-
Need to call "Print Movement Request Pick Slip Report" from Movement Request pageSummary:Need to call "Print Movement Request Pick Slip Report" from Movement Request page Content (required):Need to call "Print Movement Request Pick Slip Report" from …MANISH KUMAR-145787 1 view 0 comments 0 points Started by MANISH KUMAR-145787 Reporting and Analytics for SCM
-
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…Farooq Syed , PMP 2 views 2 comments 1 point Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for SCM -
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…Eric Serra I Paradis 2 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for SCM
-
Do analyses run with Agents log to "OTBI Usage Real Time" subject area?Summary: Do analyses run with Agents log to "OTBI Usage Real Time" subject area? Content (required): Version (include the version you are using, if applicable): Code Sni…
-
Is there any standard Oracle reports for reconciling Receiving Inspection account?Summary: Content (required): We're looking to see if there's any standard Oracle reports to help reconcile receiving inspection account and review whether there are any …
-
R13 SCM and Procurement OTBI subject areas to database lineage mapping spreadsheetSummary R13 SCM and Procurement OTBI subject areas to database lineage mapping spreadsheet Content This spreadsheet is published by Oracle OTBI Development. …Ramamurthy Shankarachetty-Oracle 3.4K views 30 comments 30 points Most recent by Andrew_Schmitz Reporting and Analytics for SCM
-
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…
-
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…Pavel Buynitsky-Oracle 1 view 1 comment 0 points Most recent by Kelly Cooper-Oracle Reporting and Analytics for SCM
-
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 …
-
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…Anurag Gandhi 1 view 2 comments 0 points Most recent by Srinivas Pendyala-Oracle Reporting and Analytics for SCM