Discussion List

• how to query party relationships

  Answered ✓ 641 views 3 comments 0 points Most recent by Bharat -Oracle Jul 10, 2023 12:25PMReceivables - EBS (MOSC)
• QAS_EXECUTEQRY_REST_GET 3rd party encoding commas causing errors

  Answered 11 views 4 comments 0 points Most recent by BelP Apr 20, 2023 7:55AMPeopleTools and Lifecycle Management - PSFT (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)
• MGMT$METRIC_DAILY having trouble adding current database size in my weekly growth query

  Question 21 views 0 comments 0 points Most recent by Peyton Gregg Jan 17, 2023 1:15PMEnterprise Manager Generic (MOSC)
• MGMT$METRIC_DAILY having trouble adding current database size in my weekly growth query

  Question 51 views 1 comment 0 points Most recent by Ruxandra-DT-Oracle Jan 17, 2023 9:48AMEnterprise Manager Generic (MOSC)
• Query from WFTASK table using CASE, WHEN

  Answered 61 views 1 comment 0 points Most recent by SubhankarDas-Oracle Sep 6, 2022 2:14AMOracle SOA Suite (MOSC)
• RESOLVED: Data Model not accepting CASE statement

  Answered 11 views 1 comment 0 points Most recent by ScottLCIS Aug 5, 2022 8:31PMPayroll for NA / Time and Labor - PSFT (MOSC)
• How do I set a PS Query Prompt Default for Date in Relation to Current Date?

  Answered ✓ 1.2K views 5 comments 0 points Most recent by Jen Matlock Aug 3, 2022 2:44PMPeopleTools and Lifecycle Management - PSFT (MOSC)
• Why does the APPS.PO_INQ_SV.GET_ACTIVE_ENC_AMOUNT package return -1 value?

  Question 1 view 2 comments 0 points Most recent by Margi-Oracle Jul 19, 2022 2:40PMReporting - EBS (MOSC)
• Do you know in which tables and fields I can find the names of each object of these routes?

  Answered 1 view 2 comments 0 points Most recent by EMA Jul 11, 2022 9:30PMPeopleSoft on the Oracle Cloud (MOSC)
• Setting up a user to view top running SQL queries

  Answered 1 view 1 comment 0 points Most recent by Venkata Thiruveedhi-Oracle Apr 15, 2022 6:05PMEnterprise Manager Generic (MOSC)
• PS Query Drilling URL to Specific Fluid Approval Transaction?

  Answered ✓ 552 views 7 comments 0 points Most recent by Kunal K Mar 22, 2022 5:41PMPeopleTools and Lifecycle Management - PSFT (MOSC)
• Peoplesoft Query - Help pulling job data history rows for employees with current payroll status

  Answered 31 views 2 comments 0 points Most recent by User_P9WAC Mar 9, 2022 3:52PMPeopleTools and Lifecycle Management - PSFT (MOSC)
• Table data not retrieved

  Answered 388 views 11 comments 0 points Most recent by User_64WSJ Feb 22, 2022 5:20PMUsing the My Oracle Support Portal (MOSC)
• Supervisor Hierarchy Query Question

  Answered 1 view 3 comments 0 points Most recent by Julie Alonso-Oracle Feb 11, 2022 11:25PMHuman Resources and ELM - PSFT (MOSC)
• How do I pull a query that lists everyone's row level security?

  Answered ✓ 1 view 2 comments 0 points Most recent by Rachel Steckel Feb 10, 2022 10:15PMHuman Resources and ELM - PSFT (MOSC)
• Issue With Subquery Inside Target Table Expression Column

  Answered 1 view 2 comments 0 points Most recent by GregV Jan 26, 2022 9:27AMSQL Language (MOSC)
• Add full query count number to Query Pagelet?

  Answered 1 view 2 comments 0 points Most recent by Rajani Day Nov 29, 2021 5:58PMHuman Resources and ELM - PSFT (MOSC)
• How to run queries using transformation in PeopleSoft FSCM 9.2

  Answered 1 view 6 comments 0 points Most recent by JohnLReformed-Oracle Nov 23, 2021 12:01PMPeopleTools and Lifecycle Management - PSFT (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)
• Extracting report from journal table and transaction date from expense table

  1 view 3 comments 0 points Most recent by User_B6035 Oct 6, 2021 4:02AMFinancial Management - PSFT (MOSC)
• BIP - Display Prompt Parameters on RTF Report

  Answered ✓ 71 views 1 comment 0 points Most recent by Velu Angusamy Sep 29, 2021 7:30PMPeopleTools and Lifecycle Management - PSFT (MOSC)
• Composite Query - How to Select Multiple Entries for Prompt

  11 views 2 comments 0 points Most recent by Mary-Ann Sep 21, 2021 11:37AMPeopleTools and Lifecycle Management - PSFT (MOSC)
• About key flexfield of type select, where,...

  Answered 1 view 7 comments 0 points Most recent by Kevin M-Oracle Sep 16, 2021 3:44PMBI Publisher (MOSC)
• Is there a SQL command that will exclude weekends when counting the number of days between 2 dates?

  Answered 31 views 2 comments 0 points Most recent by JohnLReformed-Oracle Apr 30, 2021 9:09AMPeopleTools and Lifecycle Management - PSFT (MOSC)
• Exporting a query with Excel formmating applied

  Answered 1 view 1 comment 0 points Most recent by Velu Angusamy Apr 22, 2021 7:55PMPeopleTools and Lifecycle Management - PSFT (MOSC)
• What would be the cause sudden database get slow performance after upgrade

  Answered ✓ 121 views 6 comments 0 points Most recent by Arsalan Dehghanisariyarghan Mar 9, 2021 8:30AMDatabase Install/Upgrade/Opatch (MOSC)