Rest Api Testing for Oracle Time and Labor (OTL)

 Oracle Time and Labor Rest Api:

 

Rest Api: hcmRestApi/resources/11.13.18.05/timeRecordEventRequests

Method: Post

Payload:

{

"processMode":"TIME_SAVE",

"processInline":"N",

"timeRecordEvent":

[

{

"timeRecordId":"",

"timeRecordVersion":"",

"startTime":"2017-10-13T10:00:00.000-08:00",

"stopTime":"2017-10-13T14:00:00.000-08:00",

"reporterIdType":"PERSON",

"reporterId":"xxxxx", ----Insert Person Number

"assignmentNumber":"",

"comment":"Time Entry Update Measure",

"operationType":"ADD",

"changeReason":"ORA_CA_REASON_MTE_PROC",

"measure":"",

"timeRecordEventAttribute":

[

{

"attributeName":"PayrollTimeType",

"changeReason":"ORA_CA_REASON_MTE_PROC",

"attributeValue":"ZOTL_Regular"

}

]

}

]

}

Postman URL:

https://<<Instance URL>>/hcmRestApi/resources/11.13.18.05/timeRecordEventRequests

 

 

Response from Postman:

{

    "timeRecordEventRequestId": 300000035161120,

    "processMode": "TIME_SAVE",

    "processInline": "N",

    "timeRecordEvent": [

        {

            "comment": "Time Entry Update Measure",

            "crudStatusValue": 0,

            "personId": "XXXXXX", --Person_id

            "referenceDate": null,

            "reporterId": "XXXXX", ---Person_number

            "reporterIdType": "PERSON",

            "startTime": "2017-10-13T10:00:00.000-08:00",

            "stopTime": "2017-10-13T14:00:00.000-08:00",

            "subresourceId": null,

            "timeRecordEventId": 300000035161121,

            "timeRecordEventRequestId": 300000035161120,

            "timeRecordId": null,

            "timeRecordVersion": null,

            "operationType": "ADD",

            "assignmentNumber": "",

            "eventStatusValue": 0,

            "eventStatus": "NEW",

            "measure": null,

            "changeReason": "ORA_CA_REASON_MTE_PROC",

            "timeRecordEventAttribute": [

                {

                    "timeAttributeFieldId": 300000000427517,

                    "timeRecordEventAttributeId": 300000035161122,

                    "timeRecordEventId": 300000035161121,

                    "attributeValue": "ZOTL_Regular",

                    "changeReason": "ORA_CA_REASON_MTE_PROC",

                    "attributeName": "PayrollTimeType",

                    "links": [

                        {

                            "rel": "self",

                            "href": "https:<<Instance URL>>:443/hcmRestApi/resources/11.13.18.05/timeRecordEventRequests/300000035161120/child/timeRecordEvent/300000035161121/child/timeRecordEventAttribute/300000035161122",

                            "name": "timeRecordEventAttribute",

                            "kind": "item",

                            "properties": {

                                "changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000178"

                            }

                        },

                        {

                            "rel": "canonical",

                            "href": "<<Instance URL >>":443/hcmRestApi/resources/11.13.18.05/timeRecordEventRequests/300000035161120/child/timeRecordEvent/300000035161121/child/timeRecordEventAttribute/300000035161122",

                            "name": "timeRecordEventAttribute",

                            "kind": "item"

                        },

                        {

                            "rel": "parent",

                            "href": "<<Instance URL>>":443/hcmRestApi/resources/11.13.18.05/timeRecordEventRequests/300000035161120/child/timeRecordEvent/300000035161121",

                            "name": "timeRecordEvent",

                            "kind": "item"

                        },

                        {

                            "rel": "lov",

                            "href": "<<Instance URL>>:443/hcmRestApi/resources/11.13.18.05/timeRecordEventRequests/300000035161120/child/timeRecordEvent/300000035161121/child/timeRecordEventAttribute/300000035161122/lov/HcmLookupPVO1",

                            "name": "HcmLookupPVO1",

                            "kind": "collection"

                        }

                    ]

                }

            ],

            "links": [

                {

                    "rel": "self",

                    "href": "<<Instance URL>>:443/hcmRestApi/resources/11.13.18.05/timeRecordEventRequests/300000035161120/child/timeRecordEvent/300000035161121",

                    "name": "timeRecordEvent",

                    "kind": "item",

                    "properties": {

                        "changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000178"

                    }

                },

                {

                    "rel": "canonical",

                    "href": "<<Instance URL>>:443/hcmRestApi/resources/11.13.18.05/timeRecordEventRequests/300000035161120/child/timeRecordEvent/300000035161121",

                    "name": "timeRecordEvent",

                    "kind": "item"

                },

                {

                    "rel": "parent",

                    "href": "<<Instance URL>>:443/hcmRestApi/resources/11.13.18.05/timeRecordEventRequests/300000035161120",

                    "name": "timeRecordEventRequests",

                    "kind": "item"

                },

                {

                    "rel": "lov",

                    "href": "<<Instance URL>>:443/hcmRestApi/resources/11.13.18.05/timeRecordEventRequests/300000035161120/child/timeRecordEvent/300000035161121/lov/HcmLookupPVO1",

                    "name": "HcmLookupPVO1",

                    "kind": "collection"

                },

                {

                    "rel": "child",

                    "href": "<<Instance URL>>:443/hcmRestApi/resources/11.13.18.05/timeRecordEventRequests/300000035161120/child/timeRecordEvent/300000035161121/child/timeRecordEventAttribute",

                    "name": "timeRecordEventAttribute",

                    "kind": "collection"

                },

                {

                    "rel": "child",

                    "href": "<<Instance URL>>:443/hcmRestApi/resources/11.13.18.05/timeRecordEventRequests/300000035161120/child/timeRecordEvent/300000035161121/child/timeRecordEventMessage",

                    "name": "timeRecordEventMessage",

                    "kind": "collection"

                }

            ]

        }

    ],

    "links": [

        {

            "rel": "self",

            "href": "<<Instance URL>>:443/hcmRestApi/resources/11.13.18.05/timeRecordEventRequests/300000035161120",

            "name": "timeRecordEventRequests",

            "kind": "item",

            "properties": {

                "changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000178"

            }

        },

        {

            "rel": "canonical",

            "href": "<<Instance URL>>:443/hcmRestApi/resources/11.13.18.05/timeRecordEventRequests/300000035161120",

            "name": "timeRecordEventRequests",

            "kind": "item"

        },

        {

            "rel": "child",

            "href": "<<Instance URL>>:443/hcmRestApi/resources/11.13.18.05/timeRecordEventRequests/300000035161120/child/timeRecordEvent",

            "name": "timeRecordEvent",

            "kind": "collection"

        }

    ]

}

