Split String using Oracle PL/SQL
Oracle PL/SQL provides various string functions, but there is no direct function to split a string into substrings, we need to write a custom code to do this task.
Posts Tagged ‘Oracle’
How to Find concurrent programs associated with responsibility in Oracle Applications
Know concurrent programs associated with responsibility using responsiblity key
How to find Scheduled Concurrent Programs in Oracle Applications
Know when a concurrent program is scheduled in Oracle Apps
What If Receiving Trasaction Processor Fails in Oracle Applications
If receiving transaction processor fails to receive, inspect or deliver lines in Receiving Open Interface. You can run Receiving Interface Errors Report to know the exact error. Instead of running Receiving Interface Errors Report concurrent Program, you can simply query the error from Oracle Database in po_interface_errors table. Use following query: select * from apps.po_interface_errors [...]
User Creation in Oracle Applications
Pre-Requisite: Only users having System Administrator previliges can create new users in Oracle E-Business Suite. STEPS: 1) Login to Oracle E-Business Suite using System Administrator Responsibility. 2) Click on menu link Security: user –> Define, you will be shown below screen. 3) Enter UserName in User Name field. 4) Enter Password in Password field. Note: [...]
