APPS Blogs

R12 Global Deployment functionality

RameshKumar Shanmugam - Sat, 2007-12-29 17:04
It is a common Operation process in any industry to move people around or transfer employee’s temporary basis for a particular project or Assignment. Or transfer them permanently to a different country.

Though this functionality was available in 11i for the HR professionals to do it manually if the cross business group is enabled they can update organization and location in the assignment form, or another method of doing this is to terminate and hire the employee in the new business group.

Now in R12 this functionality has been made as a standard functionality in the Manager Self Service Responsibility Under the function 'Transfer'

Manager Self Service > Transfer



Select the employee you wanted to transfer, follow the wizard which will take you through complete process like new salary change, new direct report, New Location Change, Time card approver, work Schedule etc., finally you will receive a Review summary page where you can review and submit for the approval

Note: if you are a Oracle Payroll Customer you need to take necessary actions when changing the work location for the payroll Taxation
Try this out!!!
Categories: APPS Blogs

Agile PLM 9.2.2.1 – Part II – Database Node Installation

Aviad Elbaz - Mon, 2007-12-24 01:51
Following my last post about Agile PLM 9.2.2.1 – Part I, in this post I’ll show, step by step, how to install Agile PLM 9.2.2.1 system.

The latest version of Agile PLM is 9.2.2.2, but it's too much new to install it for production..

I installed the Agile PLM 9.2.2.1 on 2 nodes configuration:

1) Agiledb – Oracle Database server Node
C:\ drive – OS only
D:\ drive – Database 10g software and Datafiles

2) Agileapp – Agile Application + IIS + Oracle AS + Agile File Manager Node
C:\ drive – OS only
D:\ drive – Agile 9.2.2.1 applications + Oracle AS
E:\ drive – File Vault (managed by the File Manager)

** Both servers installed with Windows 2003 Server OS.

This post will describe all phases of database node installation, and next post I’ll describe the application node installation.

The Agile Database node installation composed from the following steps:
- Complete all database installation pre requisites
- Oracle Database 10.2.0.1 installation
- Oracle Datbase companion installation
- Agile Database creation
- Listener configuration

Database Node Installation - Pre Requisites

1) If server is DHCP configured you should setup a loopback (10g installation requirements)
a. Control panel -> Add hardware



b. Choose: Yes, I have already connected the hardware


c. Choose: Add a new hardware device (the last item on list)


d. Choose: Install the hardware that I manually select from a list


e. Choose: Network adapters


f. Choose at the left side: Microsoft at right side choose: Microsoft loopback adapter



g. Edit the server host file at c:\windows\system32\driver\etc\hosts
Add the following line:
10.10.10.10 agiledb.domain agiledb


h. Navigate to network connections: Start -> settings -> Network Connections
i. Right Click on Local Area Connection – Microsoft Loopback Adapter -> properties


ii. Select TCP/IP -> properties


iii. Edit the ip address to 10.10.10.10
iv. Edit the subnet mask to 255.255.255.0


2) Restart the server


Oracle Database 10.2.0.1 installation

1) Run database installer – setup.exe (from database directory)
2) Select Basic installation – Standard Edition
a. Oracle Home Location: d:\oracle\product\10.2.0\db_1
b. Uncheck the Create Starter Database


3) Review prerequisite checks


4) Click on Install…


5) Exit



Database Companion Installation

1) Run the installer – setup.exe (from companion directory)


2) Select Oracle Database 10g Products 10.2.0.1.0


3) Specify Home details:
a. Name: OraDb10g_home1
b. Path: D:\oracle\product\10.2.0\db_1


3) Review prerequisite checks


4) Install…


5) Exit


Agile Database Creation

1) Copy the “Platform” directory from Agile Disk2 directory to Agile Disk1 directory to the setup.exe level


2) Run [Disk1]:\windows\setup.exe


3) Accept license agreement
4) Enter the license key and user name.


5) Select : Database Server only


6) Enter the location to install the selected Agile 9.2.2.1 components:
D:\agile\agile9221


7) Select Oracle 10g Database Server


8) Install


9) Destination folder for database customization files: d:\Agile9Tmp


10) Select “Medium” Database size
For more information regarding each possibility - small, medium, large... - read the Capacity Planning Guide


11) Select the previous installed oracle home


12) Oracle SID: agile9


13) Enter passwords for Sys and System and user name and password for Agile schema.

