BI Publisher Reports
Discussion List
-
How to use PO_BIP_HELPER.get_ship_to_cust_address function in Custom BI ReportSummary: How to use PO_BIP_HELPER.get_ship_to_cust_address function in Custom BI Report. Which parameters need to pass to this function. Content (please ensure you mask … -
Respond To Questionnaire Notification Report template is coming blank. 0kb file is downloading.I have to customize 'Respond To Questionnaire Notification Report' but unable to do so as report template is coming blank. When i am downloading rtf, 0 kb file is gettin…
-
how to extract One Time location entered in Ship to location on Purchase Orders using BIP reportWe want One Time location entered in Ship to location on Purchase Orders. Where it is stored? How we can extract using sql query.
-
How to retrieve data from Item 'History' tabSummary: I need to extract data from Item 'History' tab, like which Field(s) are Updated/Inserted with Old and New values and Date of action. If anyone having such sampl… -
Sales order report customization and how to get XML for current Sales orderSummary: I have to customize Sales order report of the below path. But this Data Model SQL query is not exposed. Oracle has provided the sample xml in datamodel properti…
-
Need Join between projects and item tables in fusionHi Team, I am using below query to fetch the data for Project Budget details. I am unable to fetch the join between project and egp_system_items_b tables.If any one havi…
-
Custom dashboard -How to provide link/details to export based on graph/chartSummary: Custom dashboard -How to provide link/details to export based on graph/chart Content (please ensure you mask any confidential information): we created custom da…Tapas_Sathua 23 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
Need a SQL/Query to Fetch PO Approval/Approver DetailsSummary: We are working on a custom report to display the pending PO approval queue. Is there an SQL query available to identify PO approval details? Version : 25DSuresh Kannan Saminathan 19 views 2 comments 2 points Most recent by SankarBalu Reporting and Analytics for SCM
-
Need a query to fetch the status of Manage Negotiations pageContent Hello, Can someone please tell me a table to fetch the status of the negotiation on the Manage Negotiations page. Please find the attached image with the require…Sushan Peiris 2.3K views 7 comments 4 points Most recent by kameshvarma Reporting and Analytics for SCM -
The .xls output format is missing on Scheduled process Advanced Options tabHi Community, When we try to run a BIP report from Scheduled Process and use the Advanced Options tab to select Output format, the .xls format is missing and only mhtml …Ankana Bhattacharya 45 views 1 comment 1 point Most recent by Andrada-Oracle Reporting and Analytics for SCM
-
ESS Job for BIP Report – Error During Scheduled Process ExecutionSummary: Hi Team, We have created an ESS job for the BIP report and assigned the appropriate ESS privilege to the custom role. However, when a user with this role attemp…
-
Infolets Receipt line: need to extract the querySummary: I need to extract the query under the infolets "Receipt Lines". Is it possible? Otherwise, how can I extract the lines in awaiting receipt, awaiting inspection …Giuseppe Galluzzo 159 views 8 comments 0 points Most recent by Kunal Verma Reporting and Analytics for SCM
-
How can I determine which weekday corresponds to DAY_START_NUM and DAY_STOP_NUM(ZMM_SR_PATTERN_DTLS)Hi everyone, I have a question regarding the ZMM_SR_PATTERN_DTLS table, specifically the DAY_START_NUM and DAY_STOP_NUM columns. In my case, I have: DAY_START_NUM = 1 DA…Andriampeno Odilon 14 views 1 comment 0 points Most recent by Andriampeno Odilon Reporting and Analytics for SCM -
How to pass parameter value from one job to another in ESS job setHi All, We have a ESS job set, input for the second ESS job would be the one of the parameter from the first ESS job. Can you please let us know how we can achieve this …Arunkumar Ponnusamy 159 views 3 comments 0 points Most recent by Ranga Swamy Ediga Reporting and Analytics for SCM
-
Invoke REST endpoint Integration in BIP report BurstingSummary: HI Is it possible to invoke Integration BIP report bursting? if yes then please give information integration configuration ? Content (please ensure you mask any…MayurM 9 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
How to make the report link variableSummary: Sandbox-How to make the report link variable Content (please ensure you mask any confidential information): Hi Team We have customized a report and use sandbox …Carol Tang 12 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
How to get the Base Price of an Item from the Price List corresponding to the Customer Ship to SiteSummary: Hello All, Could you please help me to get the base price of an item from the Price List corresponding to the Customer Ship to Site. And I have prepare an query…Deepak Bhatt 12 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
Parameter is not passing correctly to integration via HTTP(XML feed)summary: Hi I am trying to call integration using BIP with data model HTTP (XML) feed but it seems parameter is not going correctly in integration and getting one error …MayurM 16 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Which Oracle table is used to store the valueProduct Line Description under Product Line InformationSummary: Hi @everyone Can anyone have any idea that which Oracle table is used to store the exact value of below Product Line Information in the backend and how it shoul…Deepak Bhatt 7 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Need query for Change Order History TabSummary: I need query to extract these columns as mentioned in the screenshot.Ramsha Zameer 6 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
How can we customize the Receivables customer statement report with new parametersSummary: we have a requirement where we have to add a couple of dffs as parameters to the standard Customer statement report. Is this possible? Also, the customer wants …
-
Can we fetch tax classification code using subject areas under supplier address levelHi , We are trying to add tax classification field in otbi report using subject area Supplier - Supplier Real Time, we can get the details of tax classification code und…Vinay414 18 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
sample xml file to add column for workflow email notification not workingSummary: sample xml file to add column for workflow email notification not bringing columns to add to the email notification report Content (please ensure you mask any c…
-
REST API services feature for Oracle BI PublisherSummary: We are trying to access BI report through rest API. When we try the Oracle BI Publisher REST resources using the following URL structure https://:/xmlpserver/se…Kannan Ranganathan 560 views 8 comments 0 points Most recent by Sukanya Mukherjee Reporting and Analytics for SCM
-
Need Guidance on BI Report Performance Discrepancy (AR Invoices) - 25D PatchHi everyone, We’re running into a puzzling issue with a BI report based on AR Invoices and hoping for some advice or shared experience. Scenario: Our report joins ra_cus…
-
Can REST API be used to run ESS BIP Job Type? It returns Request Id = -1Summary: Can REST API be used to run ESS BIP Job Type? Why does the REST API return Request Id = -1? Content (please ensure you mask any confidential information): Oracl…Catherine Alequin 53 views 1 comment 0 points Most recent by Catherine Alequin Reporting and Analytics for SCM -
Error when running report using REST apiSummary: Error when running/calling the report using REST api. Content (please ensure you mask any confidential information): Hello Experts, Is there a way to call or ru…Shiva Kumar Bandaru 52 views 6 comments 0 points Most recent by Catherine Alequin Reporting and Analytics for SCM
-
Transfer Orders enabled - table fieldSummary: Transfer Orders enabled - table field Content (required): I am looking for what the correct database table field is for the below highlighted field in the UI un…KDR 64 views 5 comments 0 points Most recent by Kammarapalli Venkatesh-Oracle Reporting and Analytics for SCM
-
BIP Report issueSummary: Hi I am trying to extract Item master data . Count is huge and getting below error. What is way to extract all records in csv Content (please ensure you mask an…
-
Query for joining inventory transaction tables to costing transaction tablesSummary: I want to join INV_MATERIAL_TXNS table and CST_TRANSACTIONS to get the details of all the inventory transactions including costed transactions with their costin…