Category 174
Discussion List
-
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 …Gauri Lande 41 views 1 comment 1 point Most recent by Raghavan p-Oracle Reporting and Analytics for SCM -
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 …Yerwin Blanco 221 views 2 comments 1 point Most recent by Yerwin Blanco Reporting and Analytics for SCM -
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 141 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 152 views 3 comments 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for SCM -
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…Nidhi Chhajed 219 views 1 comment 0 points Most recent by Sahil Makhiza 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 51 views 1 comment 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for SCM
-
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…Jahnavi-Oracle 14 views 0 comments 0 points Started by Jahnavi-Oracle Reporting and Analytics for ERP -
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 21 views 1 comment 0 points Most recent by Goutham.Manthri Reporting and Analytics for SCM
-
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 ThanksMirza_Adeel 21 views 1 comment 0 points Most recent by Umamaheswara Reddy Karri 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_2025-10-24-00-15-43-324 6 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 459 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 11 views 1 comment 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for SCM
-
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…Ghanshyam M-Oracle 123 views 6 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for SCM -
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_2025-10-24-00-15-43-324 13 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for SCM
-
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 …Swapnil Kashid 111 views 1 comment 0 points Most recent by Swapnil Kashid Reporting and Analytics for SCM -
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 …Saurabh Muthiyan 224 views 4 comments 0 points Most recent by Swapnil Kashid 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 22 views 1 comment 0 points Most recent by Kelly Cooper-Oracle Reporting and Analytics for SCM
-
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…