Scribd
Upload
25 views51 pages

FND

This document summarizes an Oracle Human Resources generic payroll process run. It processed 2 payroll actions without errors for an assignment. The process calculated an air ticket benefit of $840 for the period by running various formulas to determine eligibility and rates based on employee data like family status and hire date.

Uploaded by

iceyroses
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
25 views51 pages

FND

This document summarizes an Oracle Human Resources generic payroll process run. It processed 2 payroll actions without errors for an assignment. The process calculated an air ticket benefit of $840 for the period by running various formulas to determine eligibility and rates based on employee data like family status and hire date.

Uploaded by

iceyroses
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 51

FND_ENTERPRISE_ID 1

new ENTERPRISE_ID 1

session_id F62761275299D36BE0530F65410AA545

Number Roles 17

Env Request Id = 29794764

===============================================================================

Oracle Human Resources Generic Process

Started at : 05-03-2023 13:14:54

Chunk Size : 20

Threads :1

Logging Category : FZ

Trace :N

Run Result Buffer Size : 100

Balance Buffer Size : 100

Element Entry Buffer Si: 500

Logging Area :

Assignment ID for Start:

Assignment ID for End o:

statistics group id 140378773355220

***** Processing Ass Id 300000116757083 Status 1

Loading Element Entries

Loading Latest Balances

Running Skip Formula 300000036194290

tFF Cxt : DATE_EARNED = 2023/03/31 00:00:00

8FF Cxt : ELEMENT_ENTRY_ID = 300000362990065

8FF Cxt : PAYROLL_ACTION_ID = 10896949

(GLBSKIP)EXECUTING SKIP FORMULA

(GLBSKIP) PAYROLL_ACTION_RUN_TYPE_SHORTNAME = REGULAR