14) Click some next’s…




15) Agile installation will create the database


16) Done



Configure Database Listener

1) Navigate to: Start Menu -> Programs -> Oracle - OraDb10g_home1 -> Configuration and Migration Tools -> Net Manager


2) Create new Listener, Name: Listener


3) Select Database Services from the drop down list
a. Click on Add database
b. Global Database Name: Agile9
c. Oracle Home Directory: d:\oracle\product\10.2.0\db_1
d. SID: agile9


4) File -> Save Network Configuration
5) Restart the Listener
a. Lsnrctl stop
b. Lsnrctl start


That’s all for the Agile Database node.
Next post I’ll show the Agile 9.2.2.1 Application node installation.

For more information:
Capacity Planning Guide
OracleAgile Database Installation Guide

You are welcome to leave a comment.
Aviad
Categories: APPS Blogs

Agile PLM 9.2.2.1 - Part I

Aviad Elbaz - Thu, 2007-12-20 02:27
In May this year, Oracle has acquired Agile, a leading provider of Product Lifecycle Management (PLM) software solutions.

In this post I will explain about the various components of Agile PLM system, and the following posts will be dedicated to Agile PLM installation.

The components of Agile PLM application are:
1) Agile Database
2) Agile Application Server
3) Agile File Manager
4) Agile Web Proxies
These components should be installed in the above order.

Agile Database
Used to hold all Agile data.
It is recommended to install the database and application server on separated machines.

Agile Application Server
The Agile Application Server can be run on Oracle Application Server 10g or BEA WebLogic Server.
The Application Server is the main component of the Agile system, all services and business logic reside on it.
The Agile application deployed on the Application Server.
All users (Java/Web clients) connect to the Application Server in 2 possible ways:
- Directly
- Indirectly, via Wev proxy Server.

Agile File Manager
The File Manager manages all Agile files in the file system (File Vault).
The File Manager runs on Tomcat.

Agile Web Proxies Server
The Agile web client allows connection to both internal and external users.
Agile web client uses Microsoft IIS (Internet Information Services) or Apache web server.
The Agile web client connects to an Agile Application Server the same way like other Agile Application Server clients.



Next post I will show, step by step, how to install Agile PLM 9.2.21 on two nodes configuration.

Aviad
Categories: APPS Blogs

Data Auditing in Oracle Applications - Audit Trail

Aviad Elbaz - Wed, 2007-11-28 02:01
Following my last post about Audit users in Oracle Applications, in this post I’m going to talk about the Audit Trail - the data auditing feature in Oracle Applications.
The AuditTrail enable us to know who, when and what was changed on each table we would like to audit.
For example: Some of the profiles in Oracle Applications are very critical and important for normal activity of the system (like MO: Operating Unit).
We might be interested to know who changed the value of critical profiles and the Audit Trail certainly can help us.

Now I’ll show a step by step demo how to start Audit Trail on a table, I will go on with my previous example on the profiles table.
The table we would like to audit is FND_PROFILE_OPTION_VALUES.

1) Logon to system with System Administrator responsibility.

2) Make sure the profile “AuditTrail:Activate” is set to Yes

3) Check the audited table's owner
select owner
from dba_tables
where table_name like 'FND_PROFILE_OPTION_VALUES';

The owner is APPLSYS.

4) Check that audit is enabled for APPLSYS user
Go to: Security -> AuditTrail -> Install -> Query for APPLSYS




5) Define new Audit Group
Since the audit enabled on groups of tables, we should define a new Audit Group which will contain the FND_PROFILE_OPTION_VALUES table.

Find the table’s application name by this query:
select fav.application_name
from fnd_application_vl fav, fnd_tables ft
where fav.application_id = ft.application_id
and ft.table_name = 'FND_PROFILE_OPTION_VALUES';

The query result: Application Object Library

Navigate to: Security -> AuditTrail -> Groups

Application: Application Object Library
Audit Group: AC FND Profile Values Audit
Group State: Enable Requested


At this level, the columns that will be audited are the columns of the primary key or the first unique index on the audited table.
You can add columns to be audited as much as you want.

6) Check/Add column to audit
Navigate to: Security -> AuditTrail -> Tables
Query for FND_PROFILE_OPTION_VALUES table.


Add column PROFILE_OPTION_VALUE to be audited.


7) Run the “AuditTrail Update Tables” concurrent to enable the audit
Navigate to: Requests -> Run -> Single Request -> choose request name: “AuditTrail Update Tables” -> Submit


