The Timecard Entry Status dimension is key understanding the status of a timecard entry. The Timecard Entry Status is different for Reported and Processed (aka Payable) time. Oracle provides domain member mappings for both Reported and Processed.
Optional or Mandatory
This task is mandatory.
Applies to
Oracle Fusion Applications, Oracle E-Business Suite, and PeopleSoft
Task description in detail
Configuring the domains on the Timecard Entry Status dimension are key to the successful attribution of time reporting entries to warehouse reporting categories and subcategories.
Source Reported Timecard Entry Status Code -> Reported Timecard Status Code
This task is mandatory.
Used to identify how Source Reported Timecard Entry Status map to delivered target Reported Timecard Status domain members; target domain members are used in the delivered metrics, dashboards and reports, for example, WORKING (Working), APPROVED (Approved). The target domain is Extensible - customers can add to but not delete from it.
Example for Fusion
The Source Reported Timecard Entry Status Code is based on the values in the FND look-up (HWM_UI_STATUS / HWM_USER_STATUS).
Example Implementation
| Source Member Code (Name) | Target Member Code (Name) |
|---|---|
|
APPROVED (Approved) |
APPROVED (Approved) |
|
ERROR (Error) |
ERROR (Error) |
|
REJECTED (Rejected) |
REJECTED (Rejected) |
|
SUBMITTED (Submitted) |
SUBMITTED (Submitted) |
|
WORKING (Working) |
WORKING (Working) |
Example for E-Business Suite
The Source Reported Timecard Entry Status Code is based on the values in the FND look-up (HXC_APPROVAL_STATUS).
Example Implementation
| Source Member Code (Name) | Target Member Code (Name) |
|---|---|
|
APPROVED (Approved) |
APPROVED (Approved) |
|
ERROR (Error) |
ERROR (Error) |
|
REJECTED (Rejected) |
REJECTED (Rejected) |
|
SUBMITTED (Submitted) |
SUBMITTED (Submitted) |
|
WORKING (Working) |
WORKING (Working) |
Example for PeopleSoft
The Source Reported Timecard Entry Status Code is based on the values in PSXLATITEM (REPORTED_STATUS).
Example Implementation
| Source Member Code (Name) | Target Member Code (Name) |
|---|---|
|
AP (Approved) |
APPROVED |
|
CN (Cancelled) |
CANCELLED |
|
DN (Denied) |
REJECTED |
|
IE (In Error) |
ERROR |
|
IP (In Process) |
IN_PROCESS |
|
NA (Needs Approval) |
SUBMITTED |
|
NW (New) |
WORKING |
|
PR (Processed) |
PROCESSED |
|
PB (Pushed Back) |
PUSHED_BACK |
|
SV (Saved) |
WORKING |
|
Submitted (SB) |
SUBMITTED |
|
Voided (VD) |
VOIDED |
Source Processed Timecard Entry Status Code -> Processed Timecard Entry Status Code
This task is mandatory.
Used to identify which Source Processed Timecard Entry Status are mapped to Processed Timecard Entry Status; target domain members are used in the delivered metrics, dashboards and reports, for example, ESTIMATE (Estimated), TRNSFRD_TO_PAY (Transferred to Payroll). The target domain is Extensible - customers can add to but not delete from it.
Example for Fusion
The Source Reported Timecard Entry Status Code is based on the values in the FND look-up (HWM_UI_STATUS / HWM_USER_STATUS).
Example for E-Business Suite
On Oracle EBS (HXT_) the Source Processed Timecard Entry Status is the Batch Status.
On Oracle EBS (HXC_) the Source Processed Timecard Entry Status is a combination of the retrieval status and the retrieving application.
Example Implementation
| Source Member Code (Name) | Target Member Code (Name) |
|---|---|
|
SUCCESS:PAY (Retrieved by Payroll) |
TRNSFRD_TO_PAY (Transferred to Payroll) |
|
SUCCESS:PA (Retrieved by Projects) |
TRNSFRD_TO_PROJ (Transferred to Projects) |
|
SUCCESS:PO (Retrieved by Purchasing) |
TRNSFRD_TO_PURCH (Transferred to Purchasing) |
Example for PeopleSoft
On PeopleSoft the Source Processed Timecard Entry Status is the PSXLATITEM (PAYABLE_STATUS).
Example Implementation
| Source Member Code (Name) | Target Member Code (Name) |
|---|---|
|
OE (Online Estimate) |
ONLINE_ESTIMATE (Online Estimate) |
|
NA (Needs Approval) |
NEEDS_APPROVAL (Needs Approval) |
|
ES (Estimate) |
ESTIMATED (Estimated) |
|
AP (Approved) |
APPROVED (Approved) |
|
CL (Closed) |
<No value> |
|
SP (Sent to Payroll) |
<No value> |
|
RP (Rejected by Payroll) |
<No value> |
|
TP (Taken by Payroll) |
TAKEN_BY_PAY (Taken by Payroll) |
|
PD |
<No value> |
|
DL |
<No value> |
|
IG |
<No value> |
|
RV |
<No value> |
|
NP |
TRNSFRD_TO_PROJ (Transferred to Projects) |
|
DN |
<No value> |
|
PB |
<No value> |