BI Publisher
Discussion List
-
Querying 'Entered Unit Cost' and 'Material' from the 'Rolled Up Cost' ViewSummary: I need to make a query and retrieve the 'Entered Unit Cost' and 'Material' from the 'Rolled up Cost' view, but I'm not sure which table I should use to obtain t… -
BI publisher report SQL error ; joining INV_TXN_REQUEST_HEADERSI'm creating report SQL, but when I executed the SQL I got an error. When I executed the SQL I got an error. There were no errors before I joined INV_TXN_REQUEST_HEADERS…
-
Query to get Item Class Change HistoryHi, Recently, some items in OC PLM had their class names changed, and I need to write a query to retrieve both the old item class name and the new item class name. I att…Ramsha Zameer 21 views 3 comments 0 points Most recent by Shyam Patel Reporting and Analytics for SCM -
Is it possible to create a customer index on Oracle Cloud ERP seeded tables?Summary: We are currently using a BIP report to extract recently created transactions from ra_customer_trx_lines_all, relying on the last_updated_date field. The report …Pradeep Moganti 21 views 1 comment 0 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections
-
Is there any possibility to update the Sales Order Report Data Model - SalesOrderReportDMSummary: Is there any possibility to update the Sales Order Report Data Model - SalesOrderReportDM Content (required): Is there any possibility to update the Sales Order…
-
Help adding fields to Requsition templateSummary: Need guidance on adding specific fields to the Requisition template. We are trying to add to the template at the distribution level, the project name and task n…Ellen Manthei 3 views 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM -
Bursting Customer Statement Report on basis of legal entity of the Business UnitSummary: We want to generate customer statement reports on basis of legal entity of the Business Unit. We are making change in the statement data set by adding the legal…Akankshya Jena 13 views 1 comment 0 points Most recent by Daniel S.-Oracle Receivables & Collections
-
Need a query to fetch the status of Manage Negotiations pageContent Hello, Can someone please tell me a table to fetch the status of the negotiation on the Manage Negotiations page. Please find the attached image with the require…Sushan Peiris 2K views 4 comments 4 points Most recent by User_IIM8T Reporting and Analytics for SCM -
can I make a warning massage in report parametersHello community, Can I make the same warning message in the screenshot in the report for parameters? No specific field is required but must enter at least one thanksAhmed Abdelaziz 32 views 3 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
Conditional Formatting to display field in redHi, In the PO template if the amountMohammed Rafi 22 views 1 comment 1 point Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for ERP -
Database table to get the min and max quantity for Replenishment plan type item in oracle fusionSummary: Hi all, please let us know Database table which stores min and max quantity for Replenishment plan type item in oracle fusion Content (please ensure you mask an…User_WCAA0 24 views 3 comments 0 points Most recent by Paul H - Terillium Reporting and Analytics for SCM
-
Terms & Conditions in PO PDFSummary: Hi Fellow Developers, The requirement is to host Terms and Conditions file in Oracle cloud and it should be printed as hyper link in PO PDF. when ever a Supplie…Dhilip Kumar P. 11 views 1 comment 0 points Most recent by Sai Karthik Reporting and Analytics for SCM
-
how to get data for destination location in Transfer order?I need destination location for transfer order. how to get that? which table i used to join with to get location name?
-
Is there any specific way in which we can get all the Supplies and Demand related SP data in one BIPSummary Is there any specific way in which we can get all the Supplies and Demand related SP data in one BIP Report?Content I want to know if there any specific way in w…Renuka Soneja-154959 40 views 3 comments 2 points Most recent by User_KMKTM Reporting and Analytics for SCM -
Label printing on Brady Printer shrinking the size of labelSummary: Label printing on Brady Printer is shrinking the size of label. We successfully printed a label, but the printer scaled down the dimensions. It printed only 3 c… -
How to develop a BIP / OTBI report to fetch details from VBCS pageSummary: Hi Team, We have a customized VBCS page for Inventory transactions. Our requirement is to develop a BIP / OTBI report to fetch details from the VBCS page. Is it…Dhilip Kumar P. 23 views 5 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
Query to get payment method field in Order Management in Oracle FusionContent Hi all, Can someone tell me from where I could pick the payment method field mentioned at the front end of the Order management page? I have checked for the tabl…Sushan Peiris 985 views 2 comments 4 points Most recent by Shishir Dhone Reporting and Analytics for SCM
-
Can we get ZPL output for Zebra Printer from Oracle BI PublisherSummary: We need to get ZPL output for Zebra Printer from Oracle BI Publisher. Is it possible to get that. Please advise. Content (please ensure you mask any confidentia…Sandipan_Chakraborti07 11 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Inquiry Regarding Dynamic User Inclusion in Report Emails via BurstingSummary: Hi Oracle Experts, We have received a request from our users to include the username of the individual executing a report in the email body after the "Thanks" s…Sai Sreeram Gundepudi 23 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
Approvers not able to see customized data in approval notificationSummary: Approvers not able to see customized data in approval notification. Content (please ensure you mask any confidential information): We have added few DFF from po…
-
where can i find receiving and inbound quantity's for on hand reportSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…User_3KQOD 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
DFF field should autopopulate based on the other field(actual field from UI)Summary: We have created a DFF field in Invoice header page under additional information tab. The business requirement is , we need to populate the list of values for th…Chandana Priya-Oracle 11 views 1 comment 0 points Most recent by Chandana Priya-Oracle Payables, Payments & Cash Management
-
Tables for Audit Report Page Details that are under Tools Tab in UI PageSummary: We need to build a BI report that extracts the Audit Report Details under Tools tab as Shown in below image. Could anyone please suggest the tables that have th…Chandana Priya-Oracle 33 views 4 comments 0 points Most recent by Chandana Priya-Oracle Reporting and Analytics for SCM
-
Is there any possibility to have a delay or wait time in between the "Print Pick Slip Report" jobsSummary: Is there any possibility to have a delay or wait time in between the "Print Pick Slip Report" jobs Content (please ensure you mask any confidential information)…
-
Extract a list of custom reports in HCM from OTBI and BI PublisherSummary: Is it possible to extract a list of custom reports created in OTBI and BI Publisher, including: The subject areas and folders used, and the fields in them and o…Paul Morrissey 13 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
Move Dashboard Page to a subpageSummary: Hi, I have created a dashboard with multiple Subpages under one Dashboard page. When i rename the Subpage names (In Dashboard Properties), somehow its convertin…Sudheer YN 125 views 8 comments 0 points Most recent by Dianne Barnhouse Reporting and Analytics for SCM
-
ORA-00932: inconsistent datatypes: expected DATE got NUMBER in SQL data model per KM 2888420.1Summary: When trying to use the SQL provided in KM Fusion CST: SQL Running Behind Analyze Standard Purchase Cost Variances (Doc ID 2888420.1) i am getting an error in th…Maria Angelica Mendoza 91 views 1 comment 0 points Most recent by Manikandan S R-Support Oracle-Oracle Costing -
How to obtain xml for Supplier Negotiation PDF ReportSummary How to obtain xml for Supplier Negotiation PDF ReportContent Hi All When I look at the bip template layout for Supplier Negotation PDF Report it is not linked to…User_2025-01-31-15-11-25-562 221 views 2 comments 0 points Most recent by Melissa Carrick - Oracle-Oracle Reporting and Analytics for SCM -
Unable to print from ERP cloud to on-premise Print serverSummary: We implemented in Integration between Oracle ERP Cloud and On-Premise print server as mentioned in Doc ID 1964157.1 and completed all steps mentioned in above d…G Balaji 103 views 3 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
how to pass the parameter Item/Change notice to our DM based BIP reportSummary: We have a Report on which we want to pass the Item number/Change Number to the BIP Report, However the report is not passing the parameter which we are passing …Prakash Shetty 13 views 2 comments 0 points Most recent by Prakash Shetty Reporting and Analytics for SCM