Often there will be a requirement for reading .out files generated by Oracle Applications and converting into pdf files and send as mail attachment.
Here is a sample PL/SQL procedure which can read a file from a specified location, into a BLOB and returns it.
The calling program can convert this blob data into any form.
Calling program [...]
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 [...]
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 [...]
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.
[...]
Oracle’s new approach to report design and publishing by integrating familiar desktop work processing tools with existing E-Business Suite data reporting, is Oracle XML Publisher.
It is a template based publishing solution developed with Oracle E-Business Suite.
XML Publisher leverages standard, well-known technologies and tools, so you can rapidly develop and maintain custom report formats.
The flexiblity of [...]
