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’
find concurrent programs associated with responsibility
Know concurrent programs associated with responsibility using responsiblity key
If Receiving Trasaction Processor Fails
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 where request_id = 1192033 [...]
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.
[...]
