Monday, November 12, 2012

Some important queries related to po_fill_emp_hierarchy in oracle purchasing


Some important queries related to po_fill_emp_hierarchy in oracle purchasing

/* Get the list of all the position hierarchies. */
SELECT pps.position_structure_id, ppsv.pos_structure_version_id
  FROM per_position_structures pps,
       per_pos_structure_versions ppsv,
       financials_system_parameters fsp

Saturday, November 10, 2012

Email Concurrent program output to user in Oracle Apps


Very often you get requirement from the client to email the output of a report to the users. So here is a sample way by which you can generate the report output and email the same to the user.

 

Following are the setups involved:

1.    Create a Request set with two concurrent programs

a.    First concurrent program is developed based on the customer requirement to generate the report output.

b.    Second concurrent program gathers the output details into a custom table.

2.    Create an Alert on the custom table to send the output of the Request set’s first concurrent program to the users.

Make Read Only Responsibility of Users in Oracle Apps


For a leading American client’s audit team required access to all the oracle applications responsibilities. The access was required to carry out the internal audit. They required read only access as they were auditing the system and not performing transactions or setup configurations.

Oracle Application GL Journal Interface Process


This Blog post is written for end-to-end automation of Oracle Applications’ General Ledger (GL) Journal Interface, and it contains all the best practices followed in the interface as well. The purpose of this white paper is to serve as a template, as well as reference material for the interface. This outlines the entire implementation of GL Interface process in detail. It details the interface in detail - from the time of getting data from any external source, till it gets transferred into Oracle Applications’ GL as Journals. It also contains information on error handling of the interface.