Category 174-2
Discussion List
-
Combine columns of PO catalog, category, Accounting Code into 1 reportSummary: Combine columns of PO catalog, category, Accounting Code into 1 report Content (please ensure you mask any confidential information): Hi Experts, Would like to … -
Procurement CategorySummary: How to bring the browsing categories into OTBI analysis reports? Content (please ensure you mask any confidential information): Hi Experts, Would like to know h…
-
Is there any possibility to have a delay or wait time in between the "Print Pick Slip Report" jobsSummary: Is there any possibility to have a delay or wait time in between the "Print Pick Slip Report" jobs Content (please ensure you mask any confidential information)…
-
can you join "Fulfillment Lines Real Time" with "Receivables - Customer Real Time"Need to join those 2 subject areas to bring the "collector" from the account to the orders data. Both areas have the account number, but cant seem to find a way to join …
-
Email Both PDF and XML Format with Bursting QueryI have a custom packing slip report that is triggered off a customized scheduled process and the bursting query in the data model of my report handles the email output. …KTbsa1234567 52 views 2 comments 0 points Most recent by KTbsa1234567 Reporting and Analytics for ERP
-
Is there any subject area with the Planned Delivery Date on the shipment?Summary: We have to create a report on the shipments and need the Planned Delivery Date that appears in the shipment. We cant seem to find it. Content (required): Versio…IIGC 31 views 4 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
Extract a list of custom reports in HCM from OTBI and BI PublisherSummary: Is it possible to extract a list of custom reports created in OTBI and BI Publisher, including: The subject areas and folders used, and the fields in them and o…Paul Morrissey 11 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
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. 22 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
How to enable shipment line DFF in Seeded shipping subject areaSummary: DFF have been configured in Shipment Lines Level. Requirement is to be able to fetch the DFF in seeded Shipping subject area for configuring an OTBI report. Not…Narendra Avula 11 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
how to improve the OTBI analysis export record limit?Summary: Hi Guru, we created an OTBI analysis using the standard data model, but looks like it can only support to export 250k records, is there any way to improve that …JasonZzl 31 views 4 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
Move Dashboard Page to a subpageSummary: Hi, I have created a dashboard with multiple Subpages under one Dashboard page. When i rename the Subpage names (In Dashboard Properties), somehow its convertin…Sudheer YN 45 views 8 comments 0 points Most recent by Dianne Barnhouse Reporting and Analytics for SCM
-
ORA-00932: inconsistent datatypes: expected DATE got NUMBER in SQL data model per KM 2888420.1Summary: When trying to use the SQL provided in KM Fusion CST: SQL Running Behind Analyze Standard Purchase Cost Variances (Doc ID 2888420.1) i am getting an error in th…Maria Angelica Mendoza 21 views 1 comment 0 points Most recent by Manikandan S R-Support Oracle-Oracle Costing -
Inquiry Regarding Dynamic User Inclusion in Report Emails via BurstingSummary: Hi Oracle Experts, We have received a request from our users to include the username of the individual executing a report in the email body after the "Thanks" s…Sai Sreeram Gundepudi 21 views 0 comments 0 points Started by Sai Sreeram Gundepudi Reporting and Analytics for ERP -
The specified criteria didn't result in any data for Inventory transaction real timeSummary: receiving result "The specified criteria didn't result in any data" User has a custom role that has been assigned "Inventory Transaction Analysis Duty" and has …Joe B 21 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle 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…
-
Need query to calculate average cost of item.Summary: Need query to calculate average cost of item. Cannot use the item PAC from the PAC item cost table instead wanted to use the inbound transaction for calculating…Mukesh_Kr 1 view 1 comment 0 points Most recent by Mirza Muhammad Mohsin Baig Reporting and Analytics for SCM
-
Standard Cost Details Report (seeded) UI output shows Unit Cost as Zero (rounded down)Summary:Standard Cost Details Report (seeded) UI output shows Unit Cost as Zero but Excel export shows correct value. Analytics > Run Standard Cost Details seeded report…Maria Angelica Mendoza 21 views 1 comment 0 points Most recent by Manikandan S R-Support Oracle-Oracle Reporting and Analytics for SCM
-
Need a query to get details in manage project costs -> view accounting detailsSummary: I need to add the GL Account column from manage project costs -> view accounting details UI. This data can be found by going into the transaction and going to A…
-
Query to get Inventory valuation quantitiesSummary: I am looking for the query to get the inventory valuation quantities based on inventory organization. When we view the data for a period for a cost organization…
-
Where is the Organization Name on the SCM BICC Extracts?Summary: In the BICC Extracts for Sales Orders Transfer Orders Purchase Orders Shipments On Hand Installed Base We need to Find the Organisation Name but can only find a…Martin Hutchison 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Does anyone know how to find Journal Entries Details in Cost Transactions?Hi Everyone, Does anyone know a query to get Journal Entries Details in Cost Transactions?S.heha.n 11 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Upload excel for search criteria to find on hand dataSummary: One of my customer has huge number of SKUs (6 million SKUs). The user would like to query the on-hand quantity for SKU's by uploading an excel. The excel file h…Vishnuvarth Subramanian-Oracle 11 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Need a query to fetch planned order and demand due datesSummary: Hello, We need a query to fetch planned order due dates and corresponding pegged sales order/forecast need by dates for a certain category of items. We would li…SharathBiz 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Item attribute values by revisionsHello, we are trying to extract an attribute value from ego_item_eff_b in all revisions of a specific item. This means that we want to extract data with the following st…
-
Deploying the undeployed KFF's resolved the DFF's not appearing in OTBIWe have created a new DFF for POZ_SUPPLIERS. Deployed the DFF and ran the ESS Job : Import Oracle Fusion Data Extensions for Transactional Business Intelligence. The DFF…Yasasree Boosireddy-Oracle 52 views 9 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
Locator Name in Receiving - Purchase Receipts Real Time Subject AreaSummary: We have an OTBI report built using the subject area "Receiving - Purchase Receipts Real Time" and we have almost all the required columns except for the Locator…Rahul_M8SG8 21 views 4 comments 0 points Most recent by Regie Mercado Reporting and Analytics for SCM
-
What all standard reports are available in oracle fusion for Procurement and Supply Chain ManagementSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
How to restrict IBLPN TI-HI receiving at certain Volume/weight/QTY.Summary: We are looking for restriction in receiving, on IBLPN at Volume/weight or QTY basis. Content :- Hi, We are looking for restriction in receiving process, on IBLP…
-
need a query to get the unit price of subscription invoiceSummary: we need a query to get the unit price of subscription invoice. Content (please ensure you mask any confidential information): Version (include the version you a…Sai Divya Kolachana 11 views 1 comment 0 points Most recent by Ed Gomez-Support-Oracle Subscription Management
-
Supplier Owned Consigned Items valuationSummary: Does Period Inventory Valluation Report consider the inventory value for consigned items those are owned by supplier? Content (please ensure you mask any confid…Anurag Kumar Pandey 31 views 2 comments 0 points Most recent by Anurag Kumar Pandey Reporting and Analytics for SCM