retrive active users in oracle applications
retrieve currently active and valid fnd user from oracle applications
Posts Tagged ‘Oracle Applications’
Know request group name of concurrent programs
knowing request group name to which a concurrent program is associated helps in oracle apps…..
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 [...]
Subinventory creation in Oracle Applications
Subinventories are logical seperations of material inventory such as raw material, finished goods and defective material. Material in an organization is held in Subinventory, so we need to define subinventories for an organization.
To Define Subinventory:
1) loginto Oracle Applications.
2) Click on path Inventory -> setup: organizations -> Subinventories.
3) select the organization in which you are going [...]
