BI Publisher Reports
Discussion List
-
History of Requisition/ Negotiation view or download of attachment?Summary: Is there a way to get a history of a Requisition or Negotiation of the users who viewed the transaction or who downloaded a attachment of the requisition or neg… -
Query to get blanket purchase agreements and all their detailsSummary: I can't find a query to get the Blanket Purchase Agreements for oracle cloud fusion report. Content (required): I need to get the Blanket Purchase Agreements in…
-
Need Table or Subject area with "Assessable Value"Summary: We need to retrieve the information that is on column "Assessable Value" on the PO Lines. Content (required): Cannot find "Assessable Value" on any OTBI Subject…
-
convert date formatSummary: Need help with date formatting Content (required): substr(fleff.attribute_char5, 1, 10) to only display as MM-DD-YYYY Below is the query: SELECT substr(fleff.at…kalyan gade 111 views 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM
-
Are there downloadable dashboards for Supply Chain Management modules?Summary: I am looking for downloadable dashboards like the ones created by Caroline Gladwin (please refer to link: OTBI Sample Dashboards - 1. How to Install and Configu…
-
Remove Contract Terms in the Supplier Negotiation PDF ReportSummary: Remove the Contract Terms in the Supplier Negotiation PDF Report Is there a way to remove the Contract Terms template from the Supplier version of the Negotiati…
-
Inventory Onhand As of DateDo we have standard Report to check as of Balances lets say if customer wants to see onhand balances for 31-Jan-2022 on 11-Feb-2022 how to check through Standard Report
-
Manage Item Quantities - Page Composer - bindings.Segment1.attributeValue value not being passedSummary: Hi , I have a hyperlink added on 'Manage Item Quantities' screen in Inventory management. This hyperlink launches a BIP report which has Item number and organiz…Sravanthi Kollapudu-Oracle 31 views 2 comments 0 points Most recent by Sravanthi Kollapudu-Oracle Inventory Management
-
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 312 views 12 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for SCM
-
Can I set the parameter to require in Print Movement Request Pick Slip Report ESS job?Same as question. I am going to set From Movement Request and To Movement Request these two parameters to require. Any idea? I can't edit the row :( -
Deep Links for PO and PR in BIP ReportSummary: Hi Team, We have created BIP report with deep links for PO and PR. I have created one custom role to for PO / PR View only access. The user can see PR in UI how…
-
OTBI Reports for BPA or CPA ?Summary: Role requiered to create either a BPA or CPA ? Content (required): Hello I would like to setup either a BPA or CPA , I think the process is 1.-Create a BPA or C…
-
Custom Hold resolution notificationSummary: How can I export the data model to upload it as a sample xml to modify rtf template? What parameters do I need to enter in BI to view a report? When I enter the…Alexandra Bykhan 91 views 8 comments 0 points Most recent by Neeraj Pandey-Oracle Payables, Payments & Cash Management -
Looking for Entity Relationship Diagrams (ERD) for Procurement modulesSummary: Looking for Entity Relationship Diagrams (ERD) for Procurement models Content (required): Hi, At times we need to use Database tables to find the information we…
-
Interconnect Oracle fusion and Azure databasesSummary: We seek information to interconnect Oracle Application Fusion and Microsoft Azure databases. We need step by step process to connect these databases. Content (r…Sravana Pydimarry 31 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for SCM
-
Report to show what has been changed on a Change Order and on a RevisionContent Hello, is there any way to get what has been changed on a Purchase Order when there is a Change Order or there is a Revision? Many thanks, Mario -
Items of Master Org assigned to all inventory OrgSummary: We have a business case and wanted some input if anyone has any idea if there is any better way to handle Total Items in Item Master 20K (approx) Toal org 100+ …
-
Make Requisition Number as a Hyperlink in PO approval notification?Summary: Make Requisition Number as a Hyperlink in PO approval notification? Our client requires to make the Requisition Number as a Hyperlink in the PO Approval Notific…
-
Need the concept/logic behind why Retroactive pricing is viable only with Non-Cumulative Price BreakSummary We have a request from our client to have Retroactive pricing under Cumulative Price break in Blanket Purchase Agreement.Content Hi all, Based on my research, Fo…Harshith Eshwar Shaila-145631 290 views 6 comments 0 points Most recent by Alexander Joseph Purchasing -
Automaticly attach 'To Supplier' attachments to RFQ invite emailSummary: Is there a way to automaticly add 'To Supplier' attachments to the RFQ invite email? Content (required): Currently, only the Supplier PDF is automaticly attache…
-
Does anyone have a report for the po-headers_draft_table that includes the process code status?Summary: Following error message when importing orders 'The Order Number must be unique for this sold-to legal entity, supplier and supplier site'. Content (required): W…
-
Standard Report for On Hand quantity in OracleContent Hi All, Do we have any standard report in Oracle fusion , which we can run for org or sub-inventory in order to get on hand quantity? Regards Nidhi...Nidhi Chhajed 709 views 6 comments 1 point Most recent by Pragyanand-Das-Oracle Inventory Management
-
How to handle Daylight savings time change on custom BIP reportsSummary: Hi, we have few BIP reports where we are displaying time stamp on report output and this is a problem when we have the Daylight savings On. We can modify the co…
-
how to add CUPS server and fax4CUPS extension for fax service in Oracle cloudSummary: Client want to add fax server in Oracle cloud. Content (required): Hi team, In Oracle Cloud documentation we found the below- https://docs.oracle.com/en/cloud/p…
-
Deep Link RequisitionSummary: Content (required): Hello any of you ever used deep link for requisitions? if so how have you used it to see the detail of an RDA? on a report i would like to p…
-
Transaction Date (Parameter "param.p_date") shows up as prior day date for user but not for meSummary: Hello Forum-mates: A BI SCM report "Transaction Date" Parameter "param.p_date" expression is only showing prior date for the customer in accounting but whenever… -
Custom Data Model to create ReportSummary Use a Custom Data Model to create the PO DocumentsContent Hello, We need to use a Custom Data Model to be able to create our Purchase Order PDF Documents with al…