Discussion List

• 300k updates in script running slow in sql*plus

  Answered 11 views 4 comments 0 points Most recent by Flabbergasted George Jun 8, 2021 1:40PMSQL Performance (MOSC)
• SP2-1504 error using sqlHC

  1 view 0 comments 0 points Most recent by Flabbergasted George Jun 7, 2021 8:49PMSQL Performance (MOSC)
• Converting from base64 to Raw

  72 views 6 comments 0 points Most recent by Mark D Powell Jun 7, 2021 3:20PMPL/SQL (MOSC)
• need to run 300k updates in large sql script

  Question 1 view 0 comments 0 points Most recent by Flabbergasted George Jun 3, 2021 12:31AMTechnology Stack - EBS (MOSC)
• Extracting list of installed packages via SQL query

  Answered 21 views 2 comments 0 points Most recent by SureshMuddaveerappa May 26, 2021 7:10PMDatabase Administration (MOSC)
• I need to SUM unique values from a table (get the distributed part payment to the invoice per PO)

  Question 1 view 0 comments 0 points Most recent by User_5111K May 14, 2021 6:43PMSQL Language (MOSC)
• Get PTD (Period To Date) and YTD (Year to Date) Values.

  Answered 91 views 1 comment 0 points Most recent by J Reinhart May 13, 2021 10:44AMGeneral Ledger - EBS (MOSC)
• Data view runs but UDR gives Results cannot be retrieved

  2 views 5 comments 0 points Most recent by OJEK Arbogast - Oracle May 4, 2021 10:19PMUnifier (MOSC)
• EPM 11.2.4 support Azure SQL (PaaS)

  Answered 81 views 1 comment 0 points Most recent by Tanya Heise -Oracle Apr 27, 2021 12:56PMHyperion Financial Management (HFM) (MOSC)
• PLS-00302: component 'R' must be declared

  Question 11 views 0 comments 0 points Most recent by MLA Prakash Apr 22, 2021 4:37AMProcurement - EBS (MOSC)
• How to update/insert the table if cursor returns 0 records?

  Answered 11 views 3 comments 0 points Most recent by DGray Apr 6, 2021 3:41PMPL/SQL (MOSC)
• Greater than Zero values not retruned in PLSQL function

  11 views 4 comments 0 points Most recent by MLA Prakash Apr 1, 2021 10:11AMSQL Language (MOSC)
• getting error while fetching multiple records in plsql

  21 views 4 comments 0 points Most recent by Mark D Powell Mar 29, 2021 6:47PMPL/SQL (MOSC)
• Not able to update tables using Anonymous block in PLSQL

  Answered 1 view 2 comments 0 points Most recent by AB115 Mar 19, 2021 1:31PMPL/SQL (MOSC)
• Oracle EBS users responsibility end date update

  Answered 643 views 2 comments 0 points Most recent by Mark D Powell Mar 16, 2021 5:57PMSQL Language (MOSC)
• What would be the cause sudden database get slow performance after upgrade

  Answered ✓ 121 views 6 comments 0 points Most recent by Arsalan Dehghanisariyarghan Mar 9, 2021 8:30AMDatabase Install/Upgrade/Opatch (MOSC)
• Substract two timestamps and get result in days, hours, minutes

  Answered ✓ 11 views 2 comments 0 points Most recent by Ed Nienkemper Mar 1, 2021 2:13PMSQL Language (MOSC)
• Transpose Options in SQL

  Answered 1 view 1 comment 0 points Most recent by Mark D Powell Jan 29, 2021 7:56PMSQL Language (MOSC)
• Unable to remove next line character in .lst file (data retrieved using sql query)

  Answered ✓ 11 views 5 comments 0 points Most recent by Ajay-fdle Jan 25, 2021 9:28PMSQL Language (MOSC)
• We are trying to evaluate the use of P6 licenses within our system

  Answered ✓ 1 view 2 comments 0 points Most recent by User_FAYSV Jan 20, 2021 10:22AMPrimavera (MOSC)
• Oracle Cloud BI Report - SQL Help with Item Sourcing

  Answered 1 view 7 comments 0 points Most recent by Kevin M-Oracle Jan 15, 2021 6:51PMBI Publisher (MOSC)
• Utilities for converting SQLite to SQL Server

  Answered ✓ 1 view 2 comments 0 points Most recent by David Cumming - Head of P3M, Techmodal Dec 2, 2020 9:22AMPrimavera (MOSC)
• SQL statement of a left fuzzy query

  Answered 11 views 4 comments 0 points Most recent by Mark D Powell Nov 20, 2020 8:01PMSQL Language (MOSC)
• JDE 9.2 on SQL 2019

  Answered ✓ 1 view 2 comments 0 points Most recent by Anish-Oracle Nov 18, 2020 3:44AMCNC, DB and Operating System - JDE1 (MOSC)
• Physical SQL not generated

  Answered 1 view 5 comments 0 points Most recent by Kevin M-Oracle Nov 13, 2020 1:56PMBI Publisher (MOSC)
• ORA-21700 on initialize object variable through SQL

  Answered 55 views 3 comments 0 points Most recent by Andrey Borodin Nov 7, 2020 12:55PMPL/SQL (MOSC)
• An Application event has been intercepted - Event Code: SQLS1-0673-B

  Question 11 views 0 comments 0 points Most recent by User_CDN9K Oct 12, 2020 12:18PMPL/SQL (MOSC)
• Update Payment Terms in Oracle EBS

  Answered ✓ 18 views 2 comments 0 points Most recent by Samson Nguyen Sep 2, 2020 5:54AMPayables and Cash Management - EBS (MOSC)
• Query to get Ar Receipt Maturity Date

  Answered 30 views 1 comment 0 points Most recent by SureshMuddaveerappa Aug 16, 2020 5:06PMReceivables - EBS (MOSC)