FTP Process Fails With Segmentation Fault When TP Rule Uses Holiday Calendar (Doc ID 2942264.1)

Last updated on MAY 02, 2023

Applies to:

Symptoms

When running an FTP process, data is not getting populated in the target tables.  The Transfer Pricing Engine log ends with the following SQL:

Module Logging OFS Access module data: /* 203: *io_lookup::GetID*/

Module Logging OFS Access module data: select
select FSI_ENGINE_LOOKUP.group_num, FSI_ENGINE_LOOKUP.num_key,
FSI_ENGINE_LOOKUP.char_key, FSI_ENGINE_LOOKUP.description
from FSI_ENGINE_LOOKUP
where FSI_ENGINE_LOOKUP.group_num = 405.00000
and FSI_ENGINE_LOOKUP.num_key = 0.00000
order by FSI_ENGINE_LOOKUP.description

When you run the FTP Process using the Command Line format, you get the following error:

Running TP, Process ID: 200704
ID_TYPE = 204
Segmentation fault

Checking the Transfer Pricing Rules, the product definitions reference a Holiday Calendar.

You cannot determine what causes the process to fail.

Cause

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