Discussion List

• ORA-01704 string literal too long error during execution of select query

  Answered ✓ 32 views 4 comments 0 points Most recent by Anthony Harper May 21, 2025 10:43AMPL/SQL (MOSC)
• need a Query to get GL_DAILY_RATE for the expenditure_item_date

  Answered 1.9K views 6 comments 0 points Most recent by Ananthavadivel-Oracle May 20, 2025 11:34AMProcurement - EBS (MOSC)
• Granting read only to user on packages, function, trigger and procedures

  Answered 42 views 4 comments 0 points Most recent by Mr. C Mar 4, 2025 12:43PMDatabase Administration (MOSC)
• can we have a solution of display of data in the form of table integrating html in plsql

  Answered 1 view 1 comment 0 points Most recent by NeerajSh-Oracle Feb 14, 2025 1:05PMOracle Application Express (MOSC)
• publish PL/SQL procedure as native webservice (not as REST datasource)

  Answered ✓ 21 views 2 comments 0 points Most recent by User_375BO Jan 30, 2025 9:01AMOracle Rest Data Services (ORDS) (MOSC)
• Error from process order API

  Answered 21 views 3 comments 0 points Most recent by Piyush-Oracle Jan 24, 2025 12:43PMOrder Management - EBS (MOSC)
• Oracle File Watcher feature

  Answered 32 views 1 comment 0 points Most recent by Swati Aryasomayajula -Oracle Jan 3, 2025 9:56AMPL/SQL (MOSC)
• Dynamically Creating views inside a Table Based Trigger

  Answered 12 views 2 comments 0 points Most recent by BrunoVroman Jan 1, 2025 3:19PMPL/SQL (MOSC)
• Can ORDS execute packages belonging to non ords enable schema ?

  Answered ✓ 61 views 9 comments 0 points Most recent by User_CT6JT Dec 13, 2024 8:08AMOracle Rest Data Services (ORDS) (MOSC)
• Print PDF file from a directory using concurrent

  Answered 21 views 7 comments 0 points Most recent by SylvieB-Oracle Dec 5, 2024 7:05AMCore Concurrent Processing - 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)
• Need to get a sample input payload for a RESPT API on PLSQL Interface EGO_USER_ATTRS_DATA_PUB

  Answered 11 views 2 comments 0 points Most recent by Nirmal Natarajan-Oracle Sep 27, 2024 5:14PMOracle SOA Suite (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)
• Updating Profile Option from sqlplus

  Answered ✓ 71 views 23 comments 0 points Most recent by Hari Kumar-Oracle Jul 25, 2024 5:23AMEBS Customizations (MOSC)
• Need to restrict entering past dates in line mass change form in oracle order management

  Answered 1 view 1 comment 0 points Most recent by Sibghat H-Oracle Jun 25, 2024 7:15AMOrder Management - EBS (MOSC)
• Http request using multipart/form-data using pl/sql is ignoring UTF-8 and sending invalid characters

  Question 11 views 0 comments 0 points Most recent by RMirmira Jun 12, 2024 7:28PMPL/SQL (MOSC)
• Creating a scheduler job in a package/proc

  Answered ✓ 11 views 2 comments 0 points Most recent by BrunoVroman Jun 4, 2024 10:23AMPL/SQL (MOSC)
• Concurrent Program with RDF Source is erroring with REP-0736: There exist uncompiled program unit(s)

  Answered 21 views 1 comment 0 points Most recent by rplaton-Oracle May 22, 2024 2:59AMCore Concurrent Processing - EBS (MOSC)
• ORA-01031 on execute immediate ALTER SESSION SET CONTAINER

  Answered ✓ 113 views 4 comments 0 points Most recent by Dag Ubx May 2, 2024 12:17PMDatabase Administration (MOSC)
• How to schedule Oracle Alert

  Answered 11 views 1 comment 0 points Most recent by Nirmal Natarajan-Oracle Apr 26, 2024 3:08PMProcurement - EBS (MOSC)
• searching specific text in xmltype column without indexing - ORA-19011

  Answered 1 view 1 comment 0 points Most recent by Nirmal Natarajan-Oracle Apr 16, 2024 3:12AMXML Database (MOSC)
• ORA-00904: "xxxxxxxxxxxx": invalid identifier (3: 0): Warning: compiled but with compilation errors

  Answered 21 views 4 comments 0 points Most recent by User_SB2ED Apr 11, 2024 3:19PMPL/SQL (MOSC)
• OTL Entry

  Answered 41 views 8 comments 0 points Most recent by Viveks-Oracle Mar 28, 2024 11:38AMPayroll and OTL - EBS (MOSC)
• Custom changes to concurrent programs to pull data based on operating unit assigned to responsibilit

  Answered 11 views 2 comments 0 points Most recent by User_MCY7Y Mar 20, 2024 2:09PMTechnology Stack - EBS (MOSC)
• Convert the entire table data as csv format and insert it in another table's single column.

  Answered 11 views 2 comments 0 points Most recent by Anthony Harper Mar 17, 2024 1:22AMPL/SQL (MOSC)
• Whitespace Separated Values: PL/SQL Package to Parse/Create

  Answered 1 view 2 comments 0 points Most recent by m971668 Jan 29, 2024 8:48PMPL/SQL (MOSC)
• how we can get paid invoices as unpaid when run on as on date?

  Answered 2 views 1 comment 0 points Most recent by L. Fernigrini Jan 29, 2024 7:06PMPL/SQL (MOSC)
• UTL_MAIL with larger file size and multiple .csv file attachments

  Answered 22 views 4 comments 0 points Most recent by User_4TT2B Jan 22, 2024 4:52PMPL/SQL (MOSC)
• Need help to avoid null pointer exception in OAF

  Answered ✓ 91 views 2 comments 0 points Most recent by Nirmal Natarajan-Oracle Jan 22, 2024 2:00PMProcurement - EBS (MOSC)
• How to display plsql report output horizontally?

  Answered ✓ 1 view 3 comments 0 points Most recent by Suresh Sangaran-Oracle Jan 5, 2024 10:40AMOracle Reports (MOSC)