Category 174
Discussion List
-
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 5 views 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 20 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 15 views 2 comments 2 points Most recent by Lucky Sharma Reporting and Analytics for ERP -
Report Bursting CapacitySummary: Hi Team, We have a business requirement to send an email with a PDF attachment via bursting. Here are the specifics: Delivery Method: Email via Bursting Attachm…Sai Sreeram Gundepudi 12 views 1 comment 0 points Most recent by Lucky Sharma Reporting and Analytics for SCM
-
Is there a way to publish data from a report to an OIC service?Summary: Is there a way to publish data from a report to an OIC service? Content (please ensure you mask any confidential information): Is this architecture achievable? …Andres De la Ossa-Oracle 14 views 0 comments 0 points Started by Andres De la Ossa-Oracle Integration -
How to create report for pending Process Requisitions that not assigned yet to Purchase order.Summary: How to create report for pending Process Requisitions that not assigned yet to Purchase order. Content (required): Version (include the version you are using, i…Mohamed Haamdy 35 views 4 comments 0 points Most recent by Goopikrishnan Jayaraman-Oracle Reporting and Analytics for SCM
-
Is it feasible to customize print pick slip Report by adding new parameter?Summary: We have a requirement to add new parameter in the print pick slip Report. Is it possible to customize the data model and add the below parameter in the Report? …Abhiengine 56 views 1 comment 0 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for SCM
-
We need to extract all the sales Order data in excelSummary: Hi Team, Can we have a report which can help to extract all the sales orders which are open same like the fulfilment view export functionality. Currently the ex…Navneet909 26 views 1 comment 0 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for SCM
-
Please provide SQL query to get UCM file name,owner and upload date based on the UCM pathSummary: Kindly provide me the SQL query to get file name, owner and upload date from UCM based on the UCM path. Need this to create a parameter based LOV for ESS job. '…Lakshmi Bandlamudi 459 views 1 comment 0 points Most recent by Lucky Sharma Reporting and Analytics for SCM
-
I am facing issue with one of my custom BI report developed to extract COGS Revenue & Margin!Hi Folks, I am facing issues with one of my custom BI report developed to extract COGS Revenue & Margin. While running the report from Data Model Schedule window, I can …Sravan Komminedi 32 views 3 comments 0 points Most recent by Lucky Sharma Reporting and Analytics for SCM
-
Can i link 2 report in a dashboard that has 2 different subject area?In an OTBI dashboard containing reports from two different subject areas, can I configure a drill-down functionality where clicking on an element in the first report fil…Omran Zeaiter 35 views 3 comments 0 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for SCM
-
Report on approval workflow conditions and actionsSummary: Requiring to report on requisition and PO approval workflow rules setup (conditions and actions) Content (required): Is there a delivered or would anyone be wil…Bernadette Dorris 44 views 3 comments 0 points Most recent by SanjayC Reporting and Analytics for SCM
-
Behavior in PO_HEADERS_ARCHIVE_ALL recordsSummary: Behavior in PO_HEADERS_ARCHIVE_ALL records Content (please ensure you mask any confidential information): I am looking for an explanation of PO_HEADERS_ARCHIVE_…KDR 39 views 8 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM
-
LAST_UPDATE_DATE incorrect for PO_DISTRIBUTIONS_ALL - Creates issue for BICCC incremental loadsSummary: Has anyone faced th issue where the LAST_UPDATE_DATE is not being updated for PO_DISTRIBUTIONS_ALL/PurchasingDocumentDistributionExtractPVO even when the data i…Jahnavi-Oracle 23 views 2 comments 0 points Most recent by Jahnavi-Oracle Reporting and Analytics for SCM -
In oracle fusion which table locations nameDear , Can anybody guide me in oracle fusion which table have location name. i tried to find but i cant. Kindly check the attached pic i need these column in table where…Mirza_Adeel 5.1K views 5 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM -
Unable to find Oracle R12 Inventory tables in Oracle FusionHi, We are working on Fusion Implementation project. We have developed some custom reports in our Old Oracle R12, we need to develop it in Oracle Fusion. We face difficu…Chaitanya KM 42 views 2 comments 0 points Most recent by Chaitanya KM Reporting and Analytics for SCM
-
Need to send standard GL Trial Balance Report output to ftp server directorySummary: Customer has a requirement that the standard GL Trial Balcne report output will be uploaded directly to ftp server directory. There will be seperate file for in…User_SO7HU 39 views 1 comment 1 point Most recent by Gabriela Patrascu-Oracle General Ledger & Intercompany
-
need a query to fetch negotiation response details with price break informationSummary: Need a sql query to pull negotiation response details with price break information Content (please ensure you mask any confidential information): Version (inclu…SoumyaMukherjee03 384 views 1 comment 0 points Most recent by SoumyaMukherjee03 Reporting and Analytics for SCM
-
Need help locating "Trading Partner ID" fieldSummary: Need help locating "Trading Partner ID" field, to include in either BIP or OTBI reports. Content (required): Need help locating "Trading Partner ID" field, to i…Andrew_Schmitz 233 views 6 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for SCM -
How to get FND_FLEX_VALUES and FND_FLEX_VALUES_VL via BICCSummary: FND_FLEX_VALUES and FND_FLEX_VALUES_VL not available in BICC Content (please ensure you mask any confidential information): Hello…we are in BICC version Oracle …Jay Chandran 228 views 6 comments 0 points Most recent by Sreeram Tadepalli Reporting and Analytics for SCM
-
Unable to join Product management OTBI subject areasSummary: Hello Community, I have a requirement where I need to pull the Royalty data from the "Where Used" part of PIM. As part of that we are trying to join below subje…Sai Revanth 12 views 3 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
Subject area which will give me the conversion factor for a Purchasing UOM to a Stock UOMSummary: Subject area which will give me the conversion factor for a Purchasing UOM to a Stock UOM Content (please ensure you mask any confidential information): I need …Mike.Myers.CDIPRODUCTS.COM 45 views 3 comments 1 point Most recent by Mike.Myers.CDIPRODUCTS.COM Reporting and Analytics for SCM
-
Can I create a dashboard using multiple Oracle BI Publisher reports ?Can I create a dashboard in Oracle BI Publisher that combines data and visualizations from multiple BI Publisher reports? Specifically, I'd like to include graphs and ba…
-
I am looking to create an OTBI dashboard for RMAsSummary: I am looking to create an OTBI dashboard for RMAs. Want to display error messages and create alerts/agents. Content (please ensure you mask any confidential inf…sanjam1130 3 views 3 comments 0 points Most recent by Jagan Nori-Oracle Reporting and Analytics for SCM
-
select statement to get projects intercompany transactionsSummary: requirement is that have to create report for projects intercompany receivables transactions Content (please ensure you mask any confidential information): Vers…
-
Unable to join the field Display Name in Requisition Preparer in Procurement-Requistions Real TimeSummary: Hi All, Requirement : To add the 'Entered By' field from the Manage Requisition Header UI to an existing OTBI report (Full PO Report - Purchasing) Subject Area … -
Missing the Attribute Column in FLEX_BI_ItemBaseDFF_VISummary: Content (please ensure you mask any confidential information): using (FscmTopModelAM.EgpItemsPublicModelAM.ItemBaseDFFBIAM.FLEX_BI_ItemBaseDFF_VI) I'm attemptin…Waleed Fetoh 14 views 1 comment 0 points Most recent by Cornel Melinte-Support-Oracle Reporting and Analytics for SCM
-
Display Item number with and without Part numbers and Manufacturer in Custom Onhand Inventory ReportSummary: The query below displays all inventory item numbers with part numbers and manufacturer information. However, the report does not show items without part numbers…
-
Need PVO for description column corresponding to avespdescid ID column - EFFBPricing__AttributesSummary: Need PVO details for description column corresponding to avespdescid ID column Content (please ensure you mask any confidential information): Hi Team, We need t…Jahnavi-Oracle 46 views 1 comment 0 points Most recent by Cornel Melinte-Support-Oracle Reporting and Analytics for SCM
-
Sourcing Negotiation PDF - Tag which contains value for Allow Alternate Lines FieldSummary: Please help in Identifying if any tag pertains to "Allow Alternate Lines" field in Sourcing Negotiation PDF report. We have checked the below note but not able …Kumar Nandan-Oracle 17 views 1 comment 0 points Most recent by Himabindu B-Oracle Reporting and Analytics for SCM