PRC: Transaction Import (PAXTRTRX) for OTL fails with pre_import ORA-04030 out of process memory (Doc ID 222674.1)

Last updated on JULY 15, 2016

Applies to:

Oracle Time and Labor - Version 11.5 to 12.2.1 [Release 11.5 to 12.2]
Oracle Project Costing - Version 11.5.1 to 12.2.1 [Release 11.5 to 12.2]
Information in this document applies to any platform.
***Checked for relevance on 04-JUN-2015***

Symptoms

Cannot Import timecards. 'PRC: Transaction Import' - PAXTRTRX fails when submitted against OTL (oracle time and labour).
Timecards get created and get routed thru workflow and got approved.


No error logged in alert_<SID>.log, but the request log/trace log shows different errors:
MSG-20002: ORA-20002: pre_import:ORA-04030: out of process memory when trying to allocate 16408 bytes (koh-kghu call ,pl/sql vc2)
ORA-04030: out of process memory when trying to allocate 32080 bytes (pga heap,ksm stack)
ORA-06512: at "APPS.HXC_GENERIC_RETRIEVAL_PKG", line 556
ORA-06512: at "APPS.HXC_GENERIC_RETRIEVAL_PKG", line 7366
ORA-06500: PL/SQL: storage error
ORA-06512: at "APPS.PA_TRX_IMPORT", line 3740
REP-1419: 'beforereport': PL/SQL program aborted.
[...]
Errors in file /appls3/oratest/TEST/testdb/8.1.7/admin/udump/ora_586878.trc:
ORA-00600: internal error code, arguments: [17091], [], [], [], [], [], [], []
ORA-04030: out of process memory when trying to allocate 32080 bytes (pga heap,ksm stack)
ORA-06512: at "APPS.HXC_GENERIC_RETRIEVAL_PKG", line 769
ORA-06512: at "APPS.HXC_GENERIC_RETRIEVAL_PKG", line 10372
ORA-06512: at "APPS.PA_OTC_API", line 976
ORA-04030: out of process memory when trying to allocate 32080 bytes (pga heap,ksm stack)
ORA-06512: at "APPS.HXC_GENERIC_RETRIEVAL_PKG", line 556
ORA-06512: at "APPS.HXC_GENERIC_RETRIEVAL_PKG", line 10318
ORA-04030: out of process memory when trying to allocate 32080 bytes (pga heap,ksm stack)
ORA-04030: out of process memory when trying to allocate 32080 bytes (pga heap,ksm stack)
ORA-06512: at "APPS.HXC_GENERIC_RETRIEVAL_PKG", line 556
ORA-06512: at "APPS.HXC_GENERIC_RETRIEVAL_PKG", line 7366
ORA-06500: PL/SQL: storage error
ORA-06512: at line 1
[...]
ora-600 kgepop

Changes

Check if you have pending transactions:
SELECT * from hxc_Transactions
where status = 'IN PROGRESS'
/
Update in-progress transactions:
update hxc_transactions
set status = 'ERRORS'
where status = 'IN PROGRESS'
/
Checked the oracle init parameters(shared_pool_size, sort_area_size, hash_area_size, open_cursors, ...)  - they're ok.

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