PAXTRTRX PRC: Transaction Import, In Case Or Error, Import The Project Reference On Next Record INVALID_TASK (Doc ID 2071035.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Grants Accounting - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On 12.1.3, standard PRC: Transaction Import is run which imports data from interface table.
When task is invalid , import programs errors with the error INVALID_TASK.
The program keeps the wrong project reference for the next record to be processed . Logfile shows the incorrect processing Project_ID, as below:

12:35:41:: Task : -1 , project id : 91018
12:35:41:: EXCEPTION:Project : 104327
12:35:41:: EXCEPTION:Task : -1
GMS :proc_project_task When no_data_found exception raised 100GMS :SQLERRM ORA-01403: no data foundGMS :Parameter project_number, task_number :104327,-1GMS :PROC_PROJECT_TASK returned x_success False12:35:42:: GMS_LD_PKG.PRE_PROCESS : Fetching liquidated Encumbrance for txn interface id : 6958620
12:35:42:: GMS_LD_PKG.PRE_PROCESS : Value of l_orig_enc_item_id
12:35:42:: GMS_LD_PKG.PRE_PROCESS : Value of l_net_zero_adj_flag
12:35:42:: Task : 021.001 , project id : 91018
12:35:42:: Trying to call the validate item proc
...
12:35:51:: Project : 104940
12:35:52:: This record validated
12:35:53:: GMS_LD_PKG.PRE_PROCESS : Fetching liquidated Encumbrance for txn interface id : 6958621
12:35:53:: GMS_LD_PKG.PRE_PROCESS : Value of l_orig_enc_item_id
12:35:53:: GMS_LD_PKG.PRE_PROCESS : Value of l_net_zero_adj_flag
12:35:53:: Task : 041.002 , project id : 91018
12:35:53:: EXCEPTION:Project : 104940
12:35:53:: EXCEPTION:Task : 041.002

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms