Reporting and Analytics
Discussion List
-
Need to call "Print Movement Request Pick Slip Report" from Movement Request pageSummary:Need to call "Print Movement Request Pick Slip Report" from Movement Request page Content (required):Need to call "Print Movement Request Pick Slip Report" from …User_2025-03-08-03-49-56-344 13 views 2 comments 1 point Most recent by PARAMARTHA BARIK Reporting and Analytics for SCM -
SQL query time exceeds the limit (1800 sec).Summary: I am building a report - Accounts Payable Trial Balance. While I am scheduling the BIP report, I am getting the error - SQL query time exceeds the limit (1800 s…
-
Item "Where Used" report in Oracle fusionSummary: Item "Where Used" report in Oracle fusion I want to prepare the data which tells this Item is used in all different work definition and its parent name. In EBS …Jignesh_HAE 10 views 3 comments 1 point Most recent by MANALI BISWAS-Oracle Reporting and Analytics for SCM
-
How to create depended LOV parameters (based on value set) in ESS jobHow to create depended LOV parameters in ESS job. The LOV parameters will be based on value sets. -
sql query to get details from Receivables > Accounts Receivable > Manage Tax on Advance ReceiptSummary: Looking for tables and sql query for the detail from page - Receivables > Accounts Receivable > Manage Tax on Advance Receipt Also the line and tax details from…Rahul K-Oracle 7 views 0 comments 0 points Started by Rahul K-Oracle Reporting and Analytics for SCM
-
The specified criteria didn't result in any data - For Purchase Requisitions and PO Details ReportsSummary: We have created a custom role by copying it BI Consumer Role, We have also added the Purchase Analysis role under this custom role so that users can access the …Shabbir M Tahasildar 17 views 3 comments 0 points Most recent by Shabbir M Tahasildar Reporting and Analytics for SCM -
how to trigger seeded version of the report if we have customization in BI reportswe customized Print Movement Request Pick Slip Report, and it's getting printed when we submit Pick Materials for Work Orders Report process. we have a requirement to ge…KabirB 13 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Apex to run bi reports and store files in DB tableSummary: We need Apex to call a SaaS BI Report and store the file report in a DB table. Content (please ensure you mask any confidential information): We need Apex to sc…
-
How can your report on Back dated receiptsDoes anyone know how you can report on back dated receipts FIN has allowed receivers to receive into the new year on orders for the previous year. the instruction is to … -
Custom Subject Area Primary Objects for ERP and SCM CloudSummary: What are the Primary Objects that we are supposed to have access to? I am looking at creating a Custom SA for Sourcing Responses. I only see the following: Cont… -
Querying 'Entered Unit Cost' and 'Material' from the 'Rolled Up Cost' ViewSummary: I need to make a query and retrieve the 'Entered Unit Cost' and 'Material' from the 'Rolled up Cost' view, but I'm not sure which table I should use to obtain t…
-
How to rollback customized PDF templateSummary: How to rollback customized PDF template? Content (please ensure you mask any confidential information): Hi Experts, I got this requirement to rollback the custo…Liwen Chiu 23 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
PDH Item Structure Structure Component audit database tablesSummary: I have a request to develop a custom audit report for PDH Item Structure and Structure Component. I'm looking for the database tables where I can sql data and c…Carlos Benassi 4 views 2 comments 0 points Most recent by Carlos Benassi Reporting and Analytics for SCM -
How to Split Rows in Excel BI Publisher Output (Nested Rows Inside One Row)Sure, here's a more polished version of your message: Hello Community, I am working on a scenario where I need to display data in multiple rows within a single row in an…
-
Is there any possibility to update the Sales Order Report Data Model - SalesOrderReportDMSummary: Is there any possibility to update the Sales Order Report Data Model - SalesOrderReportDM Content (required): Is there any possibility to update the Sales Order…
-
Item revision for onhand analysis reportSummary: Item revision for onhand analysis report. Content (please ensure you mask any confidential information): Created an analysis report using Inventory - Inventory …
-
Restrict "Edit" function on OTBISummary: Restrict "Edit" function on OTBI Content (please ensure you mask any confidential information): Hi Experts, I got this question that I am not able to restrict e…
-
Bursting Customer Statement Report on basis of legal entity of the Business UnitSummary: We want to generate customer statement reports on basis of legal entity of the Business Unit. We are making change in the statement data set by adding the legal…Akankshya Jena 12 views 1 comment 0 points Most recent by Daniel S.-Oracle Receivables & Collections
-
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 2K views 4 comments 4 points Most recent by User_IIM8T Reporting and Analytics for SCM -
can I make a warning massage in report parametersHello community, Can I make the same warning message in the screenshot in the report for parameters? No specific field is required but must enter at least one thanksAhmed Abdelaziz 31 views 3 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
Configure Prompt acting like a nested query?Summary: How to configure Prompt acting like a nested query? Content (please ensure you mask any confidential information): Hi Experts, Would like to reach out to you to…Liwen Chiu 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
How to keep search panel available when search result shows?Summary: How to keep search panel available when search result shows? Content (please ensure you mask any confidential information): Hi Experts, May I ask how to have th…
-
Requisition Report errors when filtering to one BUWe have a Requisition Approved Status report that runs a report for approved Reqs for our 3 Business Units, Report runs fine when ALL BUs are selected or even 2 BUs. But…Damien Curtis 12 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
I am trying to connect this table cst_layer_costs unit_cost with this table INV_MATERIAL_TXNSSummary: I am doing transaction stock movement report I am struggle with unit_cost column which I am taking the column from this table cst_layer_costs try to connect it …Khalid Aldosari-Oracle 17 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
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. 27 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for SCM
-
Usage of Prompt's "contains any" for both upper case and lower caseSummary: Usage of Prompt's "contains any" for both upper case and lower case Content (please ensure you mask any confidential information): Hi Experts, I am using subjec…
-
Work Definition Comparison reportSummary: Is there any existing report available to get below details? Work Definition Comparison report if not, what table I need to refer for this comparison? Content (…Jignesh_HAE 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Terms & Conditions in PO PDFSummary: Hi Fellow Developers, The requirement is to host Terms and Conditions file in Oracle cloud and it should be printed as hyper link in PO PDF. when ever a Supplie…Dhilip Kumar P. 14 views 1 comment 0 points Most recent by Sai Karthik Reporting and Analytics for SCM
-
Access the standard BIP report extracts via APISummary: Hi Team, We have a requirement to fetch and place the standard BIP extracts from UCM to some file server. example, once the ap invoices import process is comple…
-
How to develop a BIP / OTBI report to fetch details from VBCS pageSummary: Hi Team, We have a customized VBCS page for Inventory transactions. Our requirement is to develop a BIP / OTBI report to fetch details from the VBCS page. Is it…Dhilip Kumar P. 27 views 5 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM