BI Publisher Reports
Discussion List
-
'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 72 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 22 views 3 comments 0 points Most recent by Michael Gibby - Huron Consulting Group Purchasing -
Need Link between Requisition Item Type and Requisition TablesSummary: Hi Everyone I have a requirement to get Item Type from Requisition Lines screen. I managed to find the Lookup Type where it stored LOOKUP TYPE: POR_NCR_REQUEST_…
-
TIP: Configure Negotiation Invitation (BIP based) Email NotificationSummary Instructions on how to configure Negotiation Invitation (BIP based) Email NotificationContent Release 13 (Update 18A) allows you to opt into and enable Business … -
Seeded PO Print Template rtf – where does the HdrShiptoCustomerName value come from?Summary: The seeded PO Print Template contains a reference to ‘HdrShiptoCustomerName’, in the header Ship To region. Does anyone know where the ‘HdrShiptoCustomerName’ v…
-
Table name and column for Source AgreementSummary Table name and column for Source Agreement details of POContent what could be the Table name and column for Source Agreement details of PO(under procurment->mana…
-
Unable to find source Agreement table name in po tablesSummary Unable to find source Agreement table name in po tablesContent I have PO Report and need to bring Blanket purchase agreement column in Bi Publisher PO Report. I …
-
Fusion OTBI - Structure and Components Real TimeSummary Fusion OTBI - Structure and Components Real Time subject areaContent HI I am trying to do an OTBI Analysis with Structure and Components Real Time subject area t…Angel Espadafor 123 views 3 comments 3 points Most recent by tapan.nayyar Reporting and Analytics for SCM
-
How to Read File Contents of an Attachment on a Purchase Order using BIP report?Summary: We have created Attachments on a Purchase Order Header. Our Requirement is to read the file contents of the attachment using a BIP query. Is it possible to do t…
-
Is there any api available for fetch contract terms template data?Summary: Requirement to fetch contract terms template data from purchase agreement contract terms module. Content (required): We have a requirement to fetch the contract…Ancy Johnson 42 views 1 comment 0 points Most recent by Ed Gomez-Support-Oracle Enterprise Contracts -
PO and Organization table linkSummary: Hi I want to show PO number along with organization name. What is the table link Content (required): This required for BI report Version (include the version yo…
-
How to use distinct in the DFF value set querySummary: We have a requirement to add Line Manager DFF in the requisition line DFF for approval purpose. To get the unique values i am trying to use the Distinct functio… -
UCM access permission error while running Procurement BIP reportSummary: HI Team, We are running 1 PO report in which we have added a new data set in the data model that uses the Oracle Content Server data source (FA_UCM_PROVISIONED)…
-
Translation not working on Receipt Traveler Report when ran on receiving processSummary: Standard Receipt Traveler Report has translation to Canadian french on its template “Receipt Traveler Report”. Yet as per our tests, the translation is not work…
-
Does anyone have a sql to pull historic PO approvals/workflows?We have an audit request to provide the approval workflow for a change order last year. Since workflows are purged 30 days after completion, I cannot view this in ERP di…