BI Publisher Reports
Discussion List
-
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…
-
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 29 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Purchasing
-
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…
-
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 13 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_…
-
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 …
-
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 44 views 1 comment 0 points Most recent by Ed Gomez-Support-Oracle Enterprise Contracts -
PO Custom report with Total Currency Converted Ordered AmountSummary: Content (required): I am trying to write the custom query to get the PO total orderd amount , where I am using the" PO_BIP_HELPER.get_ordered_display (PHA.PO_HE…Shameer Muhammed P M 262 views 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Purchasing
-
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… -
Why Standard fonts are not reflecting in the BI Reports?Summary: I have used "Times New Roman" font in my RTF Template, but it is not taking that font in BI output report instead of that some other font is present. This issue…Pravallika Mamidipaka 44 views 3 comments 0 points Most recent by Melissa Carrick - Oracle-Oracle Purchasing
-
Deeplinks - How to use the return variable ?Summary: Deeplinks - How to use the return variable ? Content (required): Hello, I use this deeplink : ../fscmUI/faces/deeplink?objType=PURCHASE_ORDER_APUSER&objKey=poHe…
-
How to add P Card field in PO PDF templateSummary: How to add P Card field in PO PDF template Content (required): How to add P Card field in PO PDF template Version (include the version you are using, if applica…
-
Why View PDF is showing all PO instead a single PO PDFSummary: Using Custom PO Template Content (required): When clicking 'View PDF' after searching for a PO#, instead of showing single PO output, it is downloading entire P…Mahmoud Elbestawy 51 views 6 comments 0 points Most recent by Michael Gibby - Huron Consulting Group Purchasing
-
How to view the PDF for previous versions of POs/AGTsSummary: How to view the PDF for previous versions of POs/AGTs Content (required): I create a PO/AGT initially and i can view PDF. Later when i create a change order and…
-
Reports to capture auto approved purchasing documentsSummary: We have the requirement to get the auto-approved purchasing documents using a custom report. Need assistance to get the right tables or query to get those PO, P… -
Is it possible to show the Cost center in PO PDF?Content (required): Client would like to see item, quantity per delivery location and cost centers reflected in PO-PDF, is it possible? If yes, how? If not, any work aro…
-
User Defined Tables in SaaSSummary: Requirement for User-Defined Tables Content (required): A business requirement is to use a user-defined table in SaaS to be populated with data related to PR/PO…MohammedNasr 41 views 2 comments 0 points Most recent by Michael Gibby - Huron Consulting Group Purchasing
-
Requisitioning BU have null value for header and header linesI made the following query to give me the open agreements and their lines, in the table, some lines had a Requisitioning BU value but the majority does not. In this quer…