Site navigation (main menu).

Blog

R12 New Mass Adjust Concurrent Process

We would like to welcome Roland Colling as a guest author on our Blog. Roland is an independent Oracle Projects Suite Functional Consultant. He has worked on a wide range of 11.5.10 Project Suite implementations throughout Europe and is currently researching into the new functionality in Release 12 and R12.1

A new Mass Adjust Concurrent Process is now added in Release 12 for users of the Mass Adjust functionality which is available in the Expenditure Inquiry forms. In Release 11.5.10 you find the Mass Adjust button in Expenditure Inquiry (All or Project). You enter parameters on the Find Expenditure Items window to determine the target data for your adjustment. Click the Mass Adjust button. You then select the type of mass adjust that you want to perform from the list of values.

Depending on the selection there may be a parameters form to complete or a confirmation box as follows:

When you click Yes it carries out the process on-line – while you wait.

This is fine for low volumes which only take a few seconds, but larger volumes could tie up the session for an unacceptable amount of time.

In Release 12 again you click the Mass Adjust button in Expenditure Inquiry (All or Project) and then enter the parameters and select the type of mass adjust that you want to perform from the list of values.

Enter the adjustment parameters if required:

Click OK.

So this Decision box is the big change. By clicking Yes the new concurrent process PRC: Adjust Expenditure Items is triggered and the session is freed up.  The request number appears at the bottom of the screen. (This process is not available to run as a normal concurrent process from Submit > Requests).

Once it’s completed you can review the output of the request.

The output of the concurrent process is very basic. It simply states the number of transactions selected and the number of successes and rejections. It then gives details of any rejections, with rejections codes explained at the end of the output. It gives no details of the transactions that it has created – you have to go back to the Expenditure Items window to review the results. This is a little disappointing, it would have been a nice if this process could have provided a record of the adjustments carried out. You can review the expenditure adjustment audit information for a project in the AUD: Project Expenditure Adjustment Activity report. You can review the transfer activity for a project using the MGT: Transfer Activity report.

In conclusion I think it is fair to say that this concurrent process is going to be welcomed warmly by those wishing to do high volume processing using Mass Adjust such as during a re-organisation, simply because it frees up the session during processing rather than them having to wait for the on-line process to complete. Mass adjust will also be used more widely now the supplier cost adjustment restrictions have been removed in R12, so it is likely that the new concurrent process will have a wide usage.

26 Oct, 2009 by

E-Business Suite

Comments are now closed... Please contact us if you have any queries.