BI Publisher Reports
Discussion List
-
Approvers not able to see customized data in approval notificationSummary: Approvers not able to see customized data in approval notification. Content (please ensure you mask any confidential information): We have added few DFF from po… -
where can i find receiving and inbound quantity's for on hand reportSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…User_3KQOD 2 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Review work order cost View Detailed balance UI: Need table for Cost Allocation FactorSummary: Hello Community, I'm developing one report related to manufacturing costing for which I need table name for Cost Allocation Factor. Any leads will be helpful. P…Ramya Dev 11 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Query to get Inventory valuation quantitiesSummary: I am looking for the query to get the inventory valuation quantities based on inventory organization. When we view the data for a period for a cost organization…
-
Combine columns of PO catalog, category, Accounting Code into 1 reportSummary: Combine columns of PO catalog, category, Accounting Code into 1 report Content (please ensure you mask any confidential information): Hi Experts, Would like to …
-
How to access and print attachments in Quality Action/Issue ReportSummary: We have a new business requirement where they want a report that lists/print all the attachments of each Quality Action/Issue available in Attachments section. …
-
Email Both PDF and XML Format with Bursting QueryI have a custom packing slip report that is triggered off a customized scheduled process and the bursting query in the data model of my report handles the email output. …KTbsa1234567 62 views 2 comments 0 points Most recent by KTbsa1234567 Reporting and Analytics for ERP
-
Extract a list of custom reports in HCM from OTBI and BI PublisherSummary: Is it possible to extract a list of custom reports created in OTBI and BI Publisher, including: The subject areas and folders used, and the fields in them and o…Paul Morrissey 11 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
Need query to calculate average cost of item.Summary: Need query to calculate average cost of item. Cannot use the item PAC from the PAC item cost table instead wanted to use the inbound transaction for calculating…Mukesh_Kr 56 views 1 comment 0 points Most recent by Mirza Muhammad Mohsin Baig Reporting and Analytics for SCM
-
Need a query to get details in manage project costs -> view accounting detailsSummary: I need to add the GL Account column from manage project costs -> view accounting details UI. This data can be found by going into the transaction and going to A…
-
Equivalent report for Israeli Localization Withholding Tax Certificates Expiry Date reportSummary: Hi, We are in middle of migration to cloud and we are looking to see the equivalent report for the 11i report "Israeli Localization Withholding Tax Certificates…Anand Balasubramanian 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Does anyone know how to find Journal Entries Details in Cost Transactions?Hi Everyone, Does anyone know a query to get Journal Entries Details in Cost Transactions?S.heha.n 11 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
need a query to get the unit price of subscription invoiceSummary: we need a query to get the unit price of subscription invoice. Content (please ensure you mask any confidential information): Version (include the version you a…Sai Divya Kolachana 22 views 1 comment 0 points Most recent by Ed Gomez-Support-Oracle Subscription Management
-
How to check the error message in Manage PO when funds status is failedHi All, Could you please let us know where does the error message of Funds Status gets stored. The ask is to show the Error message of an PO when it's Funds Status is fa…Naresh313 14 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Not able to get any Data from the table INV_MIN_MAX_GTSummary: Not able to get any Data from the table INV_MIN_MAX_GT. Do we need any specific roles or data access for that Content (please ensure you mask any confidential i…Chaitra Kayi-Oracle 41 views 3 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM
-
Can't found the "objType" deep link for SCM - Confirm Pick Slip pageWe seeking to create a deep link that connects between BI report and the "Confirm pick slip" page from the Inventory management page, also we searched through this docum…Mohammad Hussein 1 view 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM
-
How to know what are the data accesses and priviliges needed to view a table from a BI reportSummary: I would like to know how I can relate permissions, data access, and privileges necessary to view a table. For example, I would like to know what permissions are…
-
Which column from REVISIONS table needs to be mapped to Document ID of Content server dataset?My goal is to read contents of file in UCM and append it to PO PDF. Currently, I am using DID column from REVISIONS table and mapping it to Document ID of Content server…
-
Columns from View Billing Extension Event Details page not found in the backend tablesNeed backend tables or reference code for the below listed columns. Navigation: Navigator >> Contract Management >> Revenue >> Task >> Manage events >> query a contract …
-
SQL query or Table for Cost Accounting DistributionsSummary: Hi Team, Need a table which stores the information of Cost Accounting Distributions. Required columns: Run control, preprocessor, Cost prcocessor, Status, Cost …Opkey PA 1 view 2 comments 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Facing an Issue to ge the PIM Default Buyer DetailsSummary: HI Team, We need to get the PIM Default buyer details to an Item. We have used the below query to get the buyer details. ( select max(ppn.display_name) from po_…Venkateswari 14 views 3 comments 0 points Most recent by MANALI BISWAS-Oracle Reporting and Analytics for SCM
-
ESS job is running longtime in JobsetWe have created a Jobset with 2 ESS jobs. First ESS Job is completed fast and second ESS Job is running longtime and not completing. When we run the second Job independe…Lakshmi Bandlamudi 21 views 3 comments 0 points Most recent by Shravan S Kumar-Oracle Reporting and Analytics for SCM
-
Performance considerations while doing Bulk Email BurstingSummary: At a time, need to send around 5K email notifications to supplier/supplier sites belongs to country . Content (please ensure you mask any confidential informati…Busireddypolimera 11 views 1 comment 0 points Most recent by MiaM-Oracle Reporting and Analytics for ERP
-
PVOs with one to one relationships to base tablesSummary: Hi, We are building a Lakehouse on databricks using PVOs as source. Since PVOs are a combination of base tables together it is some time harder to get the data …Rajat N 22 views 1 comment 0 points Most recent by Deshin Pillay-Oracle Reporting and Analytics for SCM
-
How to print label to printer using rest api when running the BIP report?Summary: How to print label to printer using rest api, currently I'm using the erp integration endpoint from the fusion rest api guide to generate the label in XML. Howe…mayank_tripathi 27 views 1 comment 0 points Most recent by Saranya Sounderrajan Warehouse Management
-
which privilage is needed to run 'Item Txn with Average Cost report'Summary: Hello experts , Our customer wants to give access to the user for 'Item Txn with Average Cost report' . They don't want to give the entire access of inventory s…Shalini Singh-Oracle 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
The File Was Not Downloaded or Was Not Downloaded Correctly - PO PDFSummary: I recently updated my PO PDF report template and uploaded it. When I try to view that in View PDF in front-end, it throws the error "The File Was Not Downloaded…Vigneshvaran KJ 496 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
We need assistance in identifying table(s) that capture shipment errorsSummary: Hi Team, We are building a BI report to fetch errors that occur during the shipment process triggered by HighJump via REST API. Currently, the team identifies e…Sai Sreeram Gundepudi 1 view 1 comment 0 points Most recent by Jagan Nori-Oracle Reporting and Analytics for SCM -
How to add page break for a HTML output of BIP Report. Please Advise.Summary: Page Break not working in HTML output of BIP Report. Content (please ensure you mask any confidential information): Version (include the version you are using, …Satya.Munagala 19 views 4 comments 0 points Most recent by Satya.Munagala Reporting and Analytics for SCM
-
i want sql query to find business days differnece between two datesSummary: I want a query in sql to get businees days between two dates E.g i have two dates of differnet tables the gap is of 15 days or may be 7 days or may be 30 i want…Abdur Rehman 11 views 2 comments 2 points Most recent by Lucky Sharma Reporting and Analytics for ERP