All definitions we made until here will not take effect until we execute this concurrent.
This concurrent will create all objects (triggers and procedures) required for audit, and views to retrieve the audited data.

This request should be executed each time we make changes in audit definitions, to generate new audit objects.

To make sure it works, we can check if all audit objects were created:


All audit objects names will be the first 26 characters of the audied table + suffix (_A, _AC, _AD...).
We can also run report “AuditTrail Report for Audit Group Validation” to make sure all audit objects created successfully.


Now let’s make a test to see how it works:
To test the audit on the profile's table, we will change a value for a profile (any profile) and check the shadow table (fnd_profile_option_value_a) for an audit inormation.

Navigate to: Profile -> System , and update the profile “FND: Diagnostics” (just for testing... you can choose any profile) to Yes.

To see the audited data of the last change we can run this query:


The change was audited as expected...

As you can see, the “U” in the audit_transaction_type column indicates an update and the profile_option_value contain the value before update.

The audit_transaction_type could be:
1) U - update
2) D - delete
3) I - insert


How to disable Audit Trail?

The AuditTrail could be stopped by 3 ways:
1) Disable Prepare for Archive
2) Disable Interrupt Audit
3) Disable Purge Table

I've tried the third only… It deletes the data from the shadow table and drops all the audit objects from database.

1) Login to application and choose the System Administrator responsibility.
2) Security -> AuditTrail -> Groups
3) Query for your group
4) Update the Group State field to: “Disable – Purge Table”.
5) Run the “AuditTrail Update Tables” concurrent to make the changes.

That’s all about auditing…

You can read more at "Oracle Applications System Administrator’s Guide - Security Release 11i" - Chapter 5 - User and Data Auditing

To get my posts directly to your email, you can register for email subscription by using the box at the right side bar.

You are welcome to leave a comment.

Aviad

Categories: APPS Blogs

HRMS PFK RUP2 Global name Search

RameshKumar Shanmugam - Fri, 2007-10-26 01:33
Mainly in the multi BG environment we end up in creating duplicate employee name, the current HRMS search functionality some times the duplicates are missed out due to the localization and the Name format used in each legislation.

In the Family Pack K Rup 2, System Uses Global Name format to Search for the Duplicates Across Business Group.
The Global name format is independent of the Legislation which helps us to avoid the duplication.

To Enable this Functionality we need to enable the profile HR:Cross BG duplication Person Check.

Still the HRMS uses the same existing functionality to search the employee in single business group

Try this out!!!

Regards
Ramesh Kumar S
Categories: APPS Blogs

Payroll Reversal Pack K Rollup 2

RameshKumar Shanmugam - Sun, 2007-10-14 15:44
HRMS Family Pack RUP 2 was released on Jun 2007.
Due to current project schedule i didn't had much time to test the new functionality.
This week i had the chance to install the PF K RUP 2 to my test instance, the lot of functionality which i was expecting is here now...

The first thing which i would like to highlight is Payroll Reversal functionality.
If you want to reverse assignments that have been processed as part of a payroll run or QuickPay run, you can now reverse them as a group by assignment set instead of reversing by individual assignment only. Any assignment sets that you use for reversals can also use the normal assignment set features such as:
  • Include or exclude specific assignments
  • Make formula-based amendments

The original reversal by single assignment is still available, and you can continue to access it from the Assignment window.

Payroll Reversal Details http://ramesh-oraclehrms.blogspot.com/2007/09/payroll-reversal.html

Defining Assignment Set http://ramesh-oraclehrms.blogspot.com/2007/08/assignment-set.html

Try it out!!!

Categories: APPS Blogs

Changing Salary Basis

RameshKumar Shanmugam - Sun, 2007-10-07 23:37
An interesting scenario came in one of my current projects with my customer who are already using Oracle HRMS for past three years
They wanted to change the salary basis from Monthly to Period (Biweekly). It is a common scenario that many company may change their Salary basis from monthly to biweekly or Bimonthly, but the interesting thing in this project is they wanted to modify the history salary information for all the employees from Monthly to Biweekly.

The first thing that came in my mind was the Auditing issue that we might run since we are touching the most sensitive information of the employee data (SALARY), But the HR Users clearly informed us they can provide us with the exact data that need to be loaded.
Another advantage was the customer is not using Oracle Payroll,Oracle HRMS system is not a transactional system

We followed the following approach
  • Remove the salary proposal for the employee for whom we need to modify.
  • Update the Assignment with the new Salary Basis in Correction mode
  • Reload the salary with the same Change date as we unloaded

We used WebADI for unloading Salary information, updating assignment with the new salary basis and loading the salary proposal for the new salary basis.

We used WebADI custom Integrator with the following API

  • HR_MAINTAIN_PROPOSAL_API.DELETE_SALARY_PROPOSAL
  • HR_ASSIGNMENT_API.UPDATE_EMP_ASG_CRITERIA
  • HR_MAINTAIN_PROPOSAL_API.UPDATE_SALARY_PROPOSAL

Try this out!!!

Categories: APPS Blogs

Balance Adjustment

RameshKumar Shanmugam - Sat, 2007-09-29 16:29
When we process the payroll, there are times that the users might have deducted excess tax or other deduction, So we might need to correct the Balances for the correct YTD and the for year end reporting

There are two methods of doing it.
By defining an Balance Adjustment Element or if we know the exact amount to be corrected then we can able to adjust using the Adjust Balance Form. The latter one is very simple and it is an easy option to adjust the balance

Follow the below steps to adjust the balance using the Adjust Balance form, if we know the exact amount to be adjusted

Fast Path > Adjust Balance > Select the Assignment for which we need to adjust the balance
Set the Effective date
  • Select the element who's pay or the Input Value need to be adjusted
  • Select the Consolidation set to control the further Post-run Processing
  • Check the costing Check box if you need the balance adjustment to be costed
  • Save the work

Try this out!!!

Categories: APPS Blogs

Payroll Reversal

RameshKumar Shanmugam - Sun, 2007-09-16 16:38
After running the payroll and if post run processing has already occured we cannot correct the payroll by Retry, even in case of roll back we need to roll back the complete Payroll for correcting an entry for one or two assignment.
In these cases we can use Payroll Reversal. In short Payroll Reversal helps to correct the run result for an single assignment

To Reverse the Payroll run for an assignemnt
(R) US HRMS Manager
(N) Fast Path > Reverse Payroll Run
Select the Assignment that you need to reverse from the LOV, Tick the Reverse Check Box for the Payroll that we need to reverse and save the work. Consolidation set for the run will be automatically displayed for the Reversal
Now the Run Result is been reversed to the Value before the payroll Run. Now you can modify the Entry and start processing your payroll again.

Try this out!!!
Categories: APPS Blogs

Payroll Rollback

RameshKumar Shanmugam - Wed, 2007-09-05 16:19
Once the Payroll /Quick Pay process is completed if there is some issue or if some correction need to be made. We can either
  • Retry
  • Reverse
  • Rollback

In this blog i am trying to explain how to rollback a Payroll process.

What Rollback does?

In simple word to explain Rollback process reset the Run Result and the Latest balance back to the value before running the Payroll Process.

Rollback process has to be run in the same reverse sequence of the Payroll Run. for eg. for processing the payroll, we run the following process in sequence Payroll run, Prepayment, costing, Transfer to GL. Similarly for the Rollback we need to run in the reverse sequence Rollback Transfer to GL, Rollback Costing, Rollback Prepayment, Rollback Payroll Run.

Note: if the costing details are imported into GL then we cannot rollback the process.So it is always advisable to run the Transfer to GL process after all validation and checking are done and run this process when we feel no more modification are needed

List of Process type that can be rolled back in PF K RUP1

  • Advance Pay Element
  • Balance Adjustment
  • Bank or Post office Payment
  • Batch element entry
  • cheque writer
  • Costing
  • Costing of Payment
  • Estimate costing
  • ext/Manual Payment
  • Magnetic report
  • Magnetic Transfer
  • Pre-Payments
  • Purge
  • QuickPay Pre-Payment
  • Quick Pay run
  • Report Generator
  • Retro Costing
  • Retro Pay
  • Retro Pay by Action
  • Retro Pay by element
  • Reversal
  • Run
  • Transfer to GL
  • Void Payment

Categories: APPS Blogs

Quick Pay Process

RameshKumar Shanmugam - Mon, 2007-09-03 21:32
  • For processing the payroll for a single employee we can use Quick pay
  • For employee who is leaving and for whom we need to pay by check or cash
  • When an employee is joined after the payroll run has been completed for the period we can use Quick pay to process only for this particular employee instead of completely rollback the Payroll Process and starting it again.

Follow the process to run the Quick Pay(N) Assignment > (B) Others > Quick Pay

  • Set the effective Date for the Quick pay
  • Date Paid and Date Earned will be defaulted to the effective date
  • Select the consolidation set
  • Select the Run Types (it varies from Legislation to Legislation)
  • Save the Quick Pay Definition
  • Submit the quick pay by pressing the start Run Button.
  • Status should be changed from un-processed to Complete.
  • If any errors fix the error and press the retry button
  • Once the Quick Pay run is completed we need to process the PrePayment
  • We can run the Prepayment from the Quick Pay window by just clicking the button start PrePayment Or combine it in the Batch PrePayments processing for the assignment’s Payroll (this can be used when a new employee is joined after the payroll run is completed so we can run the quick pay separately for this employee and combine it with the batch or the prepayment.)

Try it out!!!

Categories: APPS Blogs

Payroll Retry

RameshKumar Shanmugam - Mon, 2007-08-27 11:40
Once the Payroll run is completed there may be chance that few assignment may end up in some errors or few assignment may be processed with some old element entries or payroll department would have processed with limited information or the payroll analyst would have forgotten to modify the formula for earning/deduction element which will affect certain group of Employees, We can uses retries for correcting these mistake which occurred in the Payroll Run provided there are no Post run process taken Place

We can retry a single assignment, set of assignment, or Mark a large payroll Process for Retry

To retry Single assignment
  • It can be done in the quick Pay form by clicking the Retry Button, this is the convenient method for retying if we have very few employees to be corrected

To retry for small number of process

  • In the Payroll Process window, Query the process based on the payroll and the Action type, Mark the process for retry by checking the Retry check box
  • This effectively marks all the assignment attached to the process

To Mark a Large Payroll Process for Retry

  • If we need to retry the payroll, run the Process 'Mark Payroll Run for Retry' this has two parameters Payroll run and the Assignment Set

Note:

  • If any post run process has occurred then we need to rollback the Post Run Process and then mark the process for retry
  • Any assignments having a status of Error after a payroll run, those assignments are automatically retried when you run the payroll again
Try this Process!!!
Categories: APPS Blogs

Payroll Processing

RameshKumar Shanmugam - Tue, 2007-08-21 00:41
Before we start the Payroll Run. We need to assign the necessary element for the employee

For the normal payroll run we will include all the elements and process all the assignment
But under certain circumstance we may need

  • Include or exclude certain element or assignment
  • Include or exclude certain group of assignment
  • Include or Exclude certain classification of element

For the above conditions we may need to create an Assignment set or an Element set

Creating Assignment Set

Example for the use of assignment set is. We need to process the payroll for the night shift employees before the day shift employees as they need to receive the Pay advice the night before the rest
For complete details of setting up the Assignment set please refer the blog http://ramesh-oraclehrms.blogspot.com/2007/08/assignment-set.html

Creating Element Set

  • Enter the Element Set name
  • Choose the classification as ‘Run Set’
  • Save the work
  • Select the Include button and add the required element to the set

The Payroll Process

  • Quick Pay
  • Payroll run

Quick Pay

Follow the link for the Quick Pay in Detail

Follow the steps to run the Payroll Process
1) Payroll Process
Parameters: Payroll Name
Consolidation Set
Element Set
Assignment Set
Date Earned
Date Paid
Run type
2) PrePayments
Parameter: Payroll Name
Consolidation set
Start Date
End Date

3) Run the check writer Process (Enabled for few legislation)
4) Run the Direct Deposit Process
5) Payslip Archive Process

If the costing is enabled then
6) Run the costing Process
7) Costing of Payments (if you want to cost at the payment method level)
8) Transfer to GL

From the GL side, import the Journal Entry

Try it out!!!

Categories: APPS Blogs

Assignment Set

RameshKumar Shanmugam - Sun, 2007-08-19 16:41
Assignment set are to be defined for the following purpose
  • For processing only the subset of the Assignment for the payroll processing eg: Payroll for the People who work in the night shift need to be processed first as they need to receive the pay advice before the day shift employees
  • For generating the quick paint report for the set of assignment
  • Can be used in the BEE for creating the identical entry for all the assignment in the Assignment set

Before we start defining the Assignment set we need to decide whether we are going to use Assignment set for the payroll process or for some other process like reporting etc.

