PAXTRTRX module: PRC: Transaction Import Failed in GET_PATC api sqlerror:100 (Doc ID 1569632.1)

Last updated on NOVEMBER 17, 2022

Applies to:

Symptoms

This example of a PAXTRTRX module: PRC: Transaction Import shows the following error.

10:39:23:  ValidateItem: log_message: Calling pa_transactions_pub.validate_transaction
10:39:23:  ValidateItem: Log: Stage:PATC:10.10.001 GET_STATUS API
10:39:23:  ValidateItem: Log: IN PARAMS : Project_id:[9999] Task_id :[99999] EI_date:[31-MAY-13]Exp Type:[51150A Resident] non_labor_resource:[]person_id:[111]quantity:[-1160.47]denom_currency_code:[USD]acct_currency_code:[USD]transfer_ei:[]incurred_by_or
g_id:[207]vendor_id:[]Sys
10:39:23:  ValidateItem: Log: Stage:PATC:10.10.002
10:39:23:  ValidateItem: Log: Stage:PATC:10.10.003
10:39:23:  ValidateItem: Log: Stage:PATC:10.10.004
10:39:23:  ValidateItem: Log: Calling Check_fin_Task_published
10:39:23:  ValidateItem: Log: Failed in GET_PATC api sqlerror:100
10:39:23:  ValidateItem: log_message: After pa_transactions_pub.validate_transaction
10:39:23:  ValidateItem: log_message: Validate_transaction has failed
10:39:23: Import1: log_message: Calling PA_GMS_API api
10:39:23: Import1: log_message: After PA_GMS_API api
10:39:23:: log_message: Updating txn interface table for txn rejected by validateitem
10:39:23:: log_message: Updated to reject count 1

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.