BI Publisher Reports
Discussion List
-
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 12 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 158 views 3 comments 0 points Most recent by Ranga Swamy Ediga Reporting and Analytics for SCM -
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 144 views 7 comments 0 points Most recent by Malleswara_Rao_P 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 5 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 10 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 5 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle 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 38 views 0 comments 0 points Started by Ankana Bhattacharya 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 12 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-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…Anand P 30 views 1 comment 0 points Most recent by Gayatri Chappalli-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…
-
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…Shamsul_Wzd 104 views 2 comments 0 points Most recent by Sachin SCM-Oracle Reporting and Analytics for SCM -
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 549 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 46 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 48 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 63 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…
-
BI Publisher Service UnavailableWe are getting the message 'Service Unavailable' when attempting to access BI Publisher. All our automated reports are also impacted by this. They are not being sent.
-
Can we change the PO PDF Report Output name?Summary: Hi All, The requirement is to change the PO PDF report output name. Content (please ensure you mask any confidential information): Version (include the version …Dhilip Kumar P. 50 views 2 comments 0 points Most recent by Tapas_Sathua Reporting and Analytics for SCM
-
How to optimise a report to improve performance?Summary: We have a report related to Sales order & shipping details, which takes a lot more time than usual to load the parameters & also to fetch the required info even…Rudra_2024 10 views 3 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
BIP report to get the ESS job error details based on process idSummary: Hi Experts Does anybody have a BIP report sql query to get the details of error ESS process encounters in fusion post running the ESS scheduled process . Please…shaikh123 70 views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM
-
Need SQL query or table details in Oracle Fusion when item structures are loaded in reference orgsNeed SQL query or table details in Oracle Fusion when item structures are loaded in reference orgsDhilip Kumar P. 3 views 1 comment 0 points Most recent by SRGogula-Oracle 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 6 comments 4 points Most recent by Karthikk Reporting and Analytics for SCM -
Item Master ReportSummary Item Master ReportContent Hello, Can you please advise if there is an option or a seeded report in Fusion where we can get a list of all item code with their res…User_2025-02-05-12-20-44-163 212 views 9 comments 0 points Most recent by Chandramouli Potnuru Reporting and Analytics for SCM -
Query to get Receipt Accounting Transaction StatusHi Team, Please let me know from where we can get the Receipt Accounting - Transaction status column from backend. ( Navigation - Supply chain execution → Receipt accoun…