Discussion List

• Left outer join not working

  Answered 11 views 4 comments 0 points Most recent by GregV Oct 6, 2023 6:09AMSQL Language (MOSC)
• Map a CSV string with ID in an association table (many to many)

  Answered 11 views 3 comments 0 points Most recent by GregV Sep 22, 2023 6:12AMSQL Language (MOSC)
• SQL server support in 11.2.15

  Answered 51 views 4 comments 0 points Most recent by Michael Irving Sep 15, 2023 8:30AMHyperion EPM General (MOSC)
• Inserting duplicate rows with negative amount from a previous record in Oracle PLSQL

  Answered 11 views 3 comments 0 points Most recent by L. Fernigrini Sep 13, 2023 7:51PMPL/SQL (MOSC)
• Oracle execution plan in order

  Answered 61 views 2 comments 0 points Most recent by Justin Bleistein Sep 6, 2023 12:52PMDatabase Tuning (MOSC)
• Strange Behavior in PROD vs QA & DEV

  Answered 11 views 1 comment 0 points Most recent by ~ET Sep 5, 2023 10:24AMInstall, Upgrade, Clone, Patch - EBS (MOSC)
• Finding objects referenced in SQL query

  Answered 41 views 4 comments 0 points Most recent by Justin Bleistein Aug 17, 2023 12:21PMDatabase Tuning (MOSC)
• Extract from XML string

  Answered ✓ 31 views 5 comments 0 points Most recent by deahayes Aug 11, 2023 2:21PMPL/SQL (MOSC)
• Enforcing a specific hash on a specific sql id

  Answered 21 views 2 comments 0 points Most recent by Balamurugan Sivalingam Aug 4, 2023 6:23AMDatabase Tuning (MOSC)
• Application engine sql and ORA-01858

  Answered ✓ 31 views 4 comments 0 points Most recent by user10479185 Jun 22, 2023 7:39PMPeopleTools and Lifecycle Management - PSFT (MOSC)
• I am looking for logic/possibility of finding received quantity at wsh_delivery_details level.

  Answered 1 view 1 comment 0 points Most recent by Vyshali A-Oracle Jun 22, 2023 5:54AMOrder Management - EBS (MOSC)
• Create ERD from SELECT statement

  Answered ✓ 11 views 4 comments 0 points Most recent by Jan Williams Jun 20, 2023 7:36AMSQL Developer Data Modeler (MOSC)
• Need SQL query to display Position start date and end date

  Answered ✓ 42 views 10 comments 0 points Most recent by Visu Jun 4, 2023 7:13AMSQL*Plus (MOSC)
• When you "view SQL" within query manager, and the SQL does NOT match the actual query.

  Answered 41 views 4 comments 0 points Most recent by Neelam S-Oracle May 4, 2023 2:38PMPeopleTools and Lifecycle Management - PSFT (MOSC)
• Calculating percentage over base value in time series data

  Answered ✓ 21 views 4 comments 0 points Most recent by Arsalan Dehghanisariyarghan Apr 27, 2023 4:55PMSQL Language (MOSC)
• Is there a script or tool to monitor database uptime/down time for reporting database availability ?

  Answered 93 views 3 comments 0 points Most recent by Mark D Powell Apr 20, 2023 2:20PMSQL Performance (MOSC)
• want to ‘drop database’ and recreate it without reloading oracle and or software(copyrighted)

  Answered 31 views 4 comments 0 points Most recent by SureshMuddaveerappa Mar 17, 2023 6:51PMPatch Reviews - DB (MOSC)
• PODATA field doesn't exacly match with processing options

  Answered 31 views 2 comments 0 points Most recent by User_CH5HH Feb 22, 2023 8:39AMDistribution - JDE1 (MOSC)
• What's the best way to query the catalog to check varchar2 columns

  Answered ✓ 11 views 2 comments 0 points Most recent by Mark D Powell Feb 7, 2023 2:26PMDatabase Administration (MOSC)
• Microsoft SQL Server 2016 (SP2+) support with HFM 11.2.xxx

  Answered 1 view 1 comment 0 points Most recent by Vasantha Kumar Feb 6, 2023 2:40PMHyperion Financial Close Management (FCM) (MOSC)
• how to combine sequential rows based on previous or next row

  Answered 41 views 4 comments 0 points Most recent by User_2BO16 Feb 3, 2023 11:14PMSQL Language (MOSC)
• What am I missing? Get unexpected result of a query

  Answered ✓ 21 views 3 comments 0 points Most recent by Joerg.Sobottka Jan 24, 2023 4:37PMSQL Language (MOSC)
• Question about NVL function

  Answered 11 views 3 comments 0 points Most recent by Mark D Powell Jan 24, 2023 4:20PMSQL Language (MOSC)
• How to print Long Name or Short Name for a Translate Value

  Answered 11 views 1 comment 0 points Most recent by Janel L Jan 23, 2023 7:08PMFinancial Management - PSFT (MOSC)
• Select is getting executed on remote or local via DBLink

  Answered ✓ 11 views 4 comments 0 points Most recent by Asanka Jan 20, 2023 11:06AMDatabase Administration (MOSC)
• Insert a JPG photo from Unifier in a rtf (Custom Print)

  Answered 1 view 1 comment 0 points Most recent by Kevin M-Oracle Jan 9, 2023 2:17PMBI Publisher (MOSC)
• between is not work for a character field having period name

  Answered ✓ 22 views 1 comment 0 points Most recent by Suresh Sangaran-Oracle Dec 31, 2022 2:37AMSQL Developer (MOSC)
• ORA-00980: SYNONYM TRANSLATION IS NO LONGER VALID

  Answered 31 views 3 comments 0 points Most recent by Mark D Powell Dec 15, 2022 2:53PMPL/SQL (MOSC)
• [P6][V17?12][SQL] How many stored procedures

  Answered 1 view 1 comment 0 points Most recent by Jim Mcc-Oracle Dec 6, 2022 4:09PMPrimavera (MOSC)