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
-
Some users can not export pdf report when click view pdf button on PO or agreement screen.Summary: We are currently facing an issue in the production environment related to the "View PDF" functionality on the Purchase Order and Agreement screens. When certain… -
What tables/views are related to REST API /itemUnitOfMeasureConversionsSummary: I need to confirm the data is being retrieved without exception, so I would like to create a report of the same data that the API should be fetching. Content (p…
-
What is the OTBI item for "Organization" (under PO schedules)?We are trying to create a report that pulls the Ship-to location, PO number, and receiving organization (see above) to see where we have mismatching values (Ex: NATHW sh…
-
Cycle count adjustmentI have to make an cycle count history report BU wise – for this I am using INV_CYCLE_COUNT_ENTRIES table, in the frontend when i am checking the data for Transaction Typ…
-
Presentation variable based on another presentation variableSummary: I would like to print the Negotiation Title of the selected Negotiation Number in the Header. I have the Negotiation number in a presentation variable (pb_negot… -
What is template name of email body and subject of awarded negotiation that send to supplier?Actually our client want to customized the email body and subject name for Negotiation Invitation and Negotiation Awarded email that send to Supllier. We are to able fin…
-
Seeking guidance on LISTAGG() functionSummary: Hello, could someone please guide on why listagg() is not working in the following query: Content (please ensure you mask any confidential information): Hello, …
-
Bursting Query errors outSummary: Report generated output in XML, but the bursting query errors out Content (please ensure you mask any confidential information): Waiting Time: 0.5 seconds Data …
-
Error: SQL query time exceeds the limit(500 sec). Stopped processingSummary Error: SQL query time exceeds the limit(500 sec). Stopped processingContent Hi All, Error: SQL query time exceeds the limit(500 sec). Stopped processing. I am un…
-
How to insert Linefeed or carriage return between two Attributes?Summary: I would like to concatenate 2 attributes and have the second attribute print on the next line. This formula doesn't achieve that: "- Negotiation Header Detail".…
-
Update ATTRIBUTE column value(to ASN#) in WSH_DELIVERY_DETAILS table after Ship confirmSummary: Can we update ATTRIBUTE column value(to ASN#) in WSH_DELIVERY_DETAILS table in Fusion after Ship Confirm business event? Content (please ensure you mask any con…
-
How Can I Show BOM Level Information for Each Item in a Report?I’m encountering an issue and would appreciate some guidance. I need to display the BOM in the report with the level information, and I’ve attached a picture for referen…
-
in subject area "Inventory Transfer Order Real Time" Actual Ship Date is not accurateSummary: in subject area "Inventory Transfer Order Real Time" under shipment details group we added in the report Actual Ship Date and confirmed date but we found it is … -
Can we configure footer text message in oracle email notification (e.g. to suppliers)Summary: Is there any way to configure the footer on Oracle email notifications or needs Report customisation (esp notification sent outside like to suppliers) Content (…
-
Tables for Audit Report Page Details that are under Tools Tab in UI PageSummary: We need to build a BI report that extracts the Audit Report Details under Tools tab as Shown in below image. Could anyone please suggest the tables that have th…
-
OTBI report to pull purchase order issued from each punchout and catalogSummary: OTBI report to pull purchase order issued from each punchout and catalog Content (please ensure you mask any confidential information): Hi Team, We have require…
-
Table for Source Reference field on Completed Transaction page - SCM CloudSummary: Hello, We are building a custom BI report on review completed transaction page and looking for a table and column name for SOURCE REFERENCE field. Content (plea…
-
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 …
-
Merge PO header attachment pdf and BIP report in Oracle Fusion.Hi Team, I have a requirement to merge multiple PDFs into a single PDF. Specifically, when clicking the View PDF button on the PO page, a BIP report is generated. Simult…
-
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…
-
Need a query to get latest activation Date for Supplier Site so we need to restrict a custom reportHi Team, We built a custom report for Supplier and supplier site info and we got a requirement that we need to restrict the supplier sites which got recently activated i…
-
Column label not showing in ArabicSummary: Column label not showing in Arabic Content (please ensure you mask any confidential information): Hi All, We got a requirement to change the company name in iSu…
-
issue query filter BICCSummary: We're trying to filter specifc data from VO at BICC , but log returns query error at where clause. Content (please ensure you mask any confidential information)…
-
Performance Issue After Joining EGO_ITEM_EFF_B on the basis of CHANGE_LINE_ID. Any solutions?Hi, I’m working on a query that previously ran within seconds, but after adding the lastLEFT JOIN, the execution time has increased significantly—even for a single chang… -
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 …
-
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 …
-
How to enable send icon in ESS job outputSummary: I have a question of how to enable the send icon in the ESS job output. Content (please ensure you mask any confidential information): Version (include the vers…
-
How to migrate OBIEE12c Agents as-is from old environmentSummary: We need to move over 1000+ automated agents from our test system (DEV) to our live system (PROD) in OBIEE 12c on Linux. Normally, when we move these agents, the…
-
Subject Area to get details related to Maintenance Work definitionSummary: We try to create an analysis in Maintenance module to capture the Maintenance program with Work definition and operations and materials required for the Work or…
-
Approvers not able to see customized data in approval notificationSummary: Approvers not able to see customized data in approval notification. Content (please ensure you mask any confidential information): We have added few DFF from po…