BI Publisher Reports
Discussion List
-
How to enable line of business users to search and view purchase agreements informationSummary: Content (please ensure you mask any confidential information): Customer is asking for how non procurement agents can search for POs, Agreements and Suppliers. T… -
Can we change email subject name of Suplliers for negotiation invitation and negotiation Award emailSummary: There is requirement from client that customized email subject name that send to supplier for negotiation invitation and negotiation Awarded email. Can this be … -
What is the character limitation to show Oracle Purchasing Text attachment on PO PDF DocumentSummary: We would like to know what is the character limitation to show the text attachment on the PO PDF Document. Content (please ensure you mask any confidential info…
-
Are there available standard reports showing the return transactions?Summary: Hi Community, Would like to check if there are Oracle standard report available showing the return to vendor transactions? Thank you. Content (please ensure you… -
Query to get Requisition and Standard PO details for the respective BPASummary: Query to get Requisition and Standard PO details for the respective BPA Content (please ensure you mask any confidential information): We are developing report.… -
Query to find the approved purchase requisition based on specific rulesSummary: Hi Team, We are looking for a purchase requisition information where the specific rules are triggered as part of the approval workflow Content (please ensure yo…
-
Scheduled BIP Report not Working post update to Recipients listSummary: A BIP report Scheduled to run once a week, made changes to the recipients list and observed the changes were not reflected in the next run, means recipient's li… -
Issue with HTML Tags in Excel Output from Oracle Fusion BIP ReportWe are encountering an issue in Oracle Fusion where HTML tags are appearing in the Excel output of a BIP report. This problem was observed during the creation of an RFQ …Venkatesh Babu Somalinga 31 views 2 comments 0 points Most recent by Venkatesh Babu Somalinga Reporting and Analytics for SCM
-
Open Oracle Cloud Application PDFs in the browser to avoid local downloading.Summary: Open Oracle Cloud Application PDFs in the browser to avoid local downloading. Content (required): Hi, So in a normal scenario when we will click on any of the P…
-
Can we create a custom dashboard for Managers to check all subordinates RFQ /Order detailsSummary: Can we create a custom dashboard for Managers to check all subordinates RFQ /Order details Content (please ensure you mask any confidential information): Need t… -
What is the logic for segregating the serial number between OnHand and Inbound quantities?Not able to segregate within the OnHand and Inbound details as we are getting the serial number based on Inventory_Item_id and because of this we see records are getting… -
AnyTable to get po status list which is used to store in document_status in po_headers_allSummary: Hi All, We have one requirement to pass the PO status as a parameter in PO details BIP Report. To create the SQL query for LOV we need distinct value of Po stat…
-
Assistance Required for Converting OTBI Query to Oracle Standard TablesSummary: I am reaching out to seek your expertise regarding the conversion of an OTBI query subject area into Oracle standard tables. Specifically, I am looking to under…Guthi Mallikarjun 21 views 8 comments 0 points Most recent by Guthi Mallikarjun Inventory Management
-
Replicating Oracle Function FND_CURRENCY.GET_FORMAT_MASK() using oracle standard tablesSummary: Need to replicate the functionality of the Oracle standard function FND_CURRENCY.GET_FORMAT_MASK()using oracle standard tables Requirements: Explain what FND_CU…
-
Explain the Hyperlink Behavior in Transfer Order ReportWe have developed a report named Transfer Order Report, which includes a hyperlink for the Transfer Order Number. We’ve observed the following behavior: If a Transfer Or…
-
PO PDF cannot be viewed online and attached from Email for requesterHi Everyone, We have created custom data model for PO PDF. We checked that the error caused for the PO PDF cannot sent to our requester after PO created. Is there any ad…
-
Can we replace PO PDF document with Other PDF DocumentsWe have a requirement to replace PO PDF document with other PDF Documents once POs are created. Is there any way we can replace PO PDF document. I know we can customize …
-
Budget Carryforward and Budget Transfer Movement DetailsDear Oracle Cloud Community, We are currently working on a requirement to fetch Budget Carryforward and Budget Transfer Movement details after executing the PO Carry For…
-
Print Commercial Invoice is ending up with retrying status.Hi All, We have a custom role and with privilege assigned print shipping reports. When i'm trying to run the Print commercial invoice, it is ending up retrying status. I…KSowmya 41 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Help Needed: Average Costing Logic – How to Carry Forward Updated Unit CostHi, I have a requirement to calculate the updated unit cost using the following formula and use the resulting value as the current unit cost for the next transaction row…RiyaKaushal123 11 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Need a SQL query to get all the transactions involving a specific serial number in Oracle FusionI need a SQL query to trace all the transactions for a specific item serial number involved in Oracle Fusion.Krishan_Palihakkara 656 views 8 comments 0 points Most recent by Krishan_Palihakkara Reporting and Analytics for SCM
-
How to fetch the below utility package source code from oracle fusion instance.Summary: We are working on the PO PDF report, to fetch requester phone number details. As per our analysis the requester phone number is begin fetched by utility package…
-
Table for Pick Slip Header StatusSummary: We are looking for the table that contains the Pick Slip Header Pick Status Content (please ensure you mask any confidential information): We are looking for th…
-
PO PDF CustomizationSummary: We have a requirement to highlight all the changed fields on the PO PDF for Changed Orders. Please let us know if there is any audit or other tables from where …
-
How to update PO communication to the supplier so that the supplier item number is included.?Summary: I need to update our PO template to include the supplier part number. I can see the value is passed in the XML but it is not populated in the PO rtf. What field…
-
Error downloading negotiation pdfWe have had the same custom layout for the negotiation pdf for years and suddenly we are unable to download a pdf. When trying to download the Buyer or Supplier pdf, we …
-
Change the watermark text on Incomplete PO printSummary: Is it possible to change the watermark text on Incomplet PO print? Content (required): Currently, the default watermark is 'DRAFT' on Incomplete PO. We want to …