Discussion List

• Single-quotes not working in SQL statement run from scheduled SQL*Plus script or PL/SQL script.

  Answered 47 views 11 comments 0 points Most recent by Mark D Powell Mar 12, 2019 12:28PMDatabase Administration (MOSC)
• Unable to edit GL date for RB batch

  Answered 149 views 2 comments 0 points Most recent by User_OSTBA Mar 12, 2019 8:41AMFinancial - JDE1 (MOSC)
• Query to find various groupings of security roles

  Answered 43 views 3 comments 0 points Most recent by Unknown Mar 11, 2019 12:35PMPeopleTools and Lifecycle Management - PSFT (MOSC)
• CBS Hierarchy by Data view

  Answered ✓ 173 views 3 comments 2 points Most recent by saravanang4iapps Mar 6, 2019 1:17AMUnifier (MOSC)
• Payable Invoice Aging - Customize data model AP_APXINAGE_XMLP_PKG

  Answered ✓ 316 views 3 comments 0 points Most recent by Mohammed Sulaiman Feb 13, 2019 9:19AMBI Publisher (MOSC)
• Query or API for Serial Number Genealogy?

  Answered ✓ 763 views 1 comment 0 points Most recent by Sai Praveen-Oracle Jan 9, 2019 12:17AMInstall Base and Asset Tracking - EBS (MOSC)
• Query to search all tables in DB for a given string

  Answered 69 views 6 comments 1 point Most recent by Mark D Powell Dec 5, 2018 9:57AMDatabase Administration (MOSC)
• How to solve this sql problem with an analytic function.

  Answered ✓ 82 views 5 comments 4 points Most recent by Scott W Nov 13, 2018 12:38PMSQL Language (MOSC)
• Can you help with the SQL for a payroll costing report that includes the % allocation?

  Answered 177 views 7 comments 2 points Most recent by Catalin Enache-Oracle Nov 6, 2018 9:11AMPayroll and OTL - EBS (MOSC)
• ORA-01427 error concern

  Answered 43 views 1 comment 1 point Most recent by clucas-Oracle Oct 23, 2018 2:20PMDatabase Tuning (MOSC)
• Valid version of functions in responsibility script from note Doc ID 549100.1

  Answered 57 views 2 comments 0 points Most recent by Kanda-Oracle Oct 10, 2018 12:38AMTechnology Stack - EBS (MOSC)
• SQL Developer Version 18.1.0.095 Bug Report

  60 views 2 comments 0 points Most recent by GregV Sep 25, 2018 11:06AMDatabase Utilities (MOSC)
• Queries in the shared pool

  Answered ✓ 96 views 6 comments 1 point Most recent by juduque Sep 14, 2018 8:28AMDatabase Tuning (MOSC)
• Query for IR's that have pending/allocated material

  Answered ✓ 74 views 2 comments 0 points Most recent by Nitin Jain Sep 12, 2018 2:26PMProcurement - EBS (MOSC)
• Invoice Workbench SQL?

  Answered ✓ 40 views 2 comments 0 points Most recent by AnLed Aug 20, 2018 7:03AMPayables and Cash Management - EBS (MOSC)
• AP Workbench SQL - Adding Holds to Query

  Answered ✓ 20 views 1 comment 0 points Most recent by Dairy Land Aug 14, 2018 11:19AMPayables and Cash Management - EBS (MOSC)
• Query for finding Journals with no attachments

  Answered ✓ 82 views 3 comments 1 point Most recent by Cati-Oracle Aug 13, 2018 5:47AMGeneral Ledger - EBS (MOSC)
• AP_INVOICE_DISTRIBUTIONS_ALL table is null

  Answered ✓ 27 views 3 comments 0 points Most recent by Mike C-Oracle Aug 6, 2018 9:52AMPayables and Cash Management - EBS (MOSC)
• Differences between access method by index

  Answered ✓ 65 views 8 comments 2 points Most recent by juduque Jul 11, 2018 1:54PMSQL Performance (MOSC)
• json_object function drops leading zero for small fractional numbers (bug?)

  Answered ✓ 37 views 2 comments 0 points Most recent by cormaco Jul 2, 2018 5:54AMSQL Language (MOSC)
• Create table JDE from Views SQL Developer Oracle

  Answered 280 views 10 comments 0 points Most recent by Haynes-Oracle Jun 7, 2018 12:43PMDesign Tools & Output Technologies - JDE1 (MOSC)