Calculation Card for Absence

 Problem statement:


How to identify when and who created an Absence Calculation Card. 



SELECT DISTINCT

    v.value_defn_id,

    v.effective_start_date,

    v.effective_end_date,

    v.base_name,

    v.value_group_id,

    v.calc_type_id,

    v.legislation_code,

    v.legislative_data_group_id,

    v.created_by,

    v.creation_date,

    v.last_update_date,

    v.last_updated_by,

    v.parent_value_defn_id,

    v.source_id,

    v.source_type,

    v.dir_override_usage_id,

    v.date_mode,

    r.range_item_id,

    r.effective_start_date range_item_eff_start_date,

    r.effective_end_date   range_item_eff_end_date,

    r.low_value,

    r.high_value,

    r.value1,

    r.value2,

    r.value3,

    r.created_by           range_item_created_by,

    r.creation_date        range_item_creation_date,

    r.last_update_date     range_item_last_update_date,

    r.last_updated_by      range_item_last_updated_by,

    r.low_value_text,

    r.high_value_text,

pdc.creation_date,

pdc.created_by

FROM

    pay_value_instances_v     v,

    pay_range_inst_v          r,

    pay_dir_card_components_f pdcc,

    pay_dir_cards_f           pdc,

    pay_pay_relationships_dn  ppr,

    per_all_people_f          pap

WHERE

        r.value_defn_id = v.value_defn_id

    AND v.source_id = pdcc.dir_card_comp_id

        AND pdcc.dir_card_id = pdc.dir_card_id

            AND pdc.payroll_relationship_id = ppr.payroll_relationship_id

                AND ppr.person_id = pap.person_id

                    AND pap.person_number = :p_person_number

                        AND pdc.dir_card_definition_id IN (

        SELECT

            dir_card_definition_id

        FROM

            pay_dir_card_definitions_vl

        WHERE

            base_display_name IN ( 'Absences')


    )

ORDER BY

    v.source_id,

    v.parent_value_defn_id,

    v.value_defn_id,

    v.effective_start_date,

    r.range_item_id,

    r.effective_start_date  



Reason:


1. Absence ineligibility profile/fast formula was not attached to the absence plan.

2. Absence seeded processes are scheduled. Hence, inadvertently the plan was assigned to employees which also created an Absence Calculation Card.

Comments

Post a Comment

Popular posts from this blog

SQL to get Payroll Balances in Oracle Fusion HCM

SELECT DISTINCT     papf.person_number,     pni.national_identifier_number,     prb.balance_value,     ppa.effective_date,     pbtv.balance_name,     pbd.base_dimension_name FROM     per_all_people_f           papf,     per_national_identifiers   pni,     per_periods_of_service     ppos,     per_all_assignments_f      paaf,     pay_payroll_assignments    ppasg,     pay_pay_relationships_dn   pprd,     pay_payroll_rel_actions    ppra,     pay_run_results            prr,     pay_run_result_values      prrv,     pay_input_values_f         pivf,     pay_balance_feeds_f        pbf,     pay_balance_types_v...
Read more

User Account in Oracle Fusion HCM

Image
Configuration for User Account: 1.        Set up for automatic User Account Creation. Go to FSM --> Manage Enterprise HCM Information --> This set up will ensure that user accounts are created automatically for person. 1.        User Name generation method. This set up is done in Security Console. Go to Tools -->  Security Console -->  User Categories This will ensure if work email address is there in the Worker.dat file while loading worker information – this will create user account by default which is same as the person’s work email address. However, this will be pending status as we need to Send Pending LDAP Requests to reflect the user name. Post successful completion of ESS job “Send Pending LDAP Requests” the user account will be reflected as person’s work email address. In case there is no work email addre...
Read more

Using Generic SOAP Port Webservice to Upload file to UCM

Image
In this article, we will learn about how to use SOAP Service to upload files to UCM. This is used for automation of interfaces in Oracle Cloud Fusion HCM. In this example, we will use SOAP UI to test the service. Same concepts can be applied in Fusion Middleware or any other platform to invoke Web Service to upload files to UCM. You can upload the file by Base64 encoding the binary content of the file, in the Content tag as below: <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ucm="http://www.oracle.com/UCM"> <soapenv:Header xmlns:wsa="http://www.w3.org/2005/08/addressing"> <wsa:Action>urn:GenericSoap/GenericSoapOperation</wsa:Action> </soapenv:Header> <soapenv:Body> <ucm:GenericRequest webKey="cs"> <ucm:Service IdcService="CHECKIN_NEW"> <ucm:Document> <ucm:Field name="dUser">imp</ucm:Field> <ucm:Field name=...
Read more