BI Publisher
Discussion List
-
Adding Attachments to Extensible Work Order Traveler ReportSummary: We have a requirement to customize the Work Order Traveler report and hence were thinking we can use the 'Extensible Work Order Traveler Report'. But when we tr…Deepthi Suravaram 121 views 19 comments 0 points Most recent by Deepthi Suravaram Reporting and Analytics for SCM -
Review Receipt Accounting Distributions Details OTBI ReportSummary How to pull OTBI data for details shown in Review Receipt Accounting Distributions user interfaceContent Does anyone know how to pull Review Receipt Accounting D…
-
Need to display transaction details present under Review Production Transaction History ScreenSummary: I Need to display all the transaction details present under Review Production Transaction History Screen. Please let me know the table that stores Production Tr…
-
Unable to retrieve information stored in the user session variables can be retrieved via SQLSummary: We are creating custom infolets and deploying them on the landing page as a part of our implementation. These infolets have parameter prompts. We wanted to popu…
-
Does anyone who a query to fetch the PO number created relevant to a Transfer Order Inter organizatiContent Hello all, I need a query that picks the PO number generated for the transaction type Transfer Order Inter organization Receipt in review completed transactions.…Sushan Peiris 394 views 7 comments 1 point Most recent by Vrinda Mittal Reporting and Analytics for SCM -
planned service provider in transportation intelligenceHello can you please advise if there is a Planned Carrier (Planned Servprov) column in Transportation Intelligence or I am overlooking it? we are calculating a PTA % but…TatianaS 1 view 1 comment 0 points Most recent by Islam Bahgat-Oracle Reporting and Analytics for SCM
-
How to cancel scheduled reports?Summary Steps to cancel the scheduled custom reportContent Hi All, Can somebody please help me with the navigation to cancel the scheduled custom reports in Cloud? Thank…MAHESH TALWADE 42 views 4 comments 0 points Most recent by Erica Williams Reporting and Analytics for SCM
-
Are there any seeded infolets available for HCM?Summary: I enabled HCM Infolets in Rel 23C. However, it only resulted in a blank HCM infolets page. Are there any seeded infolets available for HCM? If so, how can I ena…
-
RTF Font not being rendered in PDF outputSummary: RTF Font not being rendered in PDF output Content (required): We are trying to use a specific font in our PO RTF template called Script MT Bold : However when w…
-
Query in BIP report not showing result, what can I do to make it work? (SQL included)Summary: Content (required): Hi, I have created a report containing the receipts made for the selected time period. The report is showing the result when I limit the per…Mariyam129 31 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for SCM
-
Query to Derive tax amount for a purchase orderSummary: Looking for a query to calculate tax amount for a purchase order Content (required): Looking for a query to calculate tax amount for a purchase order Version (i…Ripendra Kumar-Oracle 441 views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM
-
Query to Derive Budget information for a purchase orderSummary: Looking for a query to derive Budget information(below highlighted columns) for a purchase order from the below screen,i.e Budget Account ,Budget Period and con…Ripendra Kumar-Oracle 241 views 2 comments 0 points Most recent by Ripendra Kumar-Oracle Reporting and Analytics for SCM
-
Can anyone help me tune the query which i have wriiten to fetch the goods received not invoicedSummary: Can anyone help me tune the query which i have wriiten to fetch the goods received not invoiced since its having performance issue. Content (required): select p…Rudraksha Vishnu 11 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for SCM -
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…
-
Fusion OTBI - Structure and Components Real TimeSummary Fusion OTBI - Structure and Components Real Time subject areaContent HI I am trying to do an OTBI Analysis with Structure and Components Real Time subject area t…Angel Espadafor 98 views 3 comments 3 points Most recent by tapan.nayyar Reporting and Analytics for SCM
-
BIP ESS Job ErrorSummary: create ESS Job For BIP Report ,Go error when run Schedule Process Content (required): Version (include the version you are using, if applicable): Code Snippet (…
-
Update the code in Min Max Planning packageSummary: To update the code in the Min Max Planning package Content (required): Hello Gurus, In the Min Max ESS Planning ESS Job, it has an event trigger (before and aft…
-
Subject area which can be used to display the approval chain of RequisitionsSummary Subject area which can be used to display the approval chain of RequisitionsContent Hi, We have a requirement where we need to display the requisitions which are…Kalyan Reddy 45 views 3 comments 0 points Most recent by Fabiana De Arruda 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…Lucky Sharma 41 views 1 comment 0 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for SCM -
How to use BIP schedule trigger.Summary: I want to notify only when the number of detected cases under specific conditions is 1 or more, but please tell me what kind of SQL should be set for the event …Maki,Tomofumi 51 views 1 comment 0 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for SCM
-
please suggest database tables/how to calculate Available to reserve and Available to transact QtySummary: We want to fetch Available to reserve and Available to transact Qty based on lot details from the database tables. Can you please suggest the database tables/ho…KOTTHURI ASHOKBABU 21 views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM
-
How to invoke a BIP report with parameters from Oracle cloud ERPSummary: Can we invoke a custom BIP report with parameters from the items application page. Content (required): We want to call the report in the same way as how the Gen…Neela.Voduguru 31 views 1 comment 2 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM
-
Different filename based on a parameter value of report using ESS jobHi All, How to achieve custom filename using report parameter value as part of filename Example: ABC_XYZ_Timestamp.xml or ABC_XYZ_Timestamp.csv ABC is part of the file, …Swapnil Kashid 1 view 1 comment 0 points Most recent by Swapnil Kashid Reporting and Analytics for SCM -
Bursting report in errorSummary: The log shows the following error: BIPJobExecutable Execution failed with Client received SOAP Fault from server : PublicReportService::generateReportDefinition…Giuseppe Galluzzo 171 views 12 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for SCM
-
SCM Dashboard ReportI am looking for end to end O2C lifecycle details in report. Do we have any sample report report with this requirement ? Below are the columns I am looking into it. Sale…Oracletechnofunctional 61 views 2 comments 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for SCM
-
BI publisher for Demand Plan custom measures.Summary: Hi all, please I would thank for any help with the following. We need the query below this Demand Plan screens. Example 1. Example 2. We have noticed some table…Juan Jesus 61 views 3 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM
-
What time does the User Password Changes Audit Report show?Summary: I'm running the User Password Changes Audit Report and I'd like to know what time zone does the report output show. Content (required): User Password Changes Au…Adrian Svet-Oracle 41 views 4 comments 0 points Most recent by Adrian Svet-Oracle Reporting and Analytics for SCM
-
In PO Print PDF report , how can we avoid canceled line in PDF outputSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Kumar Nandan-Oracle 31 views 2 comments 0 points Most recent by Goopikrishnan Jayaraman-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…
-
work order fetch based on asset number and asset work center nameSummary: Hi Experts I want to create a BIP report to fetch work orders with parameters asset number, asset work center name, item number and work order work center name.…Sharmava 11 views 1 comment 0 points Most recent by Aravindan Sankaramurthy -Oracle Reporting and Analytics for SCM