Category 174-2
Discussion List
-
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… -
Field in OTBI subject area to differentiate Purchase Order schedules which are FirmedWe are creating an Analysis and need an Identifier in Purchase Order Schedule to get the schedules which are Firmed ( Purchase Order schedule → Details → Actions → Firm)…Jith 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Capacity / Resources Requirement calculation for Phantom subassembliesSummary: Hello All, How is Capacity / Resources Requirement calculated for Phantom subassemblies in constraint supply chain planning? supply planning doesn't calculate p…SharathBiz 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
User Should access all Inv Org for the OTBI reports If user is having access for 1 Inventory OrgSummary: Hello We have created an on-hand report for the business, but we need that few user with access with only 1 or few inventory org should also be able to view the…Parth11 11 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Requisition Report errors when filtering to one BUWe have a Requisition Approved Status report that runs a report for approved Reqs for our 3 Business Units, Report runs fine when ALL BUs are selected or even 2 BUs. But…Damien Curtis 11 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Backend tables for Receipt Accounting DistributionsSummary: I need backend tables for the screen Receipt Accounting Distributions (Supply Chain Execution>Receipt Accounting> Receipt Accounting Distributions). I found tha…Akankshya Jena 52 views 6 comments 0 points Most recent by Akankshya Jena Reporting and Analytics for SCM
-
Requisition Unprocessed daysSummary: Difference between OTBI Requisition- Unprocessed days in Line detail and Unprocessed days in the Line folder Content (please ensure you mask any confidential in…Rajesh7d 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
I need sql query for Consumed Allocation in GOP Review Supply AllocationSummary: I need sql query for Consumed Allocation in GOP Review Supply Allocation to create a BIP report Content (required): Business requirement to prepare a report tha…
-
Usage of Prompt's "contains any" for both upper case and lower caseSummary: Usage of Prompt's "contains any" for both upper case and lower case Content (please ensure you mask any confidential information): Hi Experts, I am using subjec…
-
Is it possible to create or move the DFF fields under Product & Servies Tab in Supplier PageSummary: Business requirement is to create or move the existing Dff fields under Product & Servies Tab in Supplier Page. Please find the below screenshot for more detail…Chandana Priya-Oracle 11 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Prompt LOV restriction in OTBI according to user Business unit data accessSummary: We are trying to restrict the prompt LOV which returns BU names that currency configured in the system. But we want that when a particular user will try to run …Baishakhi 11 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Work Definition Comparison reportSummary: Is there any existing report available to get below details? Work Definition Comparison report if not, what table I need to refer for this comparison? Content (…Jignesh_HAE 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Query to get PO Change History details which have Been Purged.Summary: There is a requirement by the business to fetch the details of the archived history for POs Content (please ensure you mask any confidential information): To re…
-
Terms & Conditions in PO PDFSummary: Hi Fellow Developers, The requirement is to host Terms and Conditions file in Oracle cloud and it should be printed as hyper link in PO PDF. when ever a Supplie…Dhilip Kumar P. 11 views 1 comment 0 points Most recent by Sai Karthik Reporting and Analytics for SCM
-
Tables/View for Item and Asset Category to PO categoriesSummary: Tables/View for Item and Asset Category to PO categories Content (please ensure you mask any confidential information): Hi Experts, Would like to reach out to y…
-
sending email for bursting not workingHi . I create the Bursting process for an user. In the first step i created the query bursting in the data model : In particulary the parameters for my the Bursting quer…Michela A. Morgillo 71 views 5 comments 0 points Most recent by Michela A. Morgillo Reporting and Analytics for SCM -
Supplier Address Level Tax Classification CodeSummary: We are trying to determine the Tax classification code field at Supplier Address level in OTBI analysis Content (please ensure you mask any confidential informa…Jithendra_MG 11 views 2 comments 0 points Most recent by Jithendra_MG Reporting and Analytics for SCM -
how to get data for destination location in Transfer order?I need destination location for transfer order. how to get that? which table i used to join with to get location name?
-
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…
-
No data displayed in Goods Received not Invoiced ReportSummary: Hi, I am using seeded OTBI Report 'Goods Received not Invoiced Report' and made a custom report with the same subject area i.e. Costing- Receipt Accounting Real…Vijayalakshmi Matcha - Oracle-Oracle 494 views 3 comments 0 points Most recent by Duygu Coskun 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. 33 views 5 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
Can you please help me to find parent reports for the below OTBI child reports?Can you please help me to find parent reports for the below OTBI child reports? Past Due Fulfillment Lines Report Sales Order E-mail Sales Order Line Status Update Sales…User_SIV20 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
How to get original or first requisition approved dateHi! I need to get the first or original requisition approval date for a report. How do I get it? The field Requisition Approval Date shows the latest/recent approval dat…Jose Renato Salvador 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
ODI Marketplace integration with SharepointSummary: Team, do we have any possibility of connecting ODI with SharePoint for data exchange. Has anyone on the team encountered this need before? can you please share …Viswanath-Oracle 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Serials in Transaction History for PO Receipt Number – SQL Query Adjustment NeededSummary: Hi Oracle Support, I am using the query below to retrieve serial numbers for receipt 30148, but it does not show all four serials as seen in the Transaction His…
-
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 41 views 7 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
How to remove the restriction preventing a user from accessing data within an OTBI report.Summary: I have a dashboard containing multiple reports. While the user can access some of these reports, others display errors such as "view error" or "error getting dr…Omran Zeaiter 51 views 4 comments 0 points Most recent by RyanPasca1 Reporting and Analytics for SCM
-
qrcode with blank data printed while report is in bursting workes well without burstingSummary: scheduled report and qr code in it works well when the output is not bursted but when we burst the output qrcode with blank data printed whole report output and…Raoof Ahmed 11 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
ESS Job to default the output to Email address when submitting the job on demandSummary: Hello ! We have a BI report as an ESS Job, the requirement is to default the email address and the subject and the BI report output (XLS) in this case needs to …vivek.clement 21 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
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 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP