Mar 22, 2012

RetroPay Series - Different Dates in Enhanced RetroPay


As you may already know, RetroPay (Enhanced) process is the current advanced version of RetroPay and is a step forward to automatic back-pay processing.
Running Retro-Notifications Report (Enhanced) is a mandatory step before running in enhanced RetroPay.

How Retro Pay Works?
RetroPay process assignment by assignment. Oracle Payroll, internally, in a separate session, rollback and rerun all the payrolls of an assignment from a specified date. The system then compares the old balance values with the new ones and entry values are created for the RetroPay elements based on the difference of values.  These entries are processed for the assignments in the subsequent payroll run for your current period.
It is important to note that, no actual changes are made to audited payroll data, which means RetroPay process won't touch the existing data of previous payrolls.

There are different types of dates in the context of RetroPay with the descriptions as given below.

Date Earned
It is the date on which payroll action is created.
In fact, this is one of the columns in PAY_PAYROLL_ACTIONS table.
This date will be one for all assignments in a payroll.

Effective Date
It's one of the mandatory parameters of "Retropay (Enhanced)" Concurrent Program (CP) and RetroPay payroll action will be created with this date. Enhanced RetroPay internally checks if there are any payroll actions exists after this date and it will create derived retro element entries (if any) only when there are no future payroll actions after this date.
This date will be one for all assignments in a payroll.

Entry Creation Date
Optional parameter to RetroPay (Enhanced) CP, visible only to specific legislations like SA.
This is the date on which calculated retro element entries (EEs) are created.
This date can be greater than or equal to "Effective Date". This parameter is used to pay the back dated payroll changes in the future payroll periods, instead of current payroll periods.
It will be one for all assignments in a payroll.

Recorded Date
This date is used internally by Retro Notifications Report Enhanced (RNR) to list out all the assignments that have unaccounted back-dated changes in the given payroll. It can be defined as the date on which last RNR was run. For the first run of RNR on a fresh assignment, it will be "Date Earned" of latest payroll action.
This date will be one for one assignment. 

Reprocess Date
This date is calculated by RNR for an assignment based on the events that are logged.
It is the earliest date of all the back-dated changes on the given assignment. If there are no overlaps, RetroPay will rollback/rerun the payrolls in memory starting from this date. 
It is one of the columns in PAY_RETRO_ASSIGNMENTS table.
This date will be one for one assignment. 

Overlap Start Date
This date is internally calculated by enhanced EntroPay process depending on the overlappings with previous retropay runs.
It is the date from which actual rollback/re-run of payrolls happens in memory.
RetroPay recursive go back to all the overlaps (if exist) and calculates the earliest date from when payrolls need to re-run so that it derives correct results. 
This date will be one for one assignment.


Mar 9, 2012

Oracle Apps 11i and R12 Context/Environment Files/Variables





INST_TOP is newly introduced in R12. Following figures show the snapshot of file structures both in R11i and R12.


Important File Locations


File Oracle Apps 11i Oracle Apps R12
Environment Source file APPSORA.env APPS<SID>_<hostname>.env
Context File (Middle tier) $APPL_TOP/admin/$TWO_TASK.xml $INST_TOP/appl/admin/$TWO_TASK_<hostname>.xml
tnsnames.ora (OH) $ORACLE_HOME/network/admin/<CONTEXT> $INST_TOP/ora/10.1.2/network/admin
listener.ora $ORACLE_HOME/network/admin/<CONTEXT>$INST_TOP/ora/10.1.2/network/admin
appsweb.cfg $OA_HTML/bin $INST_TOP/ora/10.1.2/forms/server
tnsnames.ora (Apache) $IAS_ORACLE_HOME/network/admin/<CONTEXT> $INST_TOP/ora/10.1.3/network/admin
jsev.properties $IAS_ORACLE_HOME/Apache/Jserv/etc $INST_TOP/ora/10.1.3/opmn/conf/opmn.xml
httpd.conf $IAS_ORACLE_HOME/Apache/Apache/conf$ORA_CONFIG_HOME/10.1.3/Apache/Apache/conf
apps.conf $IAS_ORACLE_HOME/Apache/Apache/conf $ORA_CONFIG_HOME/10.1.3/Apache/Apache/conf
formservlet.ini $IAS_ORACLE_HOME/Apache/Jserv/etc $ORACLE_HOME/forms/server/default.env
topfile.txt $APPL_TOP/admin $APPL_CONFIG_HOME/admin
adovars.env $APPL_TOP/admin $APPL_CONFIG_HOME/admin
adjborg2.txt$APPL_TOP/admin$APPL_CONFIG_HOME/admin
SSL Certificates$COMMON_TOP/admin/certs$INST_TOP/certs
AD scripts logs$COMMON_TOP/admin/log/<SID_hostname> $LOG_HOME/appl/admin/log
Concurrent Request logs$APPLCSF $APPLCSF
Apache logs$IAS_ORACLE_HOME/Apache/Apache/logs$LOG_HOME/ora/10.1.3/Apache
Jserv logs$IAS_ORACLE_HOME/Apache/Jserv/logs $LOG_HOME/ora/10.1.3/j2ee
javacache.log$COMMON_TOP/rgf/<SID_hostname> $LOG_HOME/appl/rgf


Environmental variables
Variable Oracle Apps 11i Oracle Apps R12
APPL_TOP$HOME/<SID>appl $HOME/apps/apps_st/appl
COMMON_TOP $HOME/<SID>comn $HOME/apps/apps_st/comn
ORACLE_HOME (applmgr) $HOME/<SID>ora/8.0.6 $HOME/apps/tech_st/10.1.2
IAS_ORACLE_HOME $HOME/<SID>ora/iAS $HOME/apps/tech_st/10.1.3
ORACLE_HOME (oracle) $HOME/<SID>db/10.2.0 $HOME/db/tech_st/10.2.0
ORADATA $HOME/<SID>data $HOME/db/apps_st/data
JAVA_TOP, OA_JAVA $COMMON_TOP/java $COMMON_TOP/java/classes
OA_HTML $COMMON_TOP/html $COMMON_TOP/webapps/oacore/html
FND_SECURE $FND_TOP/secure/<SID> $INST_TOP/appl/fnd/12.0.0/secure
ADMIN_SCRIPTS_HOME $COMMON_TOP/admin/scripts/<SID> $INST_TOP/admin/scripts
LOG_HOME - $INST_TOP/logs
FORMS_WEB_CONFIG_FILE- $INST_TOP/ora/10.1.2/forms/server/appsweb.cfg
AF_JLIB - $COMMON_TOP/java/lib
JAVA_BASE - $COMMON_TOP/java
INST_TOP - $HOME/inst/apps/<CONTEXT>
ORA_CONFIG_HOME - $INST_TOP/ora
APPLCSF $COMMON_TOP/admin $LOG_HOME/appl/conc

Visit this link for more info about file systems in Oracle Apps.