Straight Time (Labor Hours).Straight Time (Labor Hours).Expense Reports.Usages.Inventory.Work in Progress.Miscellaneous.Supplier Invoices.Database Script | Description |
wm_install_into_labor.sql | Runs all the scripts listed below, except the uninstall script. |
wm_into_labor_pkg.sql | Installs WM_LABOR_IMP_HANDLER_PKG. WM_HANDLE_LABORTXN, which calls the WM_CONC_REQUEST.WM_REQUEST_SUBMIT to submit the labor import process. The process in the Project Accounting module is PRC: Transaction Import. |
wm_into_labor_seq.sql | Installs WM_PA_GROUP_S sequence which generates BATCH_ID. |
wm_drop_into_labor.sql | Uninstalls all components created by wm_install_into_labor.sql. |
setLaborTxn1227.txpLaborTransactions1227.txpspecifyDefaultSettings specifies the default parameter settings required for service execution. You should change these settings accordingly.specifyConcProgParams specifies the default parameter settings required for concurrent program execution. You should change these settings accordingly.generateBatchName gets the BATCH_NAME for the current set of Labor records.pickSequence generates the current sequence number from the sequence, WM_PA_GROUP_S.bizDocMapping maps the incoming business document structure to the required Oracle Applications data structures (the interface tables).getOrgId is a transformer for mapping the business document IData structure to the interface table IData structure. It takes ORGANIZATION_NAME as the input parameter and queries the table ORG_ORGANIZATION_DEFINITIONS and gets the ORGANIZATION_ID corresponding to the ORGANIZATION_NAME.getCodeCombinationId is a transformer for mapping the business document IData structure to the interface table IData structure. This service gets CODE_COMBINATION_ID from GL_CODE_COMBINATIONS_KFV given the CONCATENATED_SEGMENTS.getSystemLinkage is a transformer for mapping the business document IData structure to the interface table IData structure. It takes EXPENDITURE_CLASS as the input parameter and queries the table PA_SYSTEM_LINKAGES to get SYSTEM_LINKAGE.setLaborTxn inserts data into the interface table. It extracts data from the IData structure resulted in the bizDocMapping service and puts the data into the interface table in Oracle Applications for Labor.importLabor imports data to the production table from the interface table. It calls the execLaborConcProg, checkLaborImportStatus, and getLaborImport_ERR services to execute the corresponding concurrent program that inserts data into the production table and to generate the error or acknowledgment message. If the execution of executeConcProgram returns the status of SUCCESS, it checks for the record with the current BATCH_NAME in the interface table. If any are found, it then generates an error during import. In this case, this service calls getLaborImport_ERR to retrieve the errors. If no record is found, it exits the flow and the data import process is successful.execLaborConcProg invokes the stored procedure WM_LABORTXN_IMP_HANDLER_PKG.WM_HANDLE_LABORTXN that calls the corresponding concurrent subroutine to execute the data import process for Labor into Oracle Applications. This service produces Status ID, Request ID, Execution Status Message for normal concurrent program completion, and a database Stored Procedure error message (if an exception occurs in the Stored Procedure execution).checkLaborImportStatus checks execution status by checking the interface table for any rejected records corresponding to the current BATCH_NAME. If it does not return any rows, the import was successful. If it returns a row, the concurrent program could not import data successfully in the Oracle Applications production tables.getLaborImport_ERR gets the error message that occurs during data import to the production table from the interface table. Based on the parameter BATCH_NAME, it scans the PA_TRANSACTION_INTERFACE_ALL table to get the corresponding message matches to the BATCH_NAME.LABOR_BIZDOCField Name | Maps to Column | Description |
TRANSACTION_ SOURCE | TRANSACTION_ SOURCE | Required. Source of the transaction is defined in the Transaction Sources window in Oracle Projects. Use values such as Default Expenditure Type Class, GL Accounted, Costed, or Uncosted. |
EXPENDITURE_ ENDING_DATE | EXPENDITURE_ ENDING_DATE | Required. Last day of the expenditure week. |
EMPLOYEE_ NUMBER | EMPLOYEE_ NUMBER | Required for Expenditure Type class as Labor and Expense Reports. Employee number of the employee who incurred charges. |
CHARGE_ ORGANIZATION_ NAME | ORGANIZATION_ NAME | Name of the organization that incurred the charge for this transaction. |
EXPENDITURE_ ITEM_DATE | EXPENDITURE_ ITEM_DATE | Required. Date when the transaction occurred. |
PROJECT_NUMBER | PROJECT_ NUMBER | Required. Project number that incurred the expenditure. |
TASK_NUMBER | TASK_ NUMBER | Required. Task number for the project. |
EXPENDITURE_TYPE | EXPENDITURE_ TYPE | Required. Expenditure that classifies this transaction. The expenditure type and expenditure type class must have a valid combination in the PA_EXPEND_TYP_SYS_LINKS table. |
NON_LABOR_ RESOURCE | NON_LABOR_ RESOURCE | Non-labor resource for the transaction. |
NON_LABOR_ RESOURCE_ORG_ NAME | NON_LABOR_ RESOURCE_ ORG_NAME | Name of the organization owning the non-labor resource. |
QUANTITY | QUANTITY | Required. Number of units for the transaction based on the expenditure type. |
RAW_COST | RAW_COST | Raw cost amount. |
EXPENDITURE_ COMMENT | EXPENDITURE_ COMMENT | Description for the transaction. |
TRANSACTION_ STATUS_CODE | ||
ORIG_TRANSACTION_ REFERENCE | ORIG_ TRANSACTION_ REFERENCE | Required. Unique reference to identify this record. |
RAW_COST_RATE | RAW_COST_RATE | Raw cost rate of the costed transaction. |
UNMATCHED_ NEGATIVE_TXN_ FLAG | UNMATCHED_ NEGATIVE_ TXN_FLAG | Indicates whether the transaction is an unmatched negative transaction and is not adjusted against an expenditure item. |
ORGANIZATION_NAME | ORG_ID | Organization name for the transaction. Populates the ORG_ID for a multi- organization setup. The getOrgId service is invoked to get the ORGANIZATION_ID. |
DR_CODE_ COMBINATION | DR_CODE_ COMBINATION_ ID | Populates the DR_CODE_COMBINATION_ID for accounted transactions. The getCodeCombinationID service is invoked to get the code combination ID. |
CR_CODE_ COMBINATION | CR_CODE_ COMBINATION_ ID | Populates the CR_CODE_COMBINATION_ID for accounted transactions. The getCodeCombinationID service is invoked to get the code combination ID. |
CDL_SYSTEM_ REFERENCE1 | CDL_SYSTEM_ REFERENCE1 | Use the external system to drill down to the transaction in the original system. |
CDL_SYSTEM_ REFERENCE2 | CDL_SYSTEM_ REFERENCE2 | |
CDL_SYSTEM_ REFERENCE3 | CDL_SYSTEM_ REFERENCE3 | |
GL_DATE | GL_DATE | General Ledger date if the transaction has already been accounted. |
BURDENED_COST_ RATE | BURDENED_ COST_RATE | Burdened cost multiplier that Oracle Applications uses for reporting purposes. |
EXPENDITURE_CLASS | SYSTEM_ LINKAGE | Fetch the System Linkage function from PA_SYSTEM_LINKAGES using the Meaning column as the expenditure class. Populate SYSTEM_LINKAGE column with this value. You must define the combination of the expenditure type and System Linkage function in Oracle Projects. The getSystemLinkage service is invoked to get the expenditure class. |
USER_TRANSACTION_ SOURCE | USER_ TRANSACTION_ SOURCE | Must be defined in PA_TRANSACTION_ USER_TRANSACTION_ SOURCE. |
RECEIPT_CURRENCY_ AMOUNT | RECEIPT_ CURRENCY_ AMOUNT | Amount of the expenditure in original currency. |
RECEIPT_CURRENCY_ CODE | RECEIPT_ CURRENCY_ CODE | Currency code for receipt currency. |
RECEIPT_EXCHANGE_ RATE | RECEIPT_ EXCHANGE_ RATE | Exchange rate to convert from the receipt currency to the transaction currency (reimbursement currency). |
DENOM_CURRENCY_ CODE | DENOM_ CURRENCY_ CODE | Currency code for the transaction currency. |
DENOM_RAW_ COST | DENOM_ RAW_COST | Raw cost amount in the transaction currency. |
DENOM_BURDENED_ COST | DENOM_ BURDENED_ COST | Burdened cost amount in the transaction currency. |
ACCT_RATE_DATE | ACCT_ RATE_DATE | Exchange rate for converting to the functional currency. |
ACCT_RATE_TYPE | ACCT_ RATE_TYPE | Conversion type for converting to the functional currency. |
ACCT_EXCHANGE_ RATE | ACCT_ EXCHANGE_ RATE | Exchange rate for converting to the functional currency. |
ACCT_RAW_COST | ACCT_ RAW_COST | Raw cost in functional currency. For accounted transactions, the import transaction compares this value to the value calculated from DENOM_RAW_COST to ensure it is within the ACCT_EXCHANGE_ROUNDING_LIMIT. |
ACCT_BURDENED_ COST | ACCT_ BURDENED_ COST | The burdened cost in the functional currency |
ACCT_EXCHANGE_ ROUNDING_LIMIT | ACCT_ EXCHANGE_ ROUNDING_ LIMIT | Functional currency rounding limit. If null, then the rounding limit is 0. |
PROJECT_RATE_DATE | PROJECT_ RATE_DATE | Exchange rate date for converting to project currency. |
PROJECT_RATE_TYPE | PROJECT_ RATE_TYPE | Conversion rate type used to convert to the project currency. |
PROJECT_EXCHANGE_ RATE | PROJECT_ EXCHANGE_ RATE | The exchange rate for converting to project currency. |
ORIG_EXP_TXN_ REFERENCE1 | ORIG_EXP_TXN_ REFERENCE1 | Expenditure identifier in the external system. |
ORIG_EXP_TXN_ REFERENCE2 | ORIG_EXP_TXN_ REFERENCE2 | Columns provided for additional grouping. |
ORIG_EXP_TXN_ REFERENCE3 | ORIG_EXP_TXN_ REFERENCE3 | Used for additional grouping. |
ORIG_USER_EXP_TXN_ REFERENCE | ORIG_USER_ EXP_TXN_ REFERENCE | Expenditure identifier in the external system (User Reference). |
VENDOR_NUMBER | VENDOR_ NUMBER | For supplier invoices. |
OVERRIDE_TO_ ORGANIZATION_NAME | OVERRIDE_TO_ ORGANIZATION_ NAME | Overrides Organization_Name. |
REVERSED_ORIG_TXN_ REFERENCE | REVERSED_ ORIG_TXN_ REFERENCE | Reference identifier of the original transaction that this transaction reverses. |
BILLABLE_FLAG | BILLABLE_ FLAG | Billable or capitalizable flag. |
PROJECT_RAW_COST | PROJECT_ RAW_COST | Raw cost in project currency. |
PROJECT_BURDENED_ COST | PROJECT_ BURDENED_ COST | Burdened cost in project currency. |