(GLBSKIP) creator_type = F
(GLBSKIP -Classification = Information

skpFF Out : SKIP_FLAG = N

tFF Cxt : DATE_EARNED = 2023/03/31 00:00:00

tFF Cxt : EFFECTIVE_DATE = 2023/03/21 00:00:00

8FF Cxt : ENTRY_USAGE_ID = 14149244

8FF Cxt : LEGAL_EMPLOYER_ID = 300000114795806

8FF Cxt : LEGISLATIVE_DATA_GROUP_ID = 300000001554513

8FF Cxt : PAYROLL_ASSIGNMENT_ID = 300000116757146

8FF Cxt : PAYROLL_ID = 300000117010187

8FF Cxt : PERSON_ID = 100000069588398

FF Inp : CLASS_OF_TRAVEL = ECONOMY

FF Inp : DEPENDENTS_ELIGIBLE = Y

FF Inp : DESTINATION = TRIVANDRUM

FF Inp : FREQUENCY_OF_TRAVEL = ANNUAL

FF Inp : PAYING_MONTH = MAR

Running Formula 300000118204203, _AIR_TICKET_PROCESS

[AIR_TICKET_CALC] l_dependents_eligible Review --> Y

[AIR_TICKET_CALC] l_Frequency_Of_Travel Frequency -->

[AIR_TICKET_CALC] l_Frequency_Of_Travel Future_Use_5 --> X

[AIR_TICKET_CALC] new Future_Use_5 Entered -->

[AIR_TICKET_CALC] new Future_Use_5 --> X

[AIR_TICKET_CALC] new Future_Use_5l_Frequency_Of_Travel --> ANNUAL

[AIR_TICKET_CALC] l_Frequency_Of_Travel Review --> ANNUAL

[AIR_TICKET_CALC] l_Paying_Month Review --> MAR

[AIR_TICKET_CALC] l_months_factor Review1 --> 12

FT: Oracle Payroll calling FT Payroll Access to HR

FT: FFID 300000118204203 calling 300000008403487

[AIR_TICKET_CALC] L_UDT_NAME ---> BG_ _AIR_TICKET_RATES

[AIR_TICKET_CALC] Destination ---> TRIVANDRUM

[AIR_TICKET_CALC] Class_of_Travel ---> ECONOMY

[AIR_TICKET_CALC] Employee does ENTERED HERE 111 .....


[AIR_TICKET_CALC] Destination 111 ---> TRIVANDRUM

[AIR_TICKET_CALC] Class_of_Travel 111 ---> ECONOMY

[AIR_TICKET_CALC] l_destination TRIVANDRUM

[AIR_TICKET_CALC] l_class ECONOMY

[AIR_TICKET_CALC] l_override_ticket_fare 0

[AIR_TICKET_CALC] l_override_tot_air_ticket_amt 0

[AIR_TICKET_CALC] Emp Monthly Provision L_EMP_TKT_RATE 210

[AIR_TICKET_CALC] l_marital_status Review1 M

[AIR_TICKET_CALC] PER_PER_CONTACT_DAUGHTERS_COUNT Review1 0

[AIR_TICKET_CALC] PER_PER_CONTACT_SONS_COUNT Review1 0

[AIR_TICKET_CALC] L_W_COUNT Review1 1

[AIR_TICKET_CALC] L_C_COUNT Review1 0

[AIR_TICKET_CALC] Employee is married

ContacKt KTypeS

ContacKt KTypeIN_S

ContacKt KTypeIN_D

Contact TypeS

Contact TypeS

[AIR_TICKET_CALC] Spouse exists

[AIR_TICKET_CALC] l_spouse_ticket_rate : 210

[AIR_TICKET] L_C_COUNT for child exists --> 0

[AIR_TICKET] Entered into No. of Children1623, L_C_COUNT 0

Contact Type --> S

[AIR_TICKET] No. of Children123, L_C_COUNT --> 0

[AIR_TICKET] Entered into No. of Children1623, L_C_COUNT 0

Contact Type --> IN_S

[AIR_TICKET] l_child_name --> Darsan Manoj

[AIR_TICKET] l_child_dob --> 2005/05/24 00:00:00

[AIR_TICKET] No. of Children123, L_C_COUNT --> 1

[AIR_TICKET] Entered into No. of Children1623, L_C_COUNT 1

Contact Type --> IN_D


[AIR_TICKET] l_child_name --> Diya Manoj

[AIR_TICKET] l_child_dob --> 2009/01/02 00:00:00

[AIR_TICKET] No. of Children123, L_C_COUNT --> 2

[AIR_TICKET] No. of Children, L_C_COUNT --> 2

[AIR_TICKET] entered into DOB loop

[AIR_TICKET] entered into K DOB loop -->

[AIR_TICKET] entered into K value --> 1

[AIR_TICKET] l_Child_Count --> 2

[AIR_TICKET] entered into l_child_age

[AIR_TICKET] l_Child_Count_Test enered 2

[AIR_TICKET] l_child_age 17.8521505376344086021505376344086021505

[AIR_TICKET] l_entity_code SBS

[AIR_TICKET] l_ch_tkt_rate3 SBS 210

[AIR_TICKET] l_childl_ch_tkt_rate 210

[AIR_TICKET] l_ch_tkt_rate --> 210

[AIR_TICKET] l_child_tkt_rate total --> 210

[AIR_TICKET] l_child_age 14.24462365591397849462365591397849462367

[AIR_TICKET] l_entity_code SBS

[AIR_TICKET] l_ch_tkt_rate3 SBS 210

[AIR_TICKET] l_childl_ch_tkt_rate 210

[AIR_TICKET] l_ch_tkt_rate --> 210

[AIR_TICKET] l_child_tkt_rate total --> 420

[AIR_TICKET] l_dep_count - 1 --> 2

[AIR_TICKET] l_No_Of_Children_Elig - 1 --> 2

[AIR_TICKET] newl_total_pay --> 840

[AIR_TICKET] l_total_pay --> 840

[AIR_TICKET] L_total_provision --> 70

[AIR_TICKET] 1l_l_date1 2015/01/17 00:00:00

[AIR_TICKET] 1l_PAY_EARN_PERIOD_END 2023/03/31 00:00:00

[AIR_TICKET] 1l_l_hire_date 2015/01/17 00:00:00

[AIR_TICKET] 1l_latest_hire_date 2015/01/17 00:00:00


[AIR_TICKET] 1l_hire_date_yr_num 2015

[AIR_TICKET] 1l_hire_date_mth_num 1

[AIR_TICKET] 1l_hire_date_dd_num 17

[AIR_TICKET] 11l_hire_date_yr_days 2996

[AIR_TICKET] l_hire_date_dd_days 13

[AIR_TICKET] 1l_period_end_date 2023/03/31 00:00:00

[AIR_TICKET] 1l_term_date_diff -32277

[AIR_TICKET] 1l_pay_mth_diff 97.4516129032258064516129032258064516129

[AIR_TICKET] 1l_pay_days_diff 2995

[AIR_TICKET] 1l_pay_mth_diff_char 97

[AIR_TICKET] 1l_pay_mth_diff_num 97

[AIR_TICKET] l_hire_date_yr_num --> 2015

[AIR_TICKET] l_prd_yr_num --> 2023

[AIR_TICKET] l_prd_mth_num --> 3

[AIR_TICKET] ANNUAL CONDITION

[AIR_TICKET] new ANNUAL l_prd_mth_num --> 3

[AIR_TICKET] new ANNUAL l_Paying_Month_Num --> 3

[AIR_TICKET] Annual-4 l_pay_mths --> 12

[AIR_TICKET] new 0l_months_factor --> 12

[AIR_TICKET] new 0l_pay_mths --> 12

[AIR_TICKET] l_pay_mths --> 12

[AIR_TICKET] l_pay_factor --> 1

[AIR_TICKET] l_from_1date 2023/03/01 00:00:00

[AIR_TICKET] l_to_1date 2023/03/31 00:00:00

[AIR_TICKET] l_from_1date --> 2022/04/01 00:00:00

[AIR_TICKET] l_to_1date --> 2023/02/28 00:00:00

[AIR_TICKET] l_frm_1dt --> 2022/04/01

[AIR_TICKET] l_end_1dt --> 2023/02/28

[AIR_TICKET] l_from_2date 2022/04/01

[AIR_TICKET] l_to_2date 2023/02/28

[AIR_TICKET] l_valu1e
[AIR_TICKET] l_valu2e -->

[AIR_TICKET] l_manual_payout --> N

[AIR_TICKET] l_total_pay333 ---> 840

[AIR_TICKET] l_pay_factor333 ---> 1

[AIR_TICKET] l_pay_factor 0333 ---> 1

[AIR_TICKET] l_pay_factor 1333 ---> 1

[AIR_TICKET] l_total_pay 333 ---> 840

[AIR_TICKET] l_air_tckt_pay --> 840

[AIR_TICKET] 2l_latest_hire_date --> 2015/01/17 00:00:00

[AIR_TICKET] 2l_hire_date_yr_num --> 2015

[AIR_TICKET] 2l_hire_date_mth_num --> 1

[AIR_TICKET] 2l_hire_date_dd_num --> 17

[AIR_TICKET] 2l_period_hire_date --> 2024/01/17 00:00:00

[AIR_TICKET] 2l_prv_svc_anniversary --> 2023/01/17 00:00:00

[AIR_TICKET] 2l_period_end_date --> 2023/03/31 00:00:00

[AIR_TICKET] 2l_svc_anniversary --> 2024/01/17 00:00:00

FF Out : L_AIR_TCKT_PAY = 840

Indirect Result IV = 300000092013065 ET = 300000092013059

FF Out : L_EMP_TKT_RATE = 210

FF Out : L_FREQUENCY_OF_TRAVEL = ANNUAL

Direct Result

FF Out : L_PAYING_MONTH = MAR

FF Out : L_TOTAL_PAY = 840

FF Out : L_TOTAL_PROVISION = 70

Indirect Result IV = 300000091597248 ET = 300000091575329

Running Skip Formula 300000036194290

tFF Cxt : DATE_EARNED = 2023/03/31 00:00:00

8FF Cxt : ELEMENT_ENTRY_ID = 300000362990065

8FF Cxt : PAYROLL_ACTION_ID = 10896949

(GLBSKIP)EXECUTING SKIP FORMULA

(GLBSKIP) PAYROLL_ACTION_RUN_TYPE_SHORTNAME = REGULAR


(GLBSKIP) creator_type = F

(GLBSKIP -Classification = Information

skpFF Out : SKIP_FLAG = N

Running Skip Formula 300000000210968

tFF Cxt : DATE_EARNED = 2023/03/31 00:00:00

8FF Cxt : ELEMENT_ENTRY_ID = 300000362990065

8FF Cxt : PAYROLL_ACTION_ID = 10896949

8FF Cxt : PAYROLL_ASSIGNMENT_ID = 300000116757146

8FF Cxt : PAYROLL_ID = 300000117010187

8FF Cxt : PAYROLL_TERM_ID = 300000116757086

(GLBSKIP)EXECUTING SKIP FORMULA

(GLBSKIP) PAYROLL_ACTION_RUN_TYPE_SHORTNAME = REGULAR

(GLBSKIP) creator_type = F

(GLBSKIP -Classification = Information

skpFF Out : SKIP_FLAG = N

Ended processing at : 05-03-2023 13:14:55

Total Pay Relship count : 1

Total Action count :2

Successfully processed : 2

Skipped :0

Unprocessed :0

Errored :0

===============================================================================

-------------------------------------------------------------------------

PL/SQL Output

-------------------------------------------------------------------------

-------------------------------------------------------------------------

-------------------------------------------------------------------------

PL/SQL Output

-------------------------------------------------------------------------
-------------------------------------------------------------------------

+---------------------------------------------------------------------------+

UTIL-CURRENT TIME (DATE=05-MAR-2023) (TIME=13:14:55)

+---------------------------------------------------------------------------+FND_ENTERPRISE_ID 1

new ENTERPRISE_ID 1

session_id F62761275299D36BE0530F65410AA545

Number Roles 17

Env Request Id = 29794764

===============================================================================

Oracle Human Resources Generic Process

Started at : 05-03-2023 13:14:54

Chunk Size : 20

Threads :1

Logging Category : FZ

Trace :N

Run Result Buffer Size : 100

Balance Buffer Size : 100

Element Entry Buffer Si: 500

Logging Area :

Assignment ID for Start:

Assignment ID for End o:

statistics group id 140378773355220

***** Processing Ass Id 300000116757083 Status 1

Loading Element Entries

Loading Latest Balances

Running Skip Formula 300000036194290

tFF Cxt : DATE_EARNED = 2023/03/31 00:00:00


8FF Cxt : ELEMENT_ENTRY_ID = 300000362990065

8FF Cxt : PAYROLL_ACTION_ID = 10896949

(GLBSKIP)EXECUTING SKIP FORMULA

(GLBSKIP) PAYROLL_ACTION_RUN_TYPE_SHORTNAME = REGULAR

(GLBSKIP) creator_type = F

(GLBSKIP -Classification = Information

skpFF Out : SKIP_FLAG = N

tFF Cxt : DATE_EARNED = 2023/03/31 00:00:00

tFF Cxt : EFFECTIVE_DATE = 2023/03/21 00:00:00

8FF Cxt : ENTRY_USAGE_ID = 14149244

8FF Cxt : LEGAL_EMPLOYER_ID = 300000114795806

8FF Cxt : LEGISLATIVE_DATA_GROUP_ID = 300000001554513

8FF Cxt : PAYROLL_ASSIGNMENT_ID = 300000116757146

8FF Cxt : PAYROLL_ID = 300000117010187

8FF Cxt : PERSON_ID = 100000069588398

FF Inp : CLASS_OF_TRAVEL = ECONOMY

FF Inp : DEPENDENTS_ELIGIBLE = Y

FF Inp : DESTINATION = TRIVANDRUM

FF Inp : FREQUENCY_OF_TRAVEL = ANNUAL

FF Inp : PAYING_MONTH = MAR

Running Formula 300000118204203, _AIR_TICKET_PROCESS

[AIR_TICKET_CALC] l_dependents_eligible Review --> Y

[AIR_TICKET_CALC] l_Frequency_Of_Travel Frequency -->

[AIR_TICKET_CALC] l_Frequency_Of_Travel Future_Use_5 --> X

[AIR_TICKET_CALC] new Future_Use_5 Entered -->

[AIR_TICKET_CALC] new Future_Use_5 --> X

[AIR_TICKET_CALC] new Future_Use_5l_Frequency_Of_Travel --> ANNUAL

[AIR_TICKET_CALC] l_Frequency_Of_Travel Review --> ANNUAL

[AIR_TICKET_CALC] l_Paying_Month Review --> MAR

[AIR_TICKET_CALC] l_months_factor Review1 --> 12

FT: Oracle Payroll calling FT Payroll Access to HR


FT: FFID 300000118204203 calling 300000008403487

[AIR_TICKET_CALC] L_UDT_NAME ---> BG_ _AIR_TICKET_RATES

[AIR_TICKET_CALC] Destination ---> TRIVANDRUM

[AIR_TICKET_CALC] Class_of_Travel ---> ECONOMY

[AIR_TICKET_CALC] Employee does ENTERED HERE 111 .....

[AIR_TICKET_CALC] Destination 111 ---> TRIVANDRUM

[AIR_TICKET_CALC] Class_of_Travel 111 ---> ECONOMY

[AIR_TICKET_CALC] l_destination TRIVANDRUM

[AIR_TICKET_CALC] l_class ECONOMY

[AIR_TICKET_CALC] l_override_ticket_fare 0

[AIR_TICKET_CALC] l_override_tot_air_ticket_amt 0

[AIR_TICKET_CALC] Emp Monthly Provision L_EMP_TKT_RATE 210

[AIR_TICKET_CALC] l_marital_status Review1 M

[AIR_TICKET_CALC] PER_PER_CONTACT_DAUGHTERS_COUNT Review1 0

[AIR_TICKET_CALC] PER_PER_CONTACT_SONS_COUNT Review1 0

[AIR_TICKET_CALC] L_W_COUNT Review1 1

[AIR_TICKET_CALC] L_C_COUNT Review1 0

[AIR_TICKET_CALC] Employee is married

ContacKt KTypeS

ContacKt KTypeIN_S

ContacKt KTypeIN_D

Contact TypeS

Contact TypeS

[AIR_TICKET_CALC] Spouse exists

[AIR_TICKET_CALC] l_spouse_ticket_rate : 210

[AIR_TICKET] L_C_COUNT for child exists --> 0

[AIR_TICKET] Entered into No. of Children1623, L_C_COUNT 0

Contact Type --> S

[AIR_TICKET] No. of Children123, L_C_COUNT --> 0

[AIR_TICKET] Entered into No. of Children1623, L_C_COUNT 0

Contact Type --> IN_S


[AIR_TICKET] l_child_name --> Darsan Manoj

[AIR_TICKET] l_child_dob --> 2005/05/24 00:00:00

[AIR_TICKET] No. of Children123, L_C_COUNT --> 1

[AIR_TICKET] Entered into No. of Children1623, L_C_COUNT 1

Contact Type --> IN_D

[AIR_TICKET] l_child_name --> Diya Manoj

[AIR_TICKET] l_child_dob --> 2009/01/02 00:00:00

[AIR_TICKET] No. of Children123, L_C_COUNT --> 2

[AIR_TICKET] No. of Children, L_C_COUNT --> 2

[AIR_TICKET] entered into DOB loop

[AIR_TICKET] entered into K DOB loop -->

[AIR_TICKET] entered into K value --> 1

[AIR_TICKET] l_Child_Count --> 2

[AIR_TICKET] entered into l_child_age

[AIR_TICKET] l_Child_Count_Test enered 2

[AIR_TICKET] l_child_age 17.8521505376344086021505376344086021505

[AIR_TICKET] l_entity_code SBS

[AIR_TICKET] l_ch_tkt_rate3 SBS 210

[AIR_TICKET] l_childl_ch_tkt_rate 210

[AIR_TICKET] l_ch_tkt_rate --> 210

[AIR_TICKET] l_child_tkt_rate total --> 210

[AIR_TICKET] l_child_age 14.24462365591397849462365591397849462367

[AIR_TICKET] l_entity_code SBS

[AIR_TICKET] l_ch_tkt_rate3 SBS 210

[AIR_TICKET] l_childl_ch_tkt_rate 210

[AIR_TICKET] l_ch_tkt_rate --> 210

[AIR_TICKET] l_child_tkt_rate total --> 420

[AIR_TICKET] l_dep_count - 1 --> 2

[AIR_TICKET] l_No_Of_Children_Elig - 1 --> 2

[AIR_TICKET] newl_total_pay --> 840

[AIR_TICKET] l_total_pay --> 840


[AIR_TICKET] L_total_provision --> 70

[AIR_TICKET] 1l_l_date1 2015/01/17 00:00:00

[AIR_TICKET] 1l_PAY_EARN_PERIOD_END 2023/03/31 00:00:00

[AIR_TICKET] 1l_l_hire_date 2015/01/17 00:00:00

[AIR_TICKET] 1l_latest_hire_date 2015/01/17 00:00:00

[AIR_TICKET] 1l_hire_date_yr_num 2015

[AIR_TICKET] 1l_hire_date_mth_num 1

[AIR_TICKET] 1l_hire_date_dd_num 17

[AIR_TICKET] 11l_hire_date_yr_days 2996

[AIR_TICKET] l_hire_date_dd_days 13

[AIR_TICKET] 1l_period_end_date 2023/03/31 00:00:00

[AIR_TICKET] 1l_term_date_diff -32277

[AIR_TICKET] 1l_pay_mth_diff 97.4516129032258064516129032258064516129

[AIR_TICKET] 1l_pay_days_diff 2995

[AIR_TICKET] 1l_pay_mth_diff_char 97

[AIR_TICKET] 1l_pay_mth_diff_num 97

[AIR_TICKET] l_hire_date_yr_num --> 2015

[AIR_TICKET] l_prd_yr_num --> 2023

[AIR_TICKET] l_prd_mth_num --> 3

[AIR_TICKET] ANNUAL CONDITION

[AIR_TICKET] new ANNUAL l_prd_mth_num --> 3

[AIR_TICKET] new ANNUAL l_Paying_Month_Num --> 3

[AIR_TICKET] Annual-4 l_pay_mths --> 12

[AIR_TICKET] new 0l_months_factor --> 12

[AIR_TICKET] new 0l_pay_mths --> 12

[AIR_TICKET] l_pay_mths --> 12

[AIR_TICKET] l_pay_factor --> 1

[AIR_TICKET] l_from_1date 2023/03/01 00:00:00

[AIR_TICKET] l_to_1date 2023/03/31 00:00:00

[AIR_TICKET] l_from_1date --> 2022/04/01 00:00:00

[AIR_TICKET] l_to_1date --> 2023/02/28 00:00:00


[AIR_TICKET] l_frm_1dt --> 2022/04/01

[AIR_TICKET] l_end_1dt --> 2023/02/28

[AIR_TICKET] l_from_2date 2022/04/01

[AIR_TICKET] l_to_2date 2023/02/28

[AIR_TICKET] l_valu1e

[AIR_TICKET] l_valu2e -->

[AIR_TICKET] l_manual_payout --> N

[AIR_TICKET] l_total_pay333 ---> 840

[AIR_TICKET] l_pay_factor333 ---> 1

[AIR_TICKET] l_pay_factor 0333 ---> 1

[AIR_TICKET] l_pay_factor 1333 ---> 1

[AIR_TICKET] l_total_pay 333 ---> 840

[AIR_TICKET] l_air_tckt_pay --> 840

[AIR_TICKET] 2l_latest_hire_date --> 2015/01/17 00:00:00

[AIR_TICKET] 2l_hire_date_yr_num --> 2015

[AIR_TICKET] 2l_hire_date_mth_num --> 1

[AIR_TICKET] 2l_hire_date_dd_num --> 17

[AIR_TICKET] 2l_period_hire_date --> 2024/01/17 00:00:00

[AIR_TICKET] 2l_prv_svc_anniversary --> 2023/01/17 00:00:00

[AIR_TICKET] 2l_period_end_date --> 2023/03/31 00:00:00

[AIR_TICKET] 2l_svc_anniversary --> 2024/01/17 00:00:00

FF Out : L_AIR_TCKT_PAY = 840

Indirect Result IV = 300000092013065 ET = 300000092013059

FF Out : L_EMP_TKT_RATE = 210

FF Out : L_FREQUENCY_OF_TRAVEL = ANNUAL

Direct Result

FF Out : L_PAYING_MONTH = MAR

FF Out : L_TOTAL_PAY = 840

FF Out : L_TOTAL_PROVISION = 70

Indirect Result IV = 300000091597248 ET = 300000091575329

Running Skip Formula 300000036194290


tFF Cxt : DATE_EARNED = 2023/03/31 00:00:00

8FF Cxt : ELEMENT_ENTRY_ID = 300000362990065

8FF Cxt : PAYROLL_ACTION_ID = 10896949

(GLBSKIP)EXECUTING SKIP FORMULA

(GLBSKIP) PAYROLL_ACTION_RUN_TYPE_SHORTNAME = REGULAR

(GLBSKIP) creator_type = F

(GLBSKIP -Classification = Information

skpFF Out : SKIP_FLAG = N

Running Skip Formula 300000000210968

tFF Cxt : DATE_EARNED = 2023/03/31 00:00:00

8FF Cxt : ELEMENT_ENTRY_ID = 300000362990065

8FF Cxt : PAYROLL_ACTION_ID = 10896949

8FF Cxt : PAYROLL_ASSIGNMENT_ID = 300000116757146

8FF Cxt : PAYROLL_ID = 300000117010187

8FF Cxt : PAYROLL_TERM_ID = 300000116757086

(GLBSKIP)EXECUTING SKIP FORMULA

(GLBSKIP) PAYROLL_ACTION_RUN_TYPE_SHORTNAME = REGULAR

(GLBSKIP) creator_type = F

(GLBSKIP -Classification = Information

skpFF Out : SKIP_FLAG = N

Ended processing at : 05-03-2023 13:14:55

Total Pay Relship count : 1

Total Action count :2

Successfully processed : 2

Skipped :0

Unprocessed :0

Errored :0

===============================================================================

-------------------------------------------------------------------------

PL/SQL Output
-------------------------------------------------------------------------

-------------------------------------------------------------------------

-------------------------------------------------------------------------

PL/SQL Output

-------------------------------------------------------------------------

-------------------------------------------------------------------------

+---------------------------------------------------------------------------+

UTIL-CURRENT TIME (DATE=05-MAR-2023) (TIME=13:14:55)

+---------------------------------------------------------------------------+

FND_ENTERPRISE_ID 1

new ENTERPRISE_ID 1

session_id F62761275299D36BE0530F65410AA545

Number Roles 17

Env Request Id = 29794764

===============================================================================

Oracle Human Resources Generic Process

Started at : 05-03-2023 13:14:54

Chunk Size : 20

Threads :1

Logging Category : FZ

Trace :N

Run Result Buffer Size : 100

Balance Buffer Size : 100

Element Entry Buffer Si: 500

Logging Area :

Assignment ID for Start:

Assignment ID for End o:


statistics group id 140378773355220

***** Processing Ass Id 300000116757083 Status 1

Loading Element Entries

Loading Latest Balances

Running Skip Formula 300000036194290

tFF Cxt : DATE_EARNED = 2023/03/31 00:00:00

8FF Cxt : ELEMENT_ENTRY_ID = 300000362990065

8FF Cxt : PAYROLL_ACTION_ID = 10896949

(GLBSKIP)EXECUTING SKIP FORMULA

(GLBSKIP) PAYROLL_ACTION_RUN_TYPE_SHORTNAME = REGULAR

(GLBSKIP) creator_type = F

(GLBSKIP -Classification = Information

skpFF Out : SKIP_FLAG = N

tFF Cxt : DATE_EARNED = 2023/03/31 00:00:00

tFF Cxt : EFFECTIVE_DATE = 2023/03/21 00:00:00

8FF Cxt : ENTRY_USAGE_ID = 14149244

8FF Cxt : LEGAL_EMPLOYER_ID = 300000114795806

8FF Cxt : LEGISLATIVE_DATA_GROUP_ID = 300000001554513

8FF Cxt : PAYROLL_ASSIGNMENT_ID = 300000116757146

8FF Cxt : PAYROLL_ID = 300000117010187

8FF Cxt : PERSON_ID = 100000069588398

FF Inp : CLASS_OF_TRAVEL = ECONOMY

FF Inp : DEPENDENTS_ELIGIBLE = Y

FF Inp : DESTINATION = TRIVANDRUM

FF Inp : FREQUENCY_OF_TRAVEL = ANNUAL

FF Inp : PAYING_MONTH = MAR

Running Formula 300000118204203, _AIR_TICKET_PROCESS

[AIR_TICKET_CALC] l_dependents_eligible Review --> Y

[AIR_TICKET_CALC] l_Frequency_Of_Travel Frequency -->

[AIR_TICKET_CALC] l_Frequency_Of_Travel Future_Use_5 --> X

[AIR_TICKET_CALC] new Future_Use_5 Entered -->


[AIR_TICKET_CALC] new Future_Use_5 --> X

[AIR_TICKET_CALC] new Future_Use_5l_Frequency_Of_Travel --> ANNUAL

[AIR_TICKET_CALC] l_Frequency_Of_Travel Review --> ANNUAL

[AIR_TICKET_CALC] l_Paying_Month Review --> MAR

[AIR_TICKET_CALC] l_months_factor Review1 --> 12

FT: Oracle Payroll calling FT Payroll Access to HR

FT: FFID 300000118204203 calling 300000008403487

[AIR_TICKET_CALC] L_UDT_NAME ---> BG_ _AIR_TICKET_RATES

[AIR_TICKET_CALC] Destination ---> TRIVANDRUM

[AIR_TICKET_CALC] Class_of_Travel ---> ECONOMY

[AIR_TICKET_CALC] Employee does ENTERED HERE 111 .....

[AIR_TICKET_CALC] Destination 111 ---> TRIVANDRUM

[AIR_TICKET_CALC] Class_of_Travel 111 ---> ECONOMY

[AIR_TICKET_CALC] l_destination TRIVANDRUM

[AIR_TICKET_CALC] l_class ECONOMY

[AIR_TICKET_CALC] l_override_ticket_fare 0

[AIR_TICKET_CALC] l_override_tot_air_ticket_amt 0

[AIR_TICKET_CALC] Emp Monthly Provision L_EMP_TKT_RATE 210

[AIR_TICKET_CALC] l_marital_status Review1 M

[AIR_TICKET_CALC] PER_PER_CONTACT_DAUGHTERS_COUNT Review1 0

[AIR_TICKET_CALC] PER_PER_CONTACT_SONS_COUNT Review1 0

[AIR_TICKET_CALC] L_W_COUNT Review1 1

[AIR_TICKET_CALC] L_C_COUNT Review1 0

[AIR_TICKET_CALC] Employee is married

ContacKt KTypeS

ContacKt KTypeIN_S

ContacKt KTypeIN_D

Contact TypeS

Contact TypeS

[AIR_TICKET_CALC] Spouse exists

[AIR_TICKET_CALC] l_spouse_ticket_rate : 210


[AIR_TICKET] L_C_COUNT for child exists --> 0

[AIR_TICKET] Entered into No. of Children1623, L_C_COUNT 0

Contact Type --> S

[AIR_TICKET] No. of Children123, L_C_COUNT --> 0

[AIR_TICKET] Entered into No. of Children1623, L_C_COUNT 0

Contact Type --> IN_S

[AIR_TICKET] l_child_name --> Darsan Manoj

[AIR_TICKET] l_child_dob --> 2005/05/24 00:00:00

[AIR_TICKET] No. of Children123, L_C_COUNT --> 1

[AIR_TICKET] Entered into No. of Children1623, L_C_COUNT 1

Contact Type --> IN_D

[AIR_TICKET] l_child_name --> Diya Manoj

[AIR_TICKET] l_child_dob --> 2009/01/02 00:00:00

[AIR_TICKET] No. of Children123, L_C_COUNT --> 2

[AIR_TICKET] No. of Children, L_C_COUNT --> 2

[AIR_TICKET] entered into DOB loop

[AIR_TICKET] entered into K DOB loop -->

[AIR_TICKET] entered into K value --> 1

[AIR_TICKET] l_Child_Count --> 2

[AIR_TICKET] entered into l_child_age

[AIR_TICKET] l_Child_Count_Test enered 2

[AIR_TICKET] l_child_age 17.8521505376344086021505376344086021505

[AIR_TICKET] l_entity_code SBS

[AIR_TICKET] l_ch_tkt_rate3 SBS 210

[AIR_TICKET] l_childl_ch_tkt_rate 210

[AIR_TICKET] l_ch_tkt_rate --> 210

[AIR_TICKET] l_child_tkt_rate total --> 210

[AIR_TICKET] l_child_age 14.24462365591397849462365591397849462367

[AIR_TICKET] l_entity_code SBS

[AIR_TICKET] l_ch_tkt_rate3 SBS 210

[AIR_TICKET] l_childl_ch_tkt_rate 210


[AIR_TICKET] l_ch_tkt_rate --> 210

[AIR_TICKET] l_child_tkt_rate total --> 420

[AIR_TICKET] l_dep_count - 1 --> 2

[AIR_TICKET] l_No_Of_Children_Elig - 1 --> 2

[AIR_TICKET] newl_total_pay --> 840

[AIR_TICKET] l_total_pay --> 840

[AIR_TICKET] L_total_provision --> 70

[AIR_TICKET] 1l_l_date1 2015/01/17 00:00:00

[AIR_TICKET] 1l_PAY_EARN_PERIOD_END 2023/03/31 00:00:00

[AIR_TICKET] 1l_l_hire_date 2015/01/17 00:00:00

[AIR_TICKET] 1l_latest_hire_date 2015/01/17 00:00:00

[AIR_TICKET] 1l_hire_date_yr_num 2015

[AIR_TICKET] 1l_hire_date_mth_num 1

[AIR_TICKET] 1l_hire_date_dd_num 17

[AIR_TICKET] 11l_hire_date_yr_days 2996

[AIR_TICKET] l_hire_date_dd_days 13

[AIR_TICKET] 1l_period_end_date 2023/03/31 00:00:00

[AIR_TICKET] 1l_term_date_diff -32277

[AIR_TICKET] 1l_pay_mth_diff 97.4516129032258064516129032258064516129

[AIR_TICKET] 1l_pay_days_diff 2995

[AIR_TICKET] 1l_pay_mth_diff_char 97

[AIR_TICKET] 1l_pay_mth_diff_num 97

[AIR_TICKET] l_hire_date_yr_num --> 2015

[AIR_TICKET] l_prd_yr_num --> 2023

[AIR_TICKET] l_prd_mth_num --> 3

[AIR_TICKET] ANNUAL CONDITION

[AIR_TICKET] new ANNUAL l_prd_mth_num --> 3

[AIR_TICKET] new ANNUAL l_Paying_Month_Num --> 3

[AIR_TICKET] Annual-4 l_pay_mths --> 12

[AIR_TICKET] new 0l_months_factor --> 12

[AIR_TICKET] new 0l_pay_mths --> 12


[AIR_TICKET] l_pay_mths --> 12

[AIR_TICKET] l_pay_factor --> 1

[AIR_TICKET] l_from_1date 2023/03/01 00:00:00

[AIR_TICKET] l_to_1date 2023/03/31 00:00:00

[AIR_TICKET] l_from_1date --> 2022/04/01 00:00:00

[AIR_TICKET] l_to_1date --> 2023/02/28 00:00:00

[AIR_TICKET] l_frm_1dt --> 2022/04/01

[AIR_TICKET] l_end_1dt --> 2023/02/28

[AIR_TICKET] l_from_2date 2022/04/01

[AIR_TICKET] l_to_2date 2023/02/28

[AIR_TICKET] l_valu1e

[AIR_TICKET] l_valu2e -->

[AIR_TICKET] l_manual_payout --> N

[AIR_TICKET] l_total_pay333 ---> 840

[AIR_TICKET] l_pay_factor333 ---> 1

[AIR_TICKET] l_pay_factor 0333 ---> 1

[AIR_TICKET] l_pay_factor 1333 ---> 1

[AIR_TICKET] l_total_pay 333 ---> 840

[AIR_TICKET] l_air_tckt_pay --> 840

[AIR_TICKET] 2l_latest_hire_date --> 2015/01/17 00:00:00

[AIR_TICKET] 2l_hire_date_yr_num --> 2015

[AIR_TICKET] 2l_hire_date_mth_num --> 1

[AIR_TICKET] 2l_hire_date_dd_num --> 17

[AIR_TICKET] 2l_period_hire_date --> 2024/01/17 00:00:00

[AIR_TICKET] 2l_prv_svc_anniversary --> 2023/01/17 00:00:00

[AIR_TICKET] 2l_period_end_date --> 2023/03/31 00:00:00

[AIR_TICKET] 2l_svc_anniversary --> 2024/01/17 00:00:00

FF Out : L_AIR_TCKT_PAY = 840

Indirect Result IV = 300000092013065 ET = 300000092013059

FF Out : L_EMP_TKT_RATE = 210

FF Out : L_FREQUENCY_OF_TRAVEL = ANNUAL


Direct Result

FF Out : L_PAYING_MONTH = MAR

FF Out : L_TOTAL_PAY = 840

FF Out : L_TOTAL_PROVISION = 70

Indirect Result IV = 300000091597248 ET = 300000091575329

Running Skip Formula 300000036194290

tFF Cxt : DATE_EARNED = 2023/03/31 00:00:00

8FF Cxt : ELEMENT_ENTRY_ID = 300000362990065

8FF Cxt : PAYROLL_ACTION_ID = 10896949

(GLBSKIP)EXECUTING SKIP FORMULA

(GLBSKIP) PAYROLL_ACTION_RUN_TYPE_SHORTNAME = REGULAR

(GLBSKIP) creator_type = F

(GLBSKIP -Classification = Information

skpFF Out : SKIP_FLAG = N

Running Skip Formula 300000000210968

tFF Cxt : DATE_EARNED = 2023/03/31 00:00:00

8FF Cxt : ELEMENT_ENTRY_ID = 300000362990065

8FF Cxt : PAYROLL_ACTION_ID = 10896949

8FF Cxt : PAYROLL_ASSIGNMENT_ID = 300000116757146

8FF Cxt : PAYROLL_ID = 300000117010187

8FF Cxt : PAYROLL_TERM_ID = 300000116757086

(GLBSKIP)EXECUTING SKIP FORMULA

(GLBSKIP) PAYROLL_ACTION_RUN_TYPE_SHORTNAME = REGULAR

(GLBSKIP) creator_type = F

(GLBSKIP -Classification = Information

skpFF Out : SKIP_FLAG = N

Ended processing at : 05-03-2023 13:14:55

Total Pay Relship count : 1

Total Action count :2

Successfully processed : 2
Skipped :0

Unprocessed :0

Errored :0

===============================================================================

-------------------------------------------------------------------------

PL/SQL Output

-------------------------------------------------------------------------

-------------------------------------------------------------------------

-------------------------------------------------------------------------

PL/SQL Output

-------------------------------------------------------------------------

-------------------------------------------------------------------------

+---------------------------------------------------------------------------+

UTIL-CURRENT TIME (DATE=05-MAR-2023) (TIME=13:14:55)

+---------------------------------------------------------------------------+

FND_ENTERPRISE_ID 1

new ENTERPRISE_ID 1

session_id F62761275299D36BE0530F65410AA545

Number Roles 17

Env Request Id = 29794764

===============================================================================

Oracle Human Resources Generic Process

Started at : 05-03-2023 13:14:54

Chunk Size : 20

Threads :1

Logging Category : FZ

Trace :N

Run Result Buffer Size : 100


Balance Buffer Size : 100

Element Entry Buffer Si: 500

Logging Area :

Assignment ID for Start:

Assignment ID for End o:

statistics group id 140378773355220

***** Processing Ass Id 300000116757083 Status 1

Loading Element Entries

Loading Latest Balances

Running Skip Formula 300000036194290

tFF Cxt : DATE_EARNED = 2023/03/31 00:00:00

8FF Cxt : ELEMENT_ENTRY_ID = 300000362990065

8FF Cxt : PAYROLL_ACTION_ID = 10896949

(GLBSKIP)EXECUTING SKIP FORMULA

(GLBSKIP) PAYROLL_ACTION_RUN_TYPE_SHORTNAME = REGULAR

(GLBSKIP) creator_type = F

(GLBSKIP -Classification = Information

skpFF Out : SKIP_FLAG = N

tFF Cxt : DATE_EARNED = 2023/03/31 00:00:00

tFF Cxt : EFFECTIVE_DATE = 2023/03/21 00:00:00

8FF Cxt : ENTRY_USAGE_ID = 14149244

8FF Cxt : LEGAL_EMPLOYER_ID = 300000114795806

8FF Cxt : LEGISLATIVE_DATA_GROUP_ID = 300000001554513

8FF Cxt : PAYROLL_ASSIGNMENT_ID = 300000116757146

8FF Cxt : PAYROLL_ID = 300000117010187

8FF Cxt : PERSON_ID = 100000069588398

FF Inp : CLASS_OF_TRAVEL = ECONOMY

FF Inp : DEPENDENTS_ELIGIBLE = Y

FF Inp : DESTINATION = TRIVANDRUM

FF Inp : FREQUENCY_OF_TRAVEL = ANNUAL


FF Inp : PAYING_MONTH = MAR

Running Formula 300000118204203, _AIR_TICKET_PROCESS

[AIR_TICKET_CALC] l_dependents_eligible Review --> Y

[AIR_TICKET_CALC] l_Frequency_Of_Travel Frequency -->

[AIR_TICKET_CALC] l_Frequency_Of_Travel Future_Use_5 --> X

[AIR_TICKET_CALC] new Future_Use_5 Entered -->

[AIR_TICKET_CALC] new Future_Use_5 --> X

[AIR_TICKET_CALC] new Future_Use_5l_Frequency_Of_Travel --> ANNUAL

[AIR_TICKET_CALC] l_Frequency_Of_Travel Review --> ANNUAL

[AIR_TICKET_CALC] l_Paying_Month Review --> MAR

[AIR_TICKET_CALC] l_months_factor Review1 --> 12

FT: Oracle Payroll calling FT Payroll Access to HR

FT: FFID 300000118204203 calling 300000008403487

[AIR_TICKET_CALC] L_UDT_NAME ---> BG_ _AIR_TICKET_RATES

[AIR_TICKET_CALC] Destination ---> TRIVANDRUM

[AIR_TICKET_CALC] Class_of_Travel ---> ECONOMY

[AIR_TICKET_CALC] Employee does ENTERED HERE 111 .....

[AIR_TICKET_CALC] Destination 111 ---> TRIVANDRUM

[AIR_TICKET_CALC] Class_of_Travel 111 ---> ECONOMY

[AIR_TICKET_CALC] l_destination TRIVANDRUM

[AIR_TICKET_CALC] l_class ECONOMY

[AIR_TICKET_CALC] l_override_ticket_fare 0

[AIR_TICKET_CALC] l_override_tot_air_ticket_amt 0

[AIR_TICKET_CALC] Emp Monthly Provision L_EMP_TKT_RATE 210

[AIR_TICKET_CALC] l_marital_status Review1 M

[AIR_TICKET_CALC] PER_PER_CONTACT_DAUGHTERS_COUNT Review1 0

[AIR_TICKET_CALC] PER_PER_CONTACT_SONS_COUNT Review1 0

[AIR_TICKET_CALC] L_W_COUNT Review1 1

[AIR_TICKET_CALC] L_C_COUNT Review1 0

[AIR_TICKET_CALC] Employee is married

ContacKt KTypeS
ContacKt KTypeIN_S

ContacKt KTypeIN_D

Contact TypeS

Contact TypeS

[AIR_TICKET_CALC] Spouse exists

[AIR_TICKET_CALC] l_spouse_ticket_rate : 210

[AIR_TICKET] L_C_COUNT for child exists --> 0

[AIR_TICKET] Entered into No. of Children1623, L_C_COUNT 0

Contact Type --> S

[AIR_TICKET] No. of Children123, L_C_COUNT --> 0

[AIR_TICKET] Entered into No. of Children1623, L_C_COUNT 0

Contact Type --> IN_S

[AIR_TICKET] l_child_name --> Darsan Manoj

[AIR_TICKET] l_child_dob --> 2005/05/24 00:00:00

[AIR_TICKET] No. of Children123, L_C_COUNT --> 1

[AIR_TICKET] Entered into No. of Children1623, L_C_COUNT 1

Contact Type --> IN_D

[AIR_TICKET] l_child_name --> Diya Manoj

[AIR_TICKET] l_child_dob --> 2009/01/02 00:00:00

[AIR_TICKET] No. of Children123, L_C_COUNT --> 2

[AIR_TICKET] No. of Children, L_C_COUNT --> 2

[AIR_TICKET] entered into DOB loop

[AIR_TICKET] entered into K DOB loop -->

[AIR_TICKET] entered into K value --> 1

[AIR_TICKET] l_Child_Count --> 2

[AIR_TICKET] entered into l_child_age

[AIR_TICKET] l_Child_Count_Test enered 2

[AIR_TICKET] l_child_age 17.8521505376344086021505376344086021505

[AIR_TICKET] l_entity_code SBS

[AIR_TICKET] l_ch_tkt_rate3 SBS 210

[AIR_TICKET] l_childl_ch_tkt_rate 210


[AIR_TICKET] l_ch_tkt_rate --> 210

[AIR_TICKET] l_child_tkt_rate total --> 210

[AIR_TICKET] l_child_age 14.24462365591397849462365591397849462367

[AIR_TICKET] l_entity_code SBS

[AIR_TICKET] l_ch_tkt_rate3 SBS 210

[AIR_TICKET] l_childl_ch_tkt_rate 210

[AIR_TICKET] l_ch_tkt_rate --> 210

[AIR_TICKET] l_child_tkt_rate total --> 420

[AIR_TICKET] l_dep_count - 1 --> 2

[AIR_TICKET] l_No_Of_Children_Elig - 1 --> 2

[AIR_TICKET] newl_total_pay --> 840

[AIR_TICKET] l_total_pay --> 840

[AIR_TICKET] L_total_provision --> 70

[AIR_TICKET] 1l_l_date1 2015/01/17 00:00:00

[AIR_TICKET] 1l_PAY_EARN_PERIOD_END 2023/03/31 00:00:00

[AIR_TICKET] 1l_l_hire_date 2015/01/17 00:00:00

[AIR_TICKET] 1l_latest_hire_date 2015/01/17 00:00:00

[AIR_TICKET] 1l_hire_date_yr_num 2015

[AIR_TICKET] 1l_hire_date_mth_num 1

[AIR_TICKET] 1l_hire_date_dd_num 17

[AIR_TICKET] 11l_hire_date_yr_days 2996

[AIR_TICKET] l_hire_date_dd_days 13

[AIR_TICKET] 1l_period_end_date 2023/03/31 00:00:00

[AIR_TICKET] 1l_term_date_diff -32277

[AIR_TICKET] 1l_pay_mth_diff 97.4516129032258064516129032258064516129

[AIR_TICKET] 1l_pay_days_diff 2995

[AIR_TICKET] 1l_pay_mth_diff_char 97

[AIR_TICKET] 1l_pay_mth_diff_num 97

[AIR_TICKET] l_hire_date_yr_num --> 2015

[AIR_TICKET] l_prd_yr_num --> 2023

[AIR_TICKET] l_prd_mth_num --> 3


[AIR_TICKET] ANNUAL CONDITION

[AIR_TICKET] new ANNUAL l_prd_mth_num --> 3

[AIR_TICKET] new ANNUAL l_Paying_Month_Num --> 3

[AIR_TICKET] Annual-4 l_pay_mths --> 12

[AIR_TICKET] new 0l_months_factor --> 12

[AIR_TICKET] new 0l_pay_mths --> 12

[AIR_TICKET] l_pay_mths --> 12

[AIR_TICKET] l_pay_factor --> 1

[AIR_TICKET] l_from_1date 2023/03/01 00:00:00

[AIR_TICKET] l_to_1date 2023/03/31 00:00:00

[AIR_TICKET] l_from_1date --> 2022/04/01 00:00:00

[AIR_TICKET] l_to_1date --> 2023/02/28 00:00:00

[AIR_TICKET] l_frm_1dt --> 2022/04/01

[AIR_TICKET] l_end_1dt --> 2023/02/28

[AIR_TICKET] l_from_2date 2022/04/01

[AIR_TICKET] l_to_2date 2023/02/28

[AIR_TICKET] l_valu1e

[AIR_TICKET] l_valu2e -->

[AIR_TICKET] l_manual_payout --> N

[AIR_TICKET] l_total_pay333 ---> 840

[AIR_TICKET] l_pay_factor333 ---> 1

[AIR_TICKET] l_pay_factor 0333 ---> 1

[AIR_TICKET] l_pay_factor 1333 ---> 1

[AIR_TICKET] l_total_pay 333 ---> 840

[AIR_TICKET] l_air_tckt_pay --> 840

[AIR_TICKET] 2l_latest_hire_date --> 2015/01/17 00:00:00

[AIR_TICKET] 2l_hire_date_yr_num --> 2015

[AIR_TICKET] 2l_hire_date_mth_num --> 1

[AIR_TICKET] 2l_hire_date_dd_num --> 17

[AIR_TICKET] 2l_period_hire_date --> 2024/01/17 00:00:00

[AIR_TICKET] 2l_prv_svc_anniversary --> 2023/01/17 00:00:00


[AIR_TICKET] 2l_period_end_date --> 2023/03/31 00:00:00

[AIR_TICKET] 2l_svc_anniversary --> 2024/01/17 00:00:00

FF Out : L_AIR_TCKT_PAY = 840

Indirect Result IV = 300000092013065 ET = 300000092013059

FF Out : L_EMP_TKT_RATE = 210

FF Out : L_FREQUENCY_OF_TRAVEL = ANNUAL

Direct Result

FF Out : L_PAYING_MONTH = MAR

FF Out : L_TOTAL_PAY = 840

FF Out : L_TOTAL_PROVISION = 70

Indirect Result IV = 300000091597248 ET = 300000091575329

Running Skip Formula 300000036194290

tFF Cxt : DATE_EARNED = 2023/03/31 00:00:00

8FF Cxt : ELEMENT_ENTRY_ID = 300000362990065

8FF Cxt : PAYROLL_ACTION_ID = 10896949

(GLBSKIP)EXECUTING SKIP FORMULA

(GLBSKIP) PAYROLL_ACTION_RUN_TYPE_SHORTNAME = REGULAR

(GLBSKIP) creator_type = F

(GLBSKIP -Classification = Information

skpFF Out : SKIP_FLAG = N

Running Skip Formula 300000000210968

tFF Cxt : DATE_EARNED = 2023/03/31 00:00:00

8FF Cxt : ELEMENT_ENTRY_ID = 300000362990065

8FF Cxt : PAYROLL_ACTION_ID = 10896949

8FF Cxt : PAYROLL_ASSIGNMENT_ID = 300000116757146

8FF Cxt : PAYROLL_ID = 300000117010187

8FF Cxt : PAYROLL_TERM_ID = 300000116757086

(GLBSKIP)EXECUTING SKIP FORMULA

(GLBSKIP) PAYROLL_ACTION_RUN_TYPE_SHORTNAME = REGULAR

(GLBSKIP) creator_type = F

(GLBSKIP -Classification = Information


skpFF Out : SKIP_FLAG = N

Ended processing at : 05-03-2023 13:14:55

Total Pay Relship count : 1

Total Action count :2

Successfully processed : 2

Skipped :0

Unprocessed :0

Errored :0

===============================================================================

-------------------------------------------------------------------------

PL/SQL Output

-------------------------------------------------------------------------

-------------------------------------------------------------------------

-------------------------------------------------------------------------

PL/SQL Output

-------------------------------------------------------------------------

-------------------------------------------------------------------------

+---------------------------------------------------------------------------+

UTIL-CURRENT TIME (DATE=05-MAR-2023) (TIME=13:14:55)

+---------------------------------------------------------------------------+

FND_ENTERPRISE_ID 1

new ENTERPRISE_ID 1

session_id F62761275299D36BE0530F65410AA545

Number Roles 17

Env Request Id = 29794764

===============================================================================

Oracle Human Resources Generic Process


Started at : 05-03-2023 13:14:54

Chunk Size : 20

Threads :1

Logging Category : FZ

Trace :N

Run Result Buffer Size : 100

Balance Buffer Size : 100

Element Entry Buffer Si: 500

Logging Area :

Assignment ID for Start:

Assignment ID for End o:

statistics group id 140378773355220

***** Processing Ass Id 300000116757083 Status 1

Loading Element Entries

Loading Latest Balances

Running Skip Formula 300000036194290

tFF Cxt : DATE_EARNED = 2023/03/31 00:00:00

8FF Cxt : ELEMENT_ENTRY_ID = 300000362990065

8FF Cxt : PAYROLL_ACTION_ID = 10896949

(GLBSKIP)EXECUTING SKIP FORMULA

(GLBSKIP) PAYROLL_ACTION_RUN_TYPE_SHORTNAME = REGULAR

(GLBSKIP) creator_type = F

(GLBSKIP -Classification = Information

skpFF Out : SKIP_FLAG = N

tFF Cxt : DATE_EARNED = 2023/03/31 00:00:00

tFF Cxt : EFFECTIVE_DATE = 2023/03/21 00:00:00

8FF Cxt : ENTRY_USAGE_ID = 14149244

8FF Cxt : LEGAL_EMPLOYER_ID = 300000114795806

8FF Cxt : LEGISLATIVE_DATA_GROUP_ID = 300000001554513

8FF Cxt : PAYROLL_ASSIGNMENT_ID = 300000116757146


8FF Cxt : PAYROLL_ID = 300000117010187

8FF Cxt : PERSON_ID = 100000069588398

FF Inp : CLASS_OF_TRAVEL = ECONOMY

FF Inp : DEPENDENTS_ELIGIBLE = Y

FF Inp : DESTINATION = TRIVANDRUM

FF Inp : FREQUENCY_OF_TRAVEL = ANNUAL

FF Inp : PAYING_MONTH = MAR

Running Formula 300000118204203, _AIR_TICKET_PROCESS

[AIR_TICKET_CALC] l_dependents_eligible Review --> Y

[AIR_TICKET_CALC] l_Frequency_Of_Travel Frequency -->

[AIR_TICKET_CALC] l_Frequency_Of_Travel Future_Use_5 --> X

[AIR_TICKET_CALC] new Future_Use_5 Entered -->

[AIR_TICKET_CALC] new Future_Use_5 --> X

[AIR_TICKET_CALC] new Future_Use_5l_Frequency_Of_Travel --> ANNUAL

[AIR_TICKET_CALC] l_Frequency_Of_Travel Review --> ANNUAL

[AIR_TICKET_CALC] l_Paying_Month Review --> MAR

[AIR_TICKET_CALC] l_months_factor Review1 --> 12

FT: Oracle Payroll calling FT Payroll Access to HR

FT: FFID 300000118204203 calling 300000008403487

[AIR_TICKET_CALC] L_UDT_NAME ---> BG_ _AIR_TICKET_RATES

[AIR_TICKET_CALC] Destination ---> TRIVANDRUM

[AIR_TICKET_CALC] Class_of_Travel ---> ECONOMY

[AIR_TICKET_CALC] Employee does ENTERED HERE 111 .....

[AIR_TICKET_CALC] Destination 111 ---> TRIVANDRUM

[AIR_TICKET_CALC] Class_of_Travel 111 ---> ECONOMY

[AIR_TICKET_CALC] l_destination TRIVANDRUM

[AIR_TICKET_CALC] l_class ECONOMY

[AIR_TICKET_CALC] l_override_ticket_fare 0

[AIR_TICKET_CALC] l_override_tot_air_ticket_amt 0

[AIR_TICKET_CALC] Emp Monthly Provision L_EMP_TKT_RATE 210

[AIR_TICKET_CALC] l_marital_status Review1 M


[AIR_TICKET_CALC] PER_PER_CONTACT_DAUGHTERS_COUNT Review1 0

[AIR_TICKET_CALC] PER_PER_CONTACT_SONS_COUNT Review1 0

[AIR_TICKET_CALC] L_W_COUNT Review1 1

[AIR_TICKET_CALC] L_C_COUNT Review1 0

[AIR_TICKET_CALC] Employee is married

ContacKt KTypeS

ContacKt KTypeIN_S

ContacKt KTypeIN_D

Contact TypeS

Contact TypeS

[AIR_TICKET_CALC] Spouse exists

[AIR_TICKET_CALC] l_spouse_ticket_rate : 210

[AIR_TICKET] L_C_COUNT for child exists --> 0

[AIR_TICKET] Entered into No. of Children1623, L_C_COUNT 0

Contact Type --> S

[AIR_TICKET] No. of Children123, L_C_COUNT --> 0

[AIR_TICKET] Entered into No. of Children1623, L_C_COUNT 0

Contact Type --> IN_S

[AIR_TICKET] l_child_name --> Darsan Manoj

[AIR_TICKET] l_child_dob --> 2005/05/24 00:00:00

[AIR_TICKET] No. of Children123, L_C_COUNT --> 1

[AIR_TICKET] Entered into No. of Children1623, L_C_COUNT 1

Contact Type --> IN_D

[AIR_TICKET] l_child_name --> Diya Manoj

[AIR_TICKET] l_child_dob --> 2009/01/02 00:00:00

[AIR_TICKET] No. of Children123, L_C_COUNT --> 2

[AIR_TICKET] No. of Children, L_C_COUNT --> 2

[AIR_TICKET] entered into DOB loop

[AIR_TICKET] entered into K DOB loop -->

[AIR_TICKET] entered into K value --> 1

[AIR_TICKET] l_Child_Count --> 2


[AIR_TICKET] entered into l_child_age

[AIR_TICKET] l_Child_Count_Test enered 2

[AIR_TICKET] l_child_age 17.8521505376344086021505376344086021505

[AIR_TICKET] l_entity_code SBS

[AIR_TICKET] l_ch_tkt_rate3 SBS 210

[AIR_TICKET] l_childl_ch_tkt_rate 210

[AIR_TICKET] l_ch_tkt_rate --> 210

[AIR_TICKET] l_child_tkt_rate total --> 210

[AIR_TICKET] l_child_age 14.24462365591397849462365591397849462367

[AIR_TICKET] l_entity_code SBS

[AIR_TICKET] l_ch_tkt_rate3 SBS 210

[AIR_TICKET] l_childl_ch_tkt_rate 210

[AIR_TICKET] l_ch_tkt_rate --> 210

[AIR_TICKET] l_child_tkt_rate total --> 420

[AIR_TICKET] l_dep_count - 1 --> 2

[AIR_TICKET] l_No_Of_Children_Elig - 1 --> 2

[AIR_TICKET] newl_total_pay --> 840

[AIR_TICKET] l_total_pay --> 840

[AIR_TICKET] L_total_provision --> 70

[AIR_TICKET] 1l_l_date1 2015/01/17 00:00:00

[AIR_TICKET] 1l_PAY_EARN_PERIOD_END 2023/03/31 00:00:00

[AIR_TICKET] 1l_l_hire_date 2015/01/17 00:00:00

[AIR_TICKET] 1l_latest_hire_date 2015/01/17 00:00:00

[AIR_TICKET] 1l_hire_date_yr_num 2015

[AIR_TICKET] 1l_hire_date_mth_num 1

[AIR_TICKET] 1l_hire_date_dd_num 17

[AIR_TICKET] 11l_hire_date_yr_days 2996

[AIR_TICKET] l_hire_date_dd_days 13

[AIR_TICKET] 1l_period_end_date 2023/03/31 00:00:00

[AIR_TICKET] 1l_term_date_diff -32277

[AIR_TICKET] 1l_pay_mth_diff 97.4516129032258064516129032258064516129


[AIR_TICKET] 1l_pay_days_diff 2995

[AIR_TICKET] 1l_pay_mth_diff_char 97

[AIR_TICKET] 1l_pay_mth_diff_num 97

[AIR_TICKET] l_hire_date_yr_num --> 2015

[AIR_TICKET] l_prd_yr_num --> 2023

[AIR_TICKET] l_prd_mth_num --> 3

[AIR_TICKET] ANNUAL CONDITION

[AIR_TICKET] new ANNUAL l_prd_mth_num --> 3

[AIR_TICKET] new ANNUAL l_Paying_Month_Num --> 3

[AIR_TICKET] Annual-4 l_pay_mths --> 12

[AIR_TICKET] new 0l_months_factor --> 12

[AIR_TICKET] new 0l_pay_mths --> 12

[AIR_TICKET] l_pay_mths --> 12

[AIR_TICKET] l_pay_factor --> 1

[AIR_TICKET] l_from_1date 2023/03/01 00:00:00

[AIR_TICKET] l_to_1date 2023/03/31 00:00:00

[AIR_TICKET] l_from_1date --> 2022/04/01 00:00:00

[AIR_TICKET] l_to_1date --> 2023/02/28 00:00:00

[AIR_TICKET] l_frm_1dt --> 2022/04/01

[AIR_TICKET] l_end_1dt --> 2023/02/28

[AIR_TICKET] l_from_2date 2022/04/01

[AIR_TICKET] l_to_2date 2023/02/28

[AIR_TICKET] l_valu1e

[AIR_TICKET] l_valu2e -->

[AIR_TICKET] l_manual_payout --> N

[AIR_TICKET] l_total_pay333 ---> 840

[AIR_TICKET] l_pay_factor333 ---> 1

[AIR_TICKET] l_pay_factor 0333 ---> 1

[AIR_TICKET] l_pay_factor 1333 ---> 1

[AIR_TICKET] l_total_pay 333 ---> 840

[AIR_TICKET] l_air_tckt_pay --> 840


[AIR_TICKET] 2l_latest_hire_date --> 2015/01/17 00:00:00

[AIR_TICKET] 2l_hire_date_yr_num --> 2015

[AIR_TICKET] 2l_hire_date_mth_num --> 1

[AIR_TICKET] 2l_hire_date_dd_num --> 17

[AIR_TICKET] 2l_period_hire_date --> 2024/01/17 00:00:00

[AIR_TICKET] 2l_prv_svc_anniversary --> 2023/01/17 00:00:00

[AIR_TICKET] 2l_period_end_date --> 2023/03/31 00:00:00

[AIR_TICKET] 2l_svc_anniversary --> 2024/01/17 00:00:00

FF Out : L_AIR_TCKT_PAY = 840

Indirect Result IV = 300000092013065 ET = 300000092013059

FF Out : L_EMP_TKT_RATE = 210

FF Out : L_FREQUENCY_OF_TRAVEL = ANNUAL

Direct Result

FF Out : L_PAYING_MONTH = MAR

FF Out : L_TOTAL_PAY = 840

FF Out : L_TOTAL_PROVISION = 70

Indirect Result IV = 300000091597248 ET = 300000091575329

Running Skip Formula 300000036194290

tFF Cxt : DATE_EARNED = 2023/03/31 00:00:00

8FF Cxt : ELEMENT_ENTRY_ID = 300000362990065

8FF Cxt : PAYROLL_ACTION_ID = 10896949

(GLBSKIP)EXECUTING SKIP FORMULA

(GLBSKIP) PAYROLL_ACTION_RUN_TYPE_SHORTNAME = REGULAR

(GLBSKIP) creator_type = F

(GLBSKIP -Classification = Information

skpFF Out : SKIP_FLAG = N

Running Skip Formula 300000000210968

tFF Cxt : DATE_EARNED = 2023/03/31 00:00:00

8FF Cxt : ELEMENT_ENTRY_ID = 300000362990065

8FF Cxt : PAYROLL_ACTION_ID = 10896949

8FF Cxt : PAYROLL_ASSIGNMENT_ID = 300000116757146


8FF Cxt : PAYROLL_ID = 300000117010187

8FF Cxt : PAYROLL_TERM_ID = 300000116757086

(GLBSKIP)EXECUTING SKIP FORMULA

(GLBSKIP) PAYROLL_ACTION_RUN_TYPE_SHORTNAME = REGULAR

(GLBSKIP) creator_type = F

(GLBSKIP -Classification = Information

skpFF Out : SKIP_FLAG = N

Ended processing at : 05-03-2023 13:14:55

Total Pay Relship count : 1

Total Action count :2

Successfully processed : 2

Skipped :0

Unprocessed :0

Errored :0

===============================================================================

-------------------------------------------------------------------------

PL/SQL Output

-------------------------------------------------------------------------

-------------------------------------------------------------------------

-------------------------------------------------------------------------

PL/SQL Output

-------------------------------------------------------------------------

-------------------------------------------------------------------------

+---------------------------------------------------------------------------+

UTIL-CURRENT TIME (DATE=05-MAR-2023) (TIME=13:14:55)

+---------------------------------------------------------------------------+

FND_ENTERPRISE_ID 1

new ENTERPRISE_ID 1
session_id F62761275299D36BE0530F65410AA545

Number Roles 17

Env Request Id = 29794764

===============================================================================

Oracle Human Resources Generic Process

Started at : 05-03-2023 13:14:54

Chunk Size : 20

Threads :1

Logging Category : FZ

Trace :N

Run Result Buffer Size : 100

Balance Buffer Size : 100

Element Entry Buffer Si: 500

Logging Area :

Assignment ID for Start:

Assignment ID for End o:

statistics group id 140378773355220

***** Processing Ass Id 300000116757083 Status 1

Loading Element Entries

Loading Latest Balances

Running Skip Formula 300000036194290

tFF Cxt : DATE_EARNED = 2023/03/31 00:00:00

8FF Cxt : ELEMENT_ENTRY_ID = 300000362990065

8FF Cxt : PAYROLL_ACTION_ID = 10896949

(GLBSKIP)EXECUTING SKIP FORMULA

(GLBSKIP) PAYROLL_ACTION_RUN_TYPE_SHORTNAME = REGULAR

(GLBSKIP) creator_type = F

(GLBSKIP -Classification = Information

skpFF Out : SKIP_FLAG = N


tFF Cxt : DATE_EARNED = 2023/03/31 00:00:00

tFF Cxt : EFFECTIVE_DATE = 2023/03/21 00:00:00

8FF Cxt : ENTRY_USAGE_ID = 14149244

8FF Cxt : LEGAL_EMPLOYER_ID = 300000114795806

8FF Cxt : LEGISLATIVE_DATA_GROUP_ID = 300000001554513

8FF Cxt : PAYROLL_ASSIGNMENT_ID = 300000116757146

8FF Cxt : PAYROLL_ID = 300000117010187

8FF Cxt : PERSON_ID = 100000069588398

FF Inp : CLASS_OF_TRAVEL = ECONOMY

FF Inp : DEPENDENTS_ELIGIBLE = Y

FF Inp : DESTINATION = TRIVANDRUM

FF Inp : FREQUENCY_OF_TRAVEL = ANNUAL

FF Inp : PAYING_MONTH = MAR

Running Formula 300000118204203, _AIR_TICKET_PROCESS

[AIR_TICKET_CALC] l_dependents_eligible Review --> Y

[AIR_TICKET_CALC] l_Frequency_Of_Travel Frequency -->

[AIR_TICKET_CALC] l_Frequency_Of_Travel Future_Use_5 --> X

[AIR_TICKET_CALC] new Future_Use_5 Entered -->

[AIR_TICKET_CALC] new Future_Use_5 --> X

[AIR_TICKET_CALC] new Future_Use_5l_Frequency_Of_Travel --> ANNUAL

[AIR_TICKET_CALC] l_Frequency_Of_Travel Review --> ANNUAL

[AIR_TICKET_CALC] l_Paying_Month Review --> MAR

[AIR_TICKET_CALC] l_months_factor Review1 --> 12

FT: Oracle Payroll calling FT Payroll Access to HR

FT: FFID 300000118204203 calling 300000008403487

[AIR_TICKET_CALC] L_UDT_NAME ---> BG_ _AIR_TICKET_RATES

[AIR_TICKET_CALC] Destination ---> TRIVANDRUM

[AIR_TICKET_CALC] Class_of_Travel ---> ECONOMY

[AIR_TICKET_CALC] Employee does ENTERED HERE 111 .....

[AIR_TICKET_CALC] Destination 111 ---> TRIVANDRUM

[AIR_TICKET_CALC] Class_of_Travel 111 ---> ECONOMY


[AIR_TICKET_CALC] l_destination TRIVANDRUM

[AIR_TICKET_CALC] l_class ECONOMY

[AIR_TICKET_CALC] l_override_ticket_fare 0

[AIR_TICKET_CALC] l_override_tot_air_ticket_amt 0

[AIR_TICKET_CALC] Emp Monthly Provision L_EMP_TKT_RATE 210

[AIR_TICKET_CALC] l_marital_status Review1 M

[AIR_TICKET_CALC] PER_PER_CONTACT_DAUGHTERS_COUNT Review1 0

[AIR_TICKET_CALC] PER_PER_CONTACT_SONS_COUNT Review1 0

[AIR_TICKET_CALC] L_W_COUNT Review1 1

[AIR_TICKET_CALC] L_C_COUNT Review1 0

[AIR_TICKET_CALC] Employee is married

ContacKt KTypeS

ContacKt KTypeIN_S

ContacKt KTypeIN_D

Contact TypeS

Contact TypeS

[AIR_TICKET_CALC] Spouse exists

[AIR_TICKET_CALC] l_spouse_ticket_rate : 210

[AIR_TICKET] L_C_COUNT for child exists --> 0

[AIR_TICKET] Entered into No. of Children1623, L_C_COUNT 0

Contact Type --> S

[AIR_TICKET] No. of Children123, L_C_COUNT --> 0

[AIR_TICKET] Entered into No. of Children1623, L_C_COUNT 0

Contact Type --> IN_S

[AIR_TICKET] l_child_name --> Darsan Manoj

[AIR_TICKET] l_child_dob --> 2005/05/24 00:00:00

[AIR_TICKET] No. of Children123, L_C_COUNT --> 1

[AIR_TICKET] Entered into No. of Children1623, L_C_COUNT 1

Contact Type --> IN_D

[AIR_TICKET] l_child_name --> Diya Manoj

[AIR_TICKET] l_child_dob --> 2009/01/02 00:00:00


[AIR_TICKET] No. of Children123, L_C_COUNT --> 2

[AIR_TICKET] No. of Children, L_C_COUNT --> 2

[AIR_TICKET] entered into DOB loop

[AIR_TICKET] entered into K DOB loop -->

[AIR_TICKET] entered into K value --> 1

[AIR_TICKET] l_Child_Count --> 2

[AIR_TICKET] entered into l_child_age

[AIR_TICKET] l_Child_Count_Test enered 2

[AIR_TICKET] l_child_age 17.8521505376344086021505376344086021505

[AIR_TICKET] l_entity_code SBS

[AIR_TICKET] l_ch_tkt_rate3 SBS 210

[AIR_TICKET] l_childl_ch_tkt_rate 210

[AIR_TICKET] l_ch_tkt_rate --> 210

[AIR_TICKET] l_child_tkt_rate total --> 210

[AIR_TICKET] l_child_age 14.24462365591397849462365591397849462367

[AIR_TICKET] l_entity_code SBS

[AIR_TICKET] l_ch_tkt_rate3 SBS 210

[AIR_TICKET] l_childl_ch_tkt_rate 210

[AIR_TICKET] l_ch_tkt_rate --> 210

[AIR_TICKET] l_child_tkt_rate total --> 420

[AIR_TICKET] l_dep_count - 1 --> 2

[AIR_TICKET] l_No_Of_Children_Elig - 1 --> 2

[AIR_TICKET] newl_total_pay --> 840

[AIR_TICKET] l_total_pay --> 840

[AIR_TICKET] L_total_provision --> 70

[AIR_TICKET] 1l_l_date1 2015/01/17 00:00:00

[AIR_TICKET] 1l_PAY_EARN_PERIOD_END 2023/03/31 00:00:00

[AIR_TICKET] 1l_l_hire_date 2015/01/17 00:00:00

[AIR_TICKET] 1l_latest_hire_date 2015/01/17 00:00:00

[AIR_TICKET] 1l_hire_date_yr_num 2015

[AIR_TICKET] 1l_hire_date_mth_num 1
[AIR_TICKET] 1l_hire_date_dd_num 17

[AIR_TICKET] 11l_hire_date_yr_days 2996

[AIR_TICKET] l_hire_date_dd_days 13

[AIR_TICKET] 1l_period_end_date 2023/03/31 00:00:00

[AIR_TICKET] 1l_term_date_diff -32277

[AIR_TICKET] 1l_pay_mth_diff 97.4516129032258064516129032258064516129

[AIR_TICKET] 1l_pay_days_diff 2995

[AIR_TICKET] 1l_pay_mth_diff_char 97

[AIR_TICKET] 1l_pay_mth_diff_num 97

[AIR_TICKET] l_hire_date_yr_num --> 2015

[AIR_TICKET] l_prd_yr_num --> 2023

[AIR_TICKET] l_prd_mth_num --> 3

[AIR_TICKET] ANNUAL CONDITION

[AIR_TICKET] new ANNUAL l_prd_mth_num --> 3

[AIR_TICKET] new ANNUAL l_Paying_Month_Num --> 3

[AIR_TICKET] Annual-4 l_pay_mths --> 12

[AIR_TICKET] new 0l_months_factor --> 12

[AIR_TICKET] new 0l_pay_mths --> 12

[AIR_TICKET] l_pay_mths --> 12

[AIR_TICKET] l_pay_factor --> 1

[AIR_TICKET] l_from_1date 2023/03/01 00:00:00

[AIR_TICKET] l_to_1date 2023/03/31 00:00:00

[AIR_TICKET] l_from_1date --> 2022/04/01 00:00:00

[AIR_TICKET] l_to_1date --> 2023/02/28 00:00:00

[AIR_TICKET] l_frm_1dt --> 2022/04/01

[AIR_TICKET] l_end_1dt --> 2023/02/28

[AIR_TICKET] l_from_2date 2022/04/01

[AIR_TICKET] l_to_2date 2023/02/28

[AIR_TICKET] l_valu1e

[AIR_TICKET] l_valu2e -->

[AIR_TICKET] l_manual_payout --> N


[AIR_TICKET] l_total_pay333 ---> 840

[AIR_TICKET] l_pay_factor333 ---> 1

[AIR_TICKET] l_pay_factor 0333 ---> 1

[AIR_TICKET] l_pay_factor 1333 ---> 1

[AIR_TICKET] l_total_pay 333 ---> 840

[AIR_TICKET] l_air_tckt_pay --> 840

[AIR_TICKET] 2l_latest_hire_date --> 2015/01/17 00:00:00

[AIR_TICKET] 2l_hire_date_yr_num --> 2015

[AIR_TICKET] 2l_hire_date_mth_num --> 1

[AIR_TICKET] 2l_hire_date_dd_num --> 17

[AIR_TICKET] 2l_period_hire_date --> 2024/01/17 00:00:00

[AIR_TICKET] 2l_prv_svc_anniversary --> 2023/01/17 00:00:00

[AIR_TICKET] 2l_period_end_date --> 2023/03/31 00:00:00

[AIR_TICKET] 2l_svc_anniversary --> 2024/01/17 00:00:00

FF Out : L_AIR_TCKT_PAY = 840

Indirect Result IV = 300000092013065 ET = 300000092013059

FF Out : L_EMP_TKT_RATE = 210

FF Out : L_FREQUENCY_OF_TRAVEL = ANNUAL

Direct Result

FF Out : L_PAYING_MONTH = MAR

FF Out : L_TOTAL_PAY = 840

FF Out : L_TOTAL_PROVISION = 70

Indirect Result IV = 300000091597248 ET = 300000091575329

Running Skip Formula 300000036194290

tFF Cxt : DATE_EARNED = 2023/03/31 00:00:00

8FF Cxt : ELEMENT_ENTRY_ID = 300000362990065

8FF Cxt : PAYROLL_ACTION_ID = 10896949

(GLBSKIP)EXECUTING SKIP FORMULA

(GLBSKIP) PAYROLL_ACTION_RUN_TYPE_SHORTNAME = REGULAR

(GLBSKIP) creator_type = F

(GLBSKIP -Classification = Information


skpFF Out : SKIP_FLAG = N

Running Skip Formula 300000000210968

tFF Cxt : DATE_EARNED = 2023/03/31 00:00:00

8FF Cxt : ELEMENT_ENTRY_ID = 300000362990065

8FF Cxt : PAYROLL_ACTION_ID = 10896949

8FF Cxt : PAYROLL_ASSIGNMENT_ID = 300000116757146

8FF Cxt : PAYROLL_ID = 300000117010187

8FF Cxt : PAYROLL_TERM_ID = 300000116757086

(GLBSKIP)EXECUTING SKIP FORMULA

(GLBSKIP) PAYROLL_ACTION_RUN_TYPE_SHORTNAME = REGULAR

(GLBSKIP) creator_type = F

(GLBSKIP -Classification = Information

skpFF Out : SKIP_FLAG = N

Ended processing at : 05-03-2023 13:14:55

Total Pay Relship count : 1

Total Action count :2

Successfully processed : 2

Skipped :0

Unprocessed :0

Errored :0

===============================================================================

-------------------------------------------------------------------------

PL/SQL Output

-------------------------------------------------------------------------

-------------------------------------------------------------------------

-------------------------------------------------------------------------

PL/SQL Output

-------------------------------------------------------------------------

-------------------------------------------------------------------------
+---------------------------------------------------------------------------+

UTIL-CURRENT TIME (DATE=05-MAR-2023) (TIME=13:14:55)

+---------------------------------------------------------------------------+

FND_ENTERPRISE_ID 1

new ENTERPRISE_ID 1

session_id F62761275299D36BE0530F65410AA545

Number Roles 17

Env Request Id = 29794764

===============================================================================

Oracle Human Resources Generic Process

Started at : 05-03-2023 13:14:54

Chunk Size : 20

Threads :1

Logging Category : FZ

Trace :N

Run Result Buffer Size : 100

Balance Buffer Size : 100

Element Entry Buffer Si: 500

Logging Area :

Assignment ID for Start:

Assignment ID for End o:

statistics group id 140378773355220

***** Processing Ass Id 300000116757083 Status 1

Loading Element Entries

Loading Latest Balances

Running Skip Formula 300000036194290

tFF Cxt : DATE_EARNED = 2023/03/31 00:00:00

8FF Cxt : ELEMENT_ENTRY_ID = 300000362990065


8FF Cxt : PAYROLL_ACTION_ID = 10896949

(GLBSKIP)EXECUTING SKIP FORMULA

(GLBSKIP) PAYROLL_ACTION_RUN_TYPE_SHORTNAME = REGULAR

(GLBSKIP) creator_type = F

(GLBSKIP -Classification = Information

skpFF Out : SKIP_FLAG = N

tFF Cxt : DATE_EARNED = 2023/03/31 00:00:00

tFF Cxt : EFFECTIVE_DATE = 2023/03/21 00:00:00

8FF Cxt : ENTRY_USAGE_ID = 14149244

8FF Cxt : LEGAL_EMPLOYER_ID = 300000114795806

8FF Cxt : LEGISLATIVE_DATA_GROUP_ID = 300000001554513

8FF Cxt : PAYROLL_ASSIGNMENT_ID = 300000116757146

8FF Cxt : PAYROLL_ID = 300000117010187

8FF Cxt : PERSON_ID = 100000069588398

FF Inp : CLASS_OF_TRAVEL = ECONOMY

FF Inp : DEPENDENTS_ELIGIBLE = Y

FF Inp : DESTINATION = TRIVANDRUM

FF Inp : FREQUENCY_OF_TRAVEL = ANNUAL

FF Inp : PAYING_MONTH = MAR

Running Formula 300000118204203, _AIR_TICKET_PROCESS

[AIR_TICKET_CALC] l_dependents_eligible Review --> Y

[AIR_TICKET_CALC] l_Frequency_Of_Travel Frequency -->

[AIR_TICKET_CALC] l_Frequency_Of_Travel Future_Use_5 --> X

[AIR_TICKET_CALC] new Future_Use_5 Entered -->

[AIR_TICKET_CALC] new Future_Use_5 --> X

[AIR_TICKET_CALC] new Future_Use_5l_Frequency_Of_Travel --> ANNUAL

[AIR_TICKET_CALC] l_Frequency_Of_Travel Review --> ANNUAL

[AIR_TICKET_CALC] l_Paying_Month Review --> MAR

[AIR_TICKET_CALC] l_months_factor Review1 --> 12

FT: Oracle Payroll calling FT Payroll Access to HR

FT: FFID 300000118204203 calling 300000008403487


[AIR_TICKET_CALC] L_UDT_NAME ---> BG_ _AIR_TICKET_RATES

[AIR_TICKET_CALC] Destination ---> TRIVANDRUM

[AIR_TICKET_CALC] Class_of_Travel ---> ECONOMY

[AIR_TICKET_CALC] Employee does ENTERED HERE 111 .....

[AIR_TICKET_CALC] Destination 111 ---> TRIVANDRUM

[AIR_TICKET_CALC] Class_of_Travel 111 ---> ECONOMY

[AIR_TICKET_CALC] l_destination TRIVANDRUM

[AIR_TICKET_CALC] l_class ECONOMY

[AIR_TICKET_CALC] l_override_ticket_fare 0

[AIR_TICKET_CALC] l_override_tot_air_ticket_amt 0

[AIR_TICKET_CALC] Emp Monthly Provision L_EMP_TKT_RATE 210

[AIR_TICKET_CALC] l_marital_status Review1 M

[AIR_TICKET_CALC] PER_PER_CONTACT_DAUGHTERS_COUNT Review1 0

[AIR_TICKET_CALC] PER_PER_CONTACT_SONS_COUNT Review1 0

[AIR_TICKET_CALC] L_W_COUNT Review1 1

[AIR_TICKET_CALC] L_C_COUNT Review1 0

[AIR_TICKET_CALC] Employee is married

ContacKt KTypeS

ContacKt KTypeIN_S

ContacKt KTypeIN_D

Contact TypeS

Contact TypeS

[AIR_TICKET_CALC] Spouse exists

[AIR_TICKET_CALC] l_spouse_ticket_rate : 210

[AIR_TICKET] L_C_COUNT for child exists --> 0

[AIR_TICKET] Entered into No. of Children1623, L_C_COUNT 0

Contact Type --> S

[AIR_TICKET] No. of Children123, L_C_COUNT --> 0

[AIR_TICKET] Entered into No. of Children1623, L_C_COUNT 0

Contact Type --> IN_S

[AIR_TICKET] l_child_name --> Darsan Manoj


[AIR_TICKET] l_child_dob --> 2005/05/24 00:00:00

[AIR_TICKET] No. of Children123, L_C_COUNT --> 1

[AIR_TICKET] Entered into No. of Children1623, L_C_COUNT 1

Contact Type --> IN_D

[AIR_TICKET] l_child_name --> Diya Manoj

[AIR_TICKET] l_child_dob --> 2009/01/02 00:00:00

[AIR_TICKET] No. of Children123, L_C_COUNT --> 2

[AIR_TICKET] No. of Children, L_C_COUNT --> 2

[AIR_TICKET] entered into DOB loop

[AIR_TICKET] entered into K DOB loop -->

[AIR_TICKET] entered into K value --> 1

[AIR_TICKET] l_Child_Count --> 2

[AIR_TICKET] entered into l_child_age

[AIR_TICKET] l_Child_Count_Test enered 2

[AIR_TICKET] l_child_age 17.8521505376344086021505376344086021505

[AIR_TICKET] l_entity_code SBS

[AIR_TICKET] l_ch_tkt_rate3 SBS 210

[AIR_TICKET] l_childl_ch_tkt_rate 210

[AIR_TICKET] l_ch_tkt_rate --> 210

[AIR_TICKET] l_child_tkt_rate total --> 210

[AIR_TICKET] l_child_age 14.24462365591397849462365591397849462367

[AIR_TICKET] l_entity_code SBS

[AIR_TICKET] l_ch_tkt_rate3 SBS 210

[AIR_TICKET] l_childl_ch_tkt_rate 210

[AIR_TICKET] l_ch_tkt_rate --> 210

[AIR_TICKET] l_child_tkt_rate total --> 420

[AIR_TICKET] l_dep_count - 1 --> 2

[AIR_TICKET] l_No_Of_Children_Elig - 1 --> 2

[AIR_TICKET] newl_total_pay --> 840

[AIR_TICKET] l_total_pay --> 840

[AIR_TICKET] L_total_provision --> 70


[AIR_TICKET] 1l_l_date1 2015/01/17 00:00:00

[AIR_TICKET] 1l_PAY_EARN_PERIOD_END 2023/03/31 00:00:00

[AIR_TICKET] 1l_l_hire_date 2015/01/17 00:00:00

[AIR_TICKET] 1l_latest_hire_date 2015/01/17 00:00:00

[AIR_TICKET] 1l_hire_date_yr_num 2015

[AIR_TICKET] 1l_hire_date_mth_num 1

[AIR_TICKET] 1l_hire_date_dd_num 17

[AIR_TICKET] 11l_hire_date_yr_days 2996

[AIR_TICKET] l_hire_date_dd_days 13

[AIR_TICKET] 1l_period_end_date 2023/03/31 00:00:00

[AIR_TICKET] 1l_term_date_diff -32277

[AIR_TICKET] 1l_pay_mth_diff 97.4516129032258064516129032258064516129

[AIR_TICKET] 1l_pay_days_diff 2995

[AIR_TICKET] 1l_pay_mth_diff_char 97

[AIR_TICKET] 1l_pay_mth_diff_num 97

[AIR_TICKET] l_hire_date_yr_num --> 2015

[AIR_TICKET] l_prd_yr_num --> 2023

[AIR_TICKET] l_prd_mth_num --> 3

[AIR_TICKET] ANNUAL CONDITION

[AIR_TICKET] new ANNUAL l_prd_mth_num --> 3

[AIR_TICKET] new ANNUAL l_Paying_Month_Num --> 3

[AIR_TICKET] Annual-4 l_pay_mths --> 12

[AIR_TICKET] new 0l_months_factor --> 12

[AIR_TICKET] new 0l_pay_mths --> 12

[AIR_TICKET] l_pay_mths --> 12

[AIR_TICKET] l_pay_factor --> 1

[AIR_TICKET] l_from_1date 2023/03/01 00:00:00

[AIR_TICKET] l_to_1date 2023/03/31 00:00:00

[AIR_TICKET] l_from_1date --> 2022/04/01 00:00:00

[AIR_TICKET] l_to_1date --> 2023/02/28 00:00:00

[AIR_TICKET] l_frm_1dt --> 2022/04/01


[AIR_TICKET] l_end_1dt --> 2023/02/28

[AIR_TICKET] l_from_2date 2022/04/01

[AIR_TICKET] l_to_2date 2023/02/28

[AIR_TICKET] l_valu1e

[AIR_TICKET] l_valu2e -->

[AIR_TICKET] l_manual_payout --> N

[AIR_TICKET] l_total_pay333 ---> 840

[AIR_TICKET] l_pay_factor333 ---> 1

[AIR_TICKET] l_pay_factor 0333 ---> 1

[AIR_TICKET] l_pay_factor 1333 ---> 1

[AIR_TICKET] l_total_pay 333 ---> 840

[AIR_TICKET] l_air_tckt_pay --> 840

[AIR_TICKET] 2l_latest_hire_date --> 2015/01/17 00:00:00

[AIR_TICKET] 2l_hire_date_yr_num --> 2015

[AIR_TICKET] 2l_hire_date_mth_num --> 1

[AIR_TICKET] 2l_hire_date_dd_num --> 17

[AIR_TICKET] 2l_period_hire_date --> 2024/01/17 00:00:00

[AIR_TICKET] 2l_prv_svc_anniversary --> 2023/01/17 00:00:00

[AIR_TICKET] 2l_period_end_date --> 2023/03/31 00:00:00

[AIR_TICKET] 2l_svc_anniversary --> 2024/01/17 00:00:00

FF Out : L_AIR_TCKT_PAY = 840

Indirect Result IV = 300000092013065 ET = 300000092013059

FF Out : L_EMP_TKT_RATE = 210

FF Out : L_FREQUENCY_OF_TRAVEL = ANNUAL

Direct Result

FF Out : L_PAYING_MONTH = MAR

FF Out : L_TOTAL_PAY = 840

FF Out : L_TOTAL_PROVISION = 70

Indirect Result IV = 300000091597248 ET = 300000091575329

Running Skip Formula 300000036194290

tFF Cxt : DATE_EARNED = 2023/03/31 00:00:00


8FF Cxt : ELEMENT_ENTRY_ID = 300000362990065

8FF Cxt : PAYROLL_ACTION_ID = 10896949

(GLBSKIP)EXECUTING SKIP FORMULA

(GLBSKIP) PAYROLL_ACTION_RUN_TYPE_SHORTNAME = REGULAR

(GLBSKIP) creator_type = F

(GLBSKIP -Classification = Information

skpFF Out : SKIP_FLAG = N

Running Skip Formula 300000000210968

tFF Cxt : DATE_EARNED = 2023/03/31 00:00:00

8FF Cxt : ELEMENT_ENTRY_ID = 300000362990065

8FF Cxt : PAYROLL_ACTION_ID = 10896949

8FF Cxt : PAYROLL_ASSIGNMENT_ID = 300000116757146

8FF Cxt : PAYROLL_ID = 300000117010187

8FF Cxt : PAYROLL_TERM_ID = 300000116757086

(GLBSKIP)EXECUTING SKIP FORMULA

(GLBSKIP) PAYROLL_ACTION_RUN_TYPE_SHORTNAME = REGULAR

(GLBSKIP) creator_type = F

(GLBSKIP -Classification = Information

skpFF Out : SKIP_FLAG = N

Ended processing at : 05-03-2023 13:14:55

Total Pay Relship count : 1

Total Action count :2

Successfully processed : 2

Skipped :0

Unprocessed :0

Errored :0

===============================================================================

-------------------------------------------------------------------------

PL/SQL Output

-------------------------------------------------------------------------
-------------------------------------------------------------------------

-------------------------------------------------------------------------

PL/SQL Output

-------------------------------------------------------------------------

-------------------------------------------------------------------------

+---------------------------------------------------------------------------+

UTIL-CURRENT TIME (DATE=05-MAR-2023) (TIME=13:14:55)

+---------------------------------------------------------------------------+

You might also like