To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for SCM
Discussion List
-
Requirement to show the Requisition attachments(.PNG) in Fusion PickSlip Report. Please advise.Requirement to show the Requisition attachments(.PNG) in Fusion PickSlip Report. Please advise. -
Task number table to create value set for dffTask number table to create value set for dff in PO line level. I have tried: PJO_XCC_CTRL_BDGT_LOW_RES_V PJO_XCC_CTRL_BDGT_SEGMENTS_V PJO_XCC_CTRL_BDGT_LOW_TASK_V PO_DI… -
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…
-
Requirement to show the Requisition attachments(.PNG) in Fusion PickSlip Report. Please advise.Requirement to show the Requisition attachments(.PNG) in Fusion PickSlip Report. Please advise.
-
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? …
-
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…
-
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. '…
-
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 …
-
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…
-
Requirement send standard GL Trial Balance Report output to Sftp server directorySummary: We have a requirement that the standard GL Trial Balance report output will be uploaded directly to more secure sftp server directory. There will be separate fi…
-
Requisition Approval Rule Report that includes all other tasksSummary: The requirement of This report should include: Requisition Approval Rule Report that includes rules for “requisition approvals” task and all other tasks related…
-
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…
-
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_…
-
Inquiring about business object in audit reportSummary: Hi team, Please help us with the following questions: 1. What kind of log will appear when Business object type is not selected and is blank? 2. Are there any b…
-
Unable to retrieve the data from OTBI Analysis when two subject areas are addedSummary: In BI Publisher application, the requirement is need to add the contract number(Subscription Number) and known as columns to the customer contact information OT…
-
Query to get Change Orders details like changed/updated data like PO amount, Invoice Number and InvContent Hello all, Can someone tell from where I could pick the details for Change Orders details for a Purchase Order which is in "Open" status and if changes are made … -
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… -
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… -
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…
-
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 …
-
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…
-
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… -
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 …
-
Sales Order Report CustomizationContent Good People, Whats the best way to customize the Sales Order Report Data Model. One cant download or open the data model SalesOrderReportDM . Any one customized … -
Sales Order EFFs not showing up in OTBISummary Sales Order EFFs not showing up in OTBIContent Hi Experts, We have created few EFF in the Sales Order Header (with BI enabled), those EFF are not showing up in t… -
I need the table where I can retrieve the lot number for inspection (inventory type)Summary: Select statement to retrieve the lot number of the inspection that has been created with Inventory type Content (please ensure you mask any confidential informa…
-
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…
-
Is there any standard Oracle reports for reconciling Receiving Inspection account?Summary: Content (required): We're looking to see if there's any standard Oracle reports to help reconcile receiving inspection account and review whether there are any …
-
Supplier Qualification - Qualifications and Assessments Real TimeSummary: We are trying to create a report using "OTBI - Supplier Qualification - Qualifications and Assessments Real Time Subject Area" please find the report criteria a…
-
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 …