Time Record Entry created In fusion:

Screenshot from Oracle fusion:

 

Multiple Records 1 :

{

"processMode":"TIME_SAVE",

"processInline":"N",

"timeRecordEvent":

[

{

"timeRecordId":"",

"timeRecordVersion":"",

"startTime":"2018-10-13T10:00:00.000-08:00",

"stopTime":"2018-10-13T14:00:00.000-08:00",

"reporterIdType":"PERSON",

"reporterId":"xxxxx",---person_number

"assignmentNumber":"",

"comment":"Time Entry Update Measure",

"operationType":"ADD",

"changeReason":"ORA_CA_REASON_MTE_PROC",

"measure":"",

"timeRecordEventAttribute":

[

{

"attributeName":"PayrollTimeType",

"changeReason":"ORA_CA_REASON_MTE_PROC",

"attributeValue":"ZOTL_Regular"

}

]

}

]

}

 

 

2^nd Record:

{

"processMode":"TIME_SAVE",

"processInline":"N",

"timeRecordEvent":

[

{

"timeRecordId":"",

"timeRecordVersion":"",

"startTime":"2018-10-13T16:00:00.000-08:00",

"stopTime":"2018-10-13T17:00:00.000-08:00",

"reporterIdType":"PERSON",

"reporterId":"xxxxxx",---person_number

"assignmentNumber":"",

"comment":"Time Entry Update Measure",

"operationType":"ADD",

"changeReason":"ORA_CA_REASON_MTE_PROC",

"measure":"",

"timeRecordEventAttribute":

[

{

"attributeName":"PayrollTimeType",

"changeReason":"ORA_CA_REASON_MTE_PROC",

"attributeValue":"ZOTL_Regular"

}

]

}

]

}

 

 

3^rd Record:

{

"processMode":"TIME_SAVE",

"processInline":"N",

"timeRecordEvent":

[

{

"timeRecordId":"",

"timeRecordVersion":"",

"startTime":"2018-10-13T17:30:00.000-08:00",

"stopTime":"2018-10-13T17:45:00.000-08:00",

"reporterIdType":"PERSON",

"reporterId":"person_number",

"assignmentNumber":"",

"comment":"Time Entry Update Measure",

"operationType":"ADD",

"changeReason":"ORA_CA_REASON_MTE_PROC",

"measure":"",

"timeRecordEventAttribute":

[

{

"attributeName":"PayrollTimeType",

"changeReason":"ORA_CA_REASON_MTE_PROC",

"attributeValue":"ZOTL_Regular"

}

]

}

]

}

 

 

 

 

 

4^th Record :

{

"processMode":"TIME_SAVE",

"processInline":"N",

"timeRecordEvent":

[

{

"timeRecordId":"",

"timeRecordVersion":"",

"startTime":"2018-10-13T17:46:00.000-08:00",

"stopTime":"2018-10-13T17:59:00.000-08:00",

"reporterIdType":"PERSON",

"reporterId":"xxxxx",  ---person_number

"assignmentNumber":"",

"comment":"Time Entry Update Measure",

"operationType":"ADD",

"changeReason":"ORA_CA_REASON_MTE_PROC",

"measure":"",

"timeRecordEventAttribute":

[

{

"attributeName":"PayrollTimeType",

"changeReason":"ORA_CA_REASON_MTE_PROC",

"attributeValue":"ZOTL_Regular"

}

]

}

]

}

 

Database Records:

Table : HWM_TM_REC_EVENTS

 

ESS : Process Imported Time Entries

 

Team Time Entries: