Population Update of Fiscal Item Type Table ITEM_TYPE_FISCL Populates All Amounts With Same Value Even When Different Values are Specified in External File Population Select (Doc ID 2793682.1)

Last updated on JANUARY 25, 2024

Applies to:

Symptoms

When using Population update to update the fiscal item type table, using an external file as the Pop Select method, the three amount fields are always assigned the same value, regardless of what is specified in the file. Typically the MAX_OFR_BUDGT might be assigned an amount higher than MAX_ACC_BUDGT which is in turn higher than MAX_DSB_BUDGT, and in those situations the process should be assigning the amounts from the file.

The issue can be reproduced at will with the following steps:

1. Navigate to Setup SACR > System Administration > Utilities > File Parser > Population Selection File Map to set up a Population Select file map with the SSF_PU_IFSC_BND record.
2. Create file with one or more rows and fields in the same order as specified in the bind, and the 3 amount fields set each to a different amount. Offer should be highest, followed by accept, followed by disbursed.
3. Navigate to Setup SACR > System Administration > Utilities > Population Update > Population Update Setup. Add a record for ITEM_TYPE_FISCL with the 3 fields.
4. Navigate to Navigate to Setup SACR > System Administration > Utilities > Population Update > Population Update process.
5. Populate the parameters.  In the population selection section, set selection tool as external file, upload file from step 2 and select file mapping from step 1.
6. Click 'Preview Selection Results' to see the problem with how the file will load, with all amounts the same, rather than the 3 different amounts.

This specific functional issue is related to the more general problem described in <Note 2795492.1>-Population Selection/Population Update File Parser Adapter Does not Always Correctly Process External Files.

Cause

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