Discussion List

• SQL Query to get Employee's Absence Accrual BASIC entitled Balance and Carryover

  Answered ✓ 7K views 8 comments 0 points Most recent by Sneha Mishra-Oracle Dec 15, 2025 4:43PMHuman Capital Management - EBS (MOSC)
• New Document Explains the Difference Between Running a Query Through Query Manager vs Query Viewer

  14 views 0 comments 0 points Started by Candiceg-Oracle Nov 13, 2025 4:46PM PeopleTools and Lifecycle Management - PSFT (MOSC)
• New Document Explains the Difference Between Running a Query Through Query Manager vs Query Viewer

  5 views 0 comments 0 points Started by Candiceg-Oracle Nov 13, 2025 4:46PM PeopleSoft Announcements
• Can Query Based Tabs be pulled into a View?

  Answered 2 views 2 comments 0 points Most recent by User_VGGYK Jun 18, 2025 8:33PMUnifier (MOSC)
• Select-FetchNext create "select *" query to get 1 variable

  Answered 22 views 2 comments 0 points Most recent by Dorothy Ahfat-Oracle Jun 11, 2025 4:35PMDesign Tools & Output Technologies - JDE1 (MOSC)
• Help with query for Getting Project and group member at diff Hierarchly levels

  Answered 12 views 2 comments 0 points Most recent by Gordo Cashmo Jun 5, 2025 2:27PMUnifier (MOSC)
• Need help with a query to determine who accessed a Project Record in Unifier

  Answered 23 views 2 comments 0 points Most recent by Gordo Cashmo Jun 5, 2025 1:49PMUnifier (MOSC)
• Data load SQL runs nightly with same sql-id but execution plan changes

  Answered 15 views 2 comments 0 points Most recent by Arsalan Dehghanisariyarghan May 29, 2025 11:54AMDatabase Administration (MOSC)
• ORA-01704 string literal too long error during execution of select query

  Answered ✓ 36 views 4 comments 0 points Most recent by Anthony Harper May 21, 2025 10:43AMPL/SQL (MOSC)
• Events and Notifications (EOEN) - Disable Delivered Notifications?

  Answered 183 views 1 comment 0 points Most recent by PencilBoy99 May 8, 2025 6:10PMPeopleTools and Lifecycle Management - PSFT (MOSC)
• Identify AR invoices with tax withholding - Oracle EBS

  Answered 16 views 5 comments 0 points Most recent by Alex Barbu-Oracle Mar 21, 2025 6:34AME-Business Tax (MOSC)
• Queries using supplemental data table

  Answered ✓ 25 views 6 comments 0 points Most recent by RAJAKUMAR MARIAPPAN-Oracle Jan 17, 2025 4:51PMSupply Chain Management - PSFT (MOSC)
• How to find SQL query of Shipping Location LOV in Order Line page of Buyer Work Center in R12

  Answered 251 views 3 comments 0 points Most recent by Nirmal Natarajan-Oracle Oct 22, 2024 3:21PMProcurement - EBS (MOSC)
• issue in Plsql block

  Answered 17 views 1 comment 0 points Most recent by Ananthavadivel-Oracle Sep 13, 2024 11:38AMOracle Application Express (MOSC)
• EM CC 13.5 corrective actions report summary select query

  Question 14 views 0 comments 0 points Most recent by User_J1U3I Jul 13, 2024 11:06AMPL/SQL (MOSC)
• What is the syntax for the ROUND function in an MDX query?

  Answered ✓ 13 views 1 comment 0 points Most recent by David Grunwald-Oracle Jul 8, 2024 5:55PMHyperion Essbase (MOSC)
• PS Query: How to use one prompt to let user to input the list of IDs

  Answered 65 views 6 comments 0 points Most recent by User_TPCFF May 15, 2024 4:36AMPeopleTools and Lifecycle Management - PSFT (MOSC)
• How can I disable Query Selection field?

  Answered 13 views 2 comments 0 points Most recent by Carles C-Qualita Feb 7, 2024 8:37AMManufacturing - JDE1 (MOSC)
• Field: EOAWSTEP_STATUS2 Translation Definition (JRNL_AF_LOG_VW)

  Answered 4 views 2 comments 0 points Most recent by ss102518 Jan 4, 2024 4:55PMGeneral Ledger - EBS (MOSC)
• Getting duplicate rows from seeded APPS tables when I access them from remote APEX schema via DBLink

  Answered 50 views 1 comment 0 points Most recent by Monika G-Oracle Nov 21, 2023 9:36AMTechnology Stack - EBS (MOSC)
• Using REGEXP in PS Query criteria

  Answered ✓ 100 views 4 comments 0 points Most recent by C Cox Nov 20, 2023 3:32PMPeopleTools and Lifecycle Management - PSFT (MOSC)
• maintenance window gathering oracle stats results in optimizer choosing bad plan

  Answered 119 views 11 comments 0 points Most recent by ShaunS Oct 4, 2023 7:33PMDatabase Tuning (MOSC)
• Sys Numeric Query Based DEs not updating when trigger DE is Reverse Auto-Populate?

  Question 12 views 1 comment 1 point Most recent by Gabe M Sep 28, 2023 5:23PMUnifier (MOSC)
• Map a CSV string with ID in an association table (many to many)

  Answered 12 views 3 comments 0 points Most recent by GregV Sep 22, 2023 6:12AMSQL Language (MOSC)