BI Publisher Reports
Discussion List
-
How to create report future "approver details" of requisitions in "Pending Approval Status*Summary: Customer requests a report listing future approver details of requisitions with “Pending approval” status. Content (required): The intent is to answer questions…Cesar Gonzalez-Oracle 216 views 5 comments 1 point Most recent by Michael Gibby - Huron Consulting Group Self Service Procurement -
Request Delivery Status Notification (Schedule Report Job)Summary: We have a client requirement where they would like to request Delivery Status notification to make sure that the Purchase Order document was successfully delive… -
Report for Services not yet received similar to Goods received not invoiced reportSummary: Which Report for Services not yet received similar to Goods received not invoiced report is available in BI Analytics Content (required): Version (include the v…Michelle Reid 69 views 4 comments 0 points Most recent by Thinlay Nono Wangchuk Inventory Management
-
Tax Codes for requisition and purchase orders lines / distributionsSummary: I am trying to construct a sql query to pull back details of tax_codes used on purchase orders (draft) and requisitions (unapproved) at line / distribution leve…
-
Missing Blanket Purchase Agreement information in tableSummary Missing Blanket Purchase Agreement information in table PO_HEADERS_ALLContent Hello, The Blanket Purchase Agreement PDF Report that I am working needs to show th…
-
OTBIWe are working on OTBI in report and anlytics in Fusion, and in that there is a requirement to create below reports through OTBI analysis. PR cycle time Rate of emergenc…
-
Print PO Line Tax Rate on PO LayoutSummary: We have requirement from business to print tax rate for each PO line on PO PDF Layout. Please confirm if it is possible to achieve this requirement. Content (pl… -
In PO PDF Output, new line should always be in next page, if whole line does not fit in current pageSummary: We customized Purchase Order PDF Report. But we want new line should always be in the next page if whole line doesn't fit in the current page but not able to ac…Chowdari Malapati Monika 17 views 0 comments 0 points Started by Chowdari Malapati Monika Purchasing
-
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…
-
How to customize confirm receipt notification in fusionSummary: How to customize confirm receipt notification in fusion Content (please ensure you mask any confidential information): Is it possible to customize receipt notif…
-
What is the database field/column for PO Charge Account?Summary: Our client would like the PO Charge account/distribution to appear on the PO PDF template. We did not find it in the seeded data model, which means we would nee…Farah Zekria 15 views 1 comment 0 points Most recent by Michael Gibby - Huron Consulting Group Purchasing -
How to generate Open Purchase Order report in oracle fusion?Summary: Content (required): Open Purchase Order report Version (include the version you are using, if applicable): Oracle Fusion Cloud Applications 23A (11.13.23.01.0) …Radha, Rangu 470 views 5 comments 0 points Most recent by Michael Gibby - Huron Consulting Group Purchasing
-
why "View PDF" button disappears when a BPA change order pending for approval ?Summary: Content (please ensure you mask any confidential information): when search agreement and click change order no. (pending for approval), it shows the change orde…
-
we want to know the maximum characters length supported in the Purchase Order PDF ReportSummary: We are not able to find the maximum characters size that is supported in the PO PDF Report which is generated using RTF Template(PurchaseOrderLayout.rtf). Purch…
-
Default Type Lookup for Item Transaction defaultsSummary: In the Item Transaction Defaults page, May i know the Lookup where Default Type values are stored Content (please ensure you mask any confidential information):…
-
Custom Purchase Order layout only working when PO in 'Incomplete' statusSummary Custom Purchase Order layout only working when PO in 'Incomplete' statusContent Hi, we've created a custom PO layout and data model. We linked it to the business…
-
Can cost center manager view all PR/PO charge to the cost center?Summary: Content (required): Can cost center manager view all PR/PO charge to the cost center? Either by viewing on the web or from report? Version (include the version … -
What is the database table and column for the PO requestor field on the manual POSummary: We have created a PO manually without a PR and provided Requestor information. We would like to know where this information is stored in database, in which tabl…
-
How to list all changes made against a BPM rule in given time period?Summary: How to list all changes made against a BPM rule in given time period? we are referring to table POR_AMX_RULES but it doesn't have changes made against any condi…
-
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 …
-
Purchase Orders are not using the latest BIP PDF templateSummary: Purchase Orders are not using the latest BIP PDF template Content (required): We have updated our PO RTF template and for some reason the changes are not being …
-
Limit Purchase order draft pdf from going in approval mailsSummary: Requirement is to limit users/approvers from seeing the draft of PO PDF. though, final pdf should go to supplier when PO is in open state. Content (required): T…
-
PO attachment not shown via custom data sourceHI Team, Initial issue was: We are running PO BIP report where we added a new custom data set in the data model that uses the Oracle Content Server data source URL (FA_U…Kalpesh Salunke-Oracle 6 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Purchasing
-
How to get more details of this package PO_BIP_HELPER.get_requester_name?How to get more details of this package PO_BIP_HELPER.get_requester_name?
-
Edit Purchase order page to implement one custom PO template on "VIEW PDF" buttonSummary: When user opens the Purchase order page , after clicking on "View PDF" , custom report should be called and report should be generated for corresponding PO .We …
-
how to pull PO Line level distribution accountSummary: how to pull PO Line level distribution account Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippe… -
what role is required for data model in oracle biSummary: what role is required for data model in oracle bi Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code sni…
-
PO E-mail Subject & Body Template changes not reflecting when the PO Print PDF is generatedSummary: I have made changes to the RTF template for Purchase Order E-mail Subject and Purchase Order E-mail Body template and uploaded it on to the application. But whe…
-
Archive all Purchase Orders PDFs automaticallySummary: Our customer wants to download all PO PDFs and store them in shared point or on cloud. Please support how can we do that? Content (required): Version (include t…Gaurav Paliwal 15 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Purchasing
-
SQL to retrieve all revision changes for an agreementHello, We have a requirement to print on the agreement pdf the complete list of changes that have occurred on the agreement. Does anyone knows how to retrieve this data …Sergio F Oliveira 16 views 3 comments 0 points Most recent by Michael Gibby - Huron Consulting Group Purchasing