Discussion List

• Can you please help me get the below columns from oracle r12 tables for payables invoices

  Answered 11 views 3 comments 0 points Most recent by Gerrit van der Linden Sep 13, 2025 1:09PMSQL Language (MOSC)
• ORA-01843 "Not a Valid Month" Creating a table in Oracle 19

  Answered ✓ 22 views 2 comments 0 points Most recent by cougarred Sep 7, 2025 12:38AMDatabase Administration (MOSC)
• From which SQL Server table can I extract a list of FDMEE users, the create/modified date, and roles

  Answered 22 views 1 comment 0 points Most recent by NathanD-Oracle Aug 28, 2025 9:34PMHyperion Financial Data Quality Management (FDM/FDMEE) (MOSC)
• SQL Query to extract Tax Information for AR Invoices

  Answered ✓ 888 views 3 comments 0 points Most recent by User_4NMWW Jul 25, 2025 9:44AMReceivables - EBS (MOSC)
• Need help with a query to determine who accessed a Project Record in Unifier

  Answered 21 views 2 comments 0 points Most recent by Gordo Cashmo Jun 5, 2025 1:49PMUnifier (MOSC)
• How to find duplicate customer where no unique column exists ?

  Answered 31 views 3 comments 0 points Most recent by Mr. C Apr 17, 2025 12:10PMSQL Language (MOSC)
• Bad Performance, How to tune query for Journal Entries with drillDown ?

  Answered 41 views 3 comments 0 points Most recent by Chandra Sekhar Kadali-Oracle Apr 2, 2025 4:45AMGeneral Ledger - EBS (MOSC)
• Language differences between 11gr2 and 19c Oracle Database versions

  Answered ✓ 484 views 4 comments 1 point Most recent by Mr. C Mar 3, 2025 3:06PMSQL Language (MOSC)
• PeopleSoft PeopleTools 8.61 Issues using SQL Server 2022

  182 views 2 comments 0 points Most recent by Robert Ponder Feb 28, 2025 12:56PMSQL Performance (MOSC)
• Emojis

  Answered ✓ 41 views 3 comments 0 points Most recent by User_EEPEZ Feb 26, 2025 9:00PMSQL Language (MOSC)
• how concat :APP_USER in single quote?

  Answered 11 views 3 comments 0 points Most recent by Kannan-P-Oracle Feb 26, 2025 11:15AMOracle Application Express (MOSC)
• SQL_profile and Tunning Advisor

  Answered 11 views 1 comment 0 points Most recent by Arsalan Dehghanisariyarghan Feb 26, 2025 10:53AMSQL Language (MOSC)
• An invalid bind variable number was specified in SQL UPDATE statement in AE

  Answered ✓ 51 views 5 comments 0 points Most recent by Pavani N -Oracle Feb 6, 2025 8:35AMPeopleTools and Lifecycle Management - PSFT (MOSC)
• Joining hr_locations with HR_ORGANIZATION_UNITS

  Answered ✓ 31 views 3 comments 0 points Most recent by Sirisha Padmala-Oracle Dec 18, 2024 3:31PMProcurement - EBS (MOSC)
• WARNING: too many parse errors, count=2049 SQL hash=0x105683e1

  Answered 793 views 14 comments 0 points Most recent by User_0F4SP Nov 21, 2024 12:23PMDatabase Administration (MOSC)
• Query to extract Applied Receipts and Invoices

  Answered ✓ 43 views 3 comments 0 points Most recent by Nandac-Oracle Nov 14, 2024 5:41AMReceivables - EBS (MOSC)
• Order by dynamically based on user input in SQL Query

  Answered ✓ 31 views 6 comments 0 points Most recent by BrunoVroman Nov 3, 2024 3:12PMSQL Language (MOSC)
• How to find SQL query of Shipping Location LOV in Order Line page of Buyer Work Center in R12

  Answered 214 views 3 comments 0 points Most recent by Nirmal Natarajan-Oracle Oct 22, 2024 3:21PMProcurement - EBS (MOSC)
• Unable to join create custom sql label field as we are unable to join wms_label_requests_hist

  Answered 81 views 6 comments 0 points Most recent by Siva Botta-Oracle Oct 21, 2024 7:03AMInventory Management - EBS (MOSC)
• Performance tuning a query

  Answered 11 views 3 comments 0 points Most recent by Sadeesh - Oracle-Oracle Oct 13, 2024 1:18AMPayables and Cash Management - EBS (MOSC)
• Requirement to calculate working days and consider calendar exceptions

  Answered 31 views 2 comments 0 points Most recent by BrunoVroman Oct 4, 2024 7:13AMInventory Management - EBS (MOSC)
• QUERY to display data from certain time, i.e.FROM 8:30 a.m. yesterday TO 7:45 a.m. today

  Answered ✓ 31 views 6 comments 0 points Most recent by SureshMuddaveerappa Aug 16, 2024 11:33PMDatabase Administration (MOSC)
• Query for AR invoices & Receipt

  Answered 11K views 7 comments 0 points Most recent by Sadeesh - Oracle-Oracle Aug 16, 2024 5:49AMReceivables - EBS (MOSC)
• Running a SQL Developer query to see Accounts Receivable Period Status

  Answered 21 views 2 comments 0 points Most recent by Bharat -Oracle Aug 2, 2024 9:56AMReceivables - EBS (MOSC)
• Manually execute the exact SQL from a SQL_ID

  Answered 21 views 4 comments 0 points Most recent by Jonathan Lewis Jun 13, 2024 4:59PMSQL Performance (MOSC)
• Purchasing Cloud: SQL to find Source Agreement against a Purchase Order

  Answered ✓ Closed 3.2K views 4 comments 0 points Most recent by Paartha-Oracle Jun 1, 2024 8:09AMProcurement - EBS (MOSC)
• Migrating a P6 SQL Server database

  Answered ✓ 21 views 2 comments 0 points Most recent by DavidCumming May 30, 2024 7:54PMPrimavera (MOSC)