Defining the Assignment set

  • Enter the name of assignment set (Only Char, ( _ ) and Numbers are allowed and NO SPACE allowed)
  • If you need to use this assignment set only for the payroll then select the Payroll from the LOV Otherwise it is an optional field we can leave it blank.
  • Save the work

If we want to use the formula criteria for defining the Assignment set choose the button Criteria from the assignment set window

  • Enter the Seq Number
  • Leave the Condition field Blank for the first line, you can choose either AND / OR depending on the criteria
  • Choose the Database Item as the variable for the criteria (all the Database Item will be prefixed by '&')
  • Choose the Operator (=, <=, >= , etc..,)
  • Enter the Value or choose the Database Item
  • Keep entering the other criteria from the second line
  • Save the work

If you specifically want to include or exclude any assignment choose the button Amendment button

  • Choose the option Inc/Exc from the LOV
  • Select the Name from the LOV
  • Save the work

Select the Generate Button for generating the Fast Formula for the criteria defined above. The Fast formula will be created with the same name as the assignment set

Try it out!!!

Categories: APPS Blogs

Cost Allocation flexfield and Costing process

RameshKumar Shanmugam - Mon, 2007-08-13 17:40
Following are the important Key flexfield in HR and Payroll

HRMS

  • Job Flexfield
  • Position flexfield
  • Grade Flexfield
  • People Group
  • Cost Allocation
  • Competence Flexfield
  • Personal Analysis Flexfield
  • Soft Coded KeyFlexfield
Payroll

  • People Group Flexfield
  • Cost Allocation Flexfield
  • Bank Details KeyFlexField
Setting up of Cost allocation flexfield is an mandatory setup step for the Payroll Setup

Cost allocation Flexfield is used to accumulate the employee costing information, if we use Oracle Payroll we can accumulate the cost associated with the payroll and transfer to GL and if we are not using Oracle Payroll we can able to interface the costing information to the third Party Payroll system

Few important points which should be taken care before creating the Cost allocation flexfield.

  • If we are planning to integrate with the GL, then the number segment in the cost allocation flexfield should be same or more than the accounting flexfield.

  • We should atleast have one segment for the cost allocation flexfield otherwise will run into error when defining payroll or in other form which is having this flexfield

Cost Allocation flexfiled makes use of qualifiers, we can use the segment qualifiers to control the level at which the costing information can be entered in the system.the various level at which we can cost are

  • Element entry
  • Assignment
  • Organization
  • Element Link
  • Payroll

If the element is not costed at any level then the final costing information will get accumulated in the suspense account which is defined in the payroll form.

Use the GL Map window to map the cost allocation flexfield with the GL Accounting flexfield, we should map each cost allocation segment with the GL Segment for each Payroll. for the addition segment in the cost allocation flexfield should be mapped to 'Null'

Following are the process that you need to run for transferring the costing information from Oracle to Payroll

  • Costing process
  • Costing of Payment
  • Transfer to GL

Try it out!!!

Categories: APPS Blogs

Assignment action interlock rule failure

RameshKumar Shanmugam - Sun, 2007-08-12 17:02
During the Payrol Run Rollback Many time we might come accross with the Error message
APP-PAY-07507: Assignment action interlock rule failure

This May be due to multiple resason but one such reason is, there may be some future sequenced process which has to be rollback before we roll back the current process.

To find the list of all future sequenced process Exucute the following Query

select distinct pact.payroll_action_id, pact.effective_date, pact.action_type
from pay_action_classifications CLASS,
pay_payroll_actions PACT,
pay_assignment_actions ACT,
per_assignments_f ASS,
per_periods_of_service POS,
pay_assignment_actions act1,
per_assignments_f ass1
where POS.person_id = ass1.person_id
and ass1.assignment_id = act1.assignment_id
and ASS.period_of_service_id = POS.period_of_service_id
and ACT.assignment_id = ASS.assignment_id
and ACT.action_sequence > act1.action_sequence
and ACT.action_status in ('C', 'S', 'M')
and ACT.payroll_action_id = PACT.payroll_action_id
and PACT.action_type = CLASS.action_type
and CLASS.classification_name = 'SEQUENCED'

This Query will return the list of all future sequence process which need to be rolled back first before we rollback the current process

Hope this helps :)
Categories: APPS Blogs

Pages

Subscribe to Oracle FAQ aggregator - APPS Blogs