Discussion List

• Which is better (insert select) or (loop insert)

  Answered ✓ 42 views 4 comments 0 points Most recent by Jonathan Lewis Dec 3, 2022 6:49PMSQL Performance (MOSC)
• NOT EXISTS SQL query help

  Answered ✓ 11 views 5 comments 0 points Most recent by Suresh Sangaran-Oracle Nov 29, 2022 4:58AMSQL Developer (MOSC)
• How to extract Peoplecode as text from peopletools table PSPCMPROG?

  Answered 662 views 3 comments 0 points Most recent by Velu Angusamy Nov 28, 2022 3:39PMPeopleTools and Lifecycle Management - PSFT (MOSC)
• SQL query

  Answered 51 views 3 comments 0 points Most recent by Monika G-Oracle Nov 20, 2022 3:53AMFixed Assets - EBS (MOSC)
• SQL query

  Answered ✓ 41 views 7 comments 0 points Most recent by L. Fernigrini Nov 17, 2022 8:14PMPL/SQL (MOSC)
• SQL Query for Fixed Asset

  Answered ✓ 1.5K views 10 comments 0 points Most recent by Monika G-Oracle Nov 17, 2022 1:57PMFixed Assets - EBS (MOSC)
• Two update statements waiting for gc cr create event

  Answered 22 views 7 comments 0 points Most recent by SureshMuddaveerappa Oct 24, 2022 8:04PMSQL Performance (MOSC)
• Oracle SQL F00165 coming with "0" at each character

  Answered 11 views 1 comment 0 points Most recent by CezarB-Oracle Oct 4, 2022 4:09PMCNC, DB and Operating System - JDE1 (MOSC)
• Fetch data from Payroll Assignment Processes

  Answered 21 views 1 comment 0 points Most recent by DGray Sep 8, 2022 5:58PMPayroll and OTL - EBS (MOSC)
• Generate AWR Reports and save them on a database table as HTML

  Answered 21 views 1 comment 0 points Most recent by Mark D Powell Aug 29, 2022 5:21PMPL/SQL (MOSC)
• How can I get External reports Data Model in a table

  Answered 1 view 1 comment 0 points Most recent by Jeff Singer-Oracle Aug 25, 2022 5:58PMUnifier (MOSC)
• Downloading a blob from the database

  Answered ✓ 11 views 1 comment 0 points Most recent by BarryB Aug 9, 2022 9:12AMSQL*Plus (MOSC)
• DB2 SQL to Oracle SQL change

  Answered 11 views 3 comments 0 points Most recent by Mark D Powell Aug 2, 2022 4:14PMSQL Language (MOSC)
• No Admin User in Database?

  Question 1 view 2 comments 0 points Most recent by User_36W75 Jul 27, 2022 3:27AMPrimavera (MOSC)
• Check null for a column in all records in SQL

  Answered 1 view 9 comments 0 points Most recent by Rajesh_ABB Jun 29, 2022 4:52AMDatabase Administration (MOSC)
• query with wrong calculation

  Answered 11 views 10 comments 0 points Most recent by Mark D Powell Jun 21, 2022 7:36PMSQL Language (MOSC)
• How to connect WORK ORDER tables to PURCHASE ORDER tables

  2.1K views 10 comments 0 points Most recent by Unknown Jun 15, 2022 8:50AMEnterprise Asset Management - EBS (MOSC)
• ORA-01422: exact fetch returns more than requested number of rows ; after creating a logon trigger

  Answered 11 views 5 comments 0 points Most recent by Mark D Powell Jun 10, 2022 7:57PMPL/SQL (MOSC)
• PO_DISTRIBUTIONS_ALL.EXPENDITURE_ITEM_DATE date was 12/31/2021. user update it as 2031 was a typo.

  Answered 1 view 4 comments 0 points Most recent by J Reinhart Jun 9, 2022 8:10PMProjects - EBS (MOSC)
• Required Script to delete iExpense report/ How to delete old expense report in R12

  Answered ✓ 1 view 3 comments 0 points Most recent by DGray May 16, 2022 3:08PMEBS Customizations (MOSC)
• Does anyone have Data fix for this Doc ID 1913609.1 currently status as "Ready to Payment" of report

  Answered ✓ 1 view 5 comments 0 points Most recent by DGray May 12, 2022 2:47PMEBS Customizations (MOSC)
• Blank Purchase Agreements

  Answered 1 view 1 comment 0 points Most recent by Paartha-Oracle Apr 6, 2022 8:55AMProcurement - EBS (MOSC)
• Trial Balance BIP Report is timeout due to huge data

  Answered 43 views 1 comment 0 points Most recent by Arsalan Dehghanisariyarghan Apr 6, 2022 6:35AMSQL Performance (MOSC)
• oracle 11 optimizer problem : use of analytic functions prevent usage of index

  Answered ✓ 12 views 10 comments 0 points Most recent by paolocastle Apr 2, 2022 2:53PMSQL Performance (MOSC)
• How to query item cost as screen shown?

  Answered 11 views 3 comments 0 points Most recent by Kevin M-Oracle Mar 30, 2022 5:05PMBI Publisher (MOSC)
• issue with multiorg after upgrade

  Answered ✓ 1 view 1 comment 0 points Most recent by DGray Mar 25, 2022 3:55PMEBS Customizations (MOSC)
• Why does the SQLID of a query change on each execution?

  Answered 1 view 5 comments 0 points Most recent by Mark D Powell Mar 11, 2022 6:33PMSQL Language (MOSC)