BI Publisher Reports
Discussion List
-
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…
-
Movement Request line - Status and status date history information tableSummary: In the Movement Request line, we can find status and status date information in INV_TXN_REQUEST_LINES. If there is a change in status from approved to closed, w…Guthi Mallikarjun 512 views 1 comment 0 points Most recent by Hari Kurra-Oracle Inventory Management
-
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…
-
Query to get the all the items and instrumental serial numbers.Summary: Content (required): need a query to get the all the items and instrumental serial numbers. Is there any thing like product_type='INST'? Version (include the ver…Guthi Mallikarjun 611 views 2 comments 0 points Most recent by Michael Gibby - Huron Consulting Group Inventory Management
-
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…
-
'Acknowledge By' on Supplier Invitation + RemindersSummary: Would like to know the system & how to use the current DUE DATE and reminders which are automatically set on a RFQ. Content (required): Example: An RFQ was laun… -
What is the Subject area can use to get Movement Request CountSummary: We need to get How many movement request are raised against specific inventory organization through the dashboard. We crated OTBI Using Costing- Cost Accounting…Navindu Amarasinghe 201 views 2 comments 0 points Most recent by Lynn Warneka-Oracle Inventory Management -
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 41 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for SCM
-
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…
-
OTBI REPORT from Purchase requisition to Invoice paidSummary: Report from Purchase Requisition to Invoice Paid Content (required): We need a report which show a full flow status from PR to purchase order to receipt and fin…Najumah Bibi Abdool Rahman 71 views 2 comments 0 points Most recent by Najumah Bibi Abdool Rahman Reporting and Analytics for SCM
-
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 41 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Purchasing
-
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 1.6K views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM
-
How to Identify dashboard reports / infolets from Oracle Fusion UI ScreenSummary: Identify dashboard reports / infolets from Oracle Fusion UI Screen Content (required): Hi, I have a requirement to identify the dashboard reports / infolets fro…
-
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… -
Print DFFs on buyers PDFSummary Printing descriptive flex fields on buyers PDFContent Hi, We would like to print DFFs on the cluses part of the byuers PDF. Is it possible?
-
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…
-
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… -
Is there a report or SQL that will show all adjustments of stock counts for items since inceptionSummary: There will be an audit soon in our client organization, is there any seeded report or SQL that will show all adjustment of Stock count done in an Inventory sinc…
-
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 11 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 21 views 3 comments 0 points Most recent by Michael Gibby - Huron Consulting Group Purchasing