Discussion List

• Why does the SQLID of a query change on each execution?

  Answered 4 views 5 comments 0 points Most recent by Mark D Powell Mar 11, 2022 6:33PMSQL Language (MOSC)
• Multiple SQL under same app engine action

  Answered 4 views 3 comments 0 points Most recent by Velu Angusamy Mar 3, 2022 9:07PMPeopleTools and Lifecycle Management - PSFT (MOSC)
• How to get Month & Year Budget

  Question 12 views 0 comments 0 points Most recent by Element77 Feb 24, 2022 11:52AMGeneral Ledger - EBS (MOSC)
• AFTER EXEC THIS COMMAND WF_ENGINE.AbortProcess('ITEM_TYPE', 'ITEM_KEY); DATA REMAIN IN SAME TABLE ?

  Answered ✓ 59 views 3 comments 0 points Most recent by DGray Feb 14, 2022 6:40PMCore Workflow - EBS (MOSC)
• ORA-29299 - Invalid Handle

  Question 2 views 0 comments 0 points Most recent by User_L34N7 Feb 11, 2022 11:08AMPL/SQL (MOSC)
• SQL Query is throwing an error

  Answered 4 views 3 comments 0 points Most recent by User_MN9VB Feb 3, 2022 7:34AMGeneral Ledger - EBS (MOSC)
• Returning multiple values from a PL/SQL FUNCTION.

  Answered ✓ 12 views 3 comments 0 points Most recent by GregV Jan 26, 2022 8:52PMPL/SQL (MOSC)
• None-Partition Table to Partition Table conversion - Oracle 19c EE/RAC/AIX

  Answered 58 views 4 comments 0 points Most recent by Mark D Powell Jan 20, 2022 3:54PMSQL Performance (MOSC)
• global temp table can be used as Organization external TYPE oracle_loader table?

  Question 4 views 0 comments 0 points Most recent by User_M3HXT Dec 20, 2021 6:26PMEBS Customizations (MOSC)
• ways to reduce tablespace APPS_TS_MEDIA ?

  12 views 4 comments 0 points Most recent by SureshMuddaveerappa Dec 14, 2021 6:01PMDatabase Administration (MOSC)
• PS Query output column with multiple values to single column

  Answered ✓ 2.7K views 8 comments 0 points Most recent by User_309Q1 Oct 7, 2021 2:06PMPeopleTools and Lifecycle Management - PSFT (MOSC)
• Table names in Primavera P6 professional v20

  Answered 14 views 3 comments 0 points Most recent by Milan Šmigić Sep 20, 2021 9:45AMPrimavera (MOSC)
• SQL Query using Joins - RMAN Catalog reports

  Answered 12 views 2 comments 0 points Most recent by L. Fernigrini Sep 15, 2021 3:18PMDatabase Administration (MOSC)
• Failed to execute the creation of sql baseline, an error was reported

  Answered 18 views 1 comment 0 points Most recent by Mark D Powell Sep 10, 2021 11:39AMSQL Performance (MOSC)
• I keep getting SQL query execution plan contains merge cartesian joins..

  Answered 6 views 7 comments 0 points Most recent by SureshMuddaveerappa Sep 3, 2021 10:53PMPL/SQL (MOSC)
• Question in building the ptupdtabstats.sql

  Answered 3 views 3 comments 0 points Most recent by Velu Angusamy Sep 1, 2021 5:11PMPeopleTools and Lifecycle Management - PSFT (MOSC)
• How to customize OAF exception message according to the type of errors ?

  Question 939 views 0 comments 0 points Most recent by User_P835I Aug 24, 2021 11:11AMEBS Customizations (MOSC)
• OeBS AR module, question to file attached to a customer invoice

  Question 3 views 0 comments 0 points Most recent by User_3S9CJ Aug 20, 2021 1:51PMPL/SQL (MOSC)
• Visibility of Tax code imposed by tax rules

  Answered ✓ 5 views 3 comments 0 points Most recent by Monika G-Oracle Aug 12, 2021 9:17AMFixed Assets - EBS (MOSC)
• how to create ALert for SQL query

  Answered ✓ 5 views 1 comment 0 points Most recent by Venkata Thiruveedhi-Oracle Aug 9, 2021 11:02AMManaging Databases using Enterprise Manager (MOSC)
• xml template query and rdf template output want to understand

  3 views 1 comment 0 points Most recent by Kevin M-Oracle Jun 30, 2021 12:49PMBI Publisher (MOSC)
• SQL Query to get Maximum date with in each month

  Answered 44 views 6 comments 0 points Most recent by Mark D Powell Jun 25, 2021 3:11PMSQL Language (MOSC)