Category 174
Discussion List
-
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 11 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
Web serivce API/SOAP to retreive item current cost and transaction cost by cost elementsSummary: Is there any API/SOAP to retrieve the item current cost and transaction cost by cost elements and not only total unit cost? Also, is the below API generated by …Abdul Karim OAMR 11 views 5 comments 0 points Most recent by Shyam Patel Reporting and Analytics for SCM -
How to undo LTR Direction that impact Data Model and Reporting BI AnalyticSummary: Hi everyone, I'm seeking help. Has anyone ever used the 'Force LTR Direction' option in an RFT template? I clicked it by mistake and can't undo it Content (plea…
-
Can a dynamic hyperlink be programmatically embedded within text in BI publisher report?We have a requirement to print attachments links in PO PDF report. The report should have the attachment name as a text, upon hovering over the text the hyperlink to the…
-
Issue with Subquery/Outer Query with BOM LEVEL - Results Messed UpSummary: Hi everyone, I would greatly appreciate any suggestions or help regarding the use of outer queries or subqueries. I want to use multiple subqueries and join the…
-
Reports for Product ManagementWhat are the Reports available for Product Management and from where we can see all that.
-
Print Page Number of Total PagesSummary: Case 1: In an analysis, how to print Page # of total pages? Case 2: Same analysis embedded in a Dashboard, how to print all lines from the analysis in PDF forma…VDM_IM 22 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP -
BI publisher report SQL error ; joining INV_TXN_REQUEST_HEADERSI'm creating report SQL, but when I executed the SQL I got an error. When I executed the SQL I got an error. There were no errors before I joined INV_TXN_REQUEST_HEADERS…
-
How to print all lines returned in dashboard from analysis in a PDF print format or PDF export?Summary: I created an analysis, embeded in a Dashboard. I also created a Report under Print & export options in the section Custom Print & Export Layouts. I added date &…
-
How to call pages from different moduleSummary: Hi All, I am working on a Idea to call pages from different modules. Here is how it should work Navigation>Order Management>Manage fulfilment lines. On this pag…Manohar Cheelangi Swamy 31 views 2 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for SCM
-
Extract DFF/EFF for Transfer Orders/Sales OrderSummary: Hi, We have a reqiurement to extract the DFF and EFF information for Transfer Orders and Sales order using BICC. We could able to find the below PVOs for extrac…Yash Jain 295 views 16 comments 0 points Most recent by Neha Aishwarya Reporting and Analytics for SCM
-
How to Insert/modify targets in main dashboard OTMSummary: Hi, I'm opening this ticket by suggestion from OTM CCC discussion: Is it possible to insert or update targets values in the main dashboard page? We have try to …Pablo Moreno 11 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
while creating the custom roles, getting unwanted subject areas in analysisSummary: Hello Experts, Our client has a requirement to create a custom role for restricted access to business users. While doing so, we could see in reports and analyti…Balaji Midhun Kumar Sanagapalli 11 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Need a SQL query to get the Total Quantity of Pending Transactions of a item in oracle fusionHi Experts, I need a SQL query to get the Total Quantity of Pending Transactions for a item. My requirement is to get "Available to Transact" Quantity of a item. ( = 200…Krishan_Palihakkara 196 views 2 comments 0 points Most recent by JGutierrezM Reporting and Analytics for SCM
-
How can we create a custom events to trigger the integration flowSummary: How can we create a custom events to trigger the integration flow. if we click a release button for a project the integration need to trigger but i am unable to…Veera venkata satya Ranga Prasad 21 views 1 comment 0 points Most recent by Abhilash K - Deloitte USI ERP Integrations
-
Query to get Item Class Change HistoryHi, Recently, some items in OC PLM had their class names changed, and I need to write a query to retrieve both the old item class name and the new item class name. I att…Ramsha Zameer 22 views 3 comments 0 points Most recent by Shyam Patel Reporting and Analytics for SCM -
Is it possible to create a customer index on Oracle Cloud ERP seeded tables?Summary: We are currently using a BIP report to extract recently created transactions from ra_customer_trx_lines_all, relying on the last_updated_date field. The report …Pradeep Moganti 22 views 1 comment 0 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections
-
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 21 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 1 view 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…
-
Help adding fields to Requsition templateSummary: Need guidance on adding specific fields to the Requisition template. We are trying to add to the template at the distribution level, the project name and task n…Ellen Manthei 1 view 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM -
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 …
-
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 13 views 1 comment 0 points Most recent by Daniel S.-Oracle Receivables & Collections
-
Which table in Oracle fusion stores the error messages while Importing sales Order using FBDIIn which table, can I find the error messages for any error occured during the Import Sales Order using FBDIRishabh33Maithani 728 views 3 comments 0 points Most recent by Murali01Jairaj Reporting and Analytics for SCM
-
Which BICC lineage sheet has details for AccountContactResponsibility?Which BICC lineage sheet has details for below PVO- FscmTopModelAM.FinArCustomersPublicModelAM.AccountContactResponsibility
-
How can I add suggested start date of a maintenance program generated work order to an OTBI report.?Summary: I am trying to add the suggested start data of a work order to an OTBI report. Work orders that are created by maintenance programs have a suggested start date.…Phillip_Shearer 1 view 1 comment 0 points Most recent by Ezra Anderson 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 32 views 3 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
Conditional Formatting to display field in redHi, In the PO template if the amountMohammed Rafi 23 views 1 comment 1 point Most recent by Santhosh Cholleti-Support-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…