SFPGRPST Process Uses Existing Item Number Instead Of Creating A New Item Number (Doc ID 2878798.1)

Last updated on NOVEMBER 20, 2024

Applies to:

Symptoms

On : 9.2 version, Group post
Two charges were posted via group post.
In one instance an EXISTING item number was updated in item_sf and a new line_seq_nbr was added in Item_line_sf for that item
in another instance a new item number was created for the charge.

Both charges where group posted.

Both Groups used Group type that was marked  "Create New Item"


We expect every group posted transaction in our Housing group type to create a new item number and respect the flag set on the group type.

 Steps to replicate: 

1. Set the HOUSING group type to 'Create New Item"
Student financials > Charges and Payment > Create Group Data entries

2. Create a new Group for the HOUSING group type.
Student financials > Charges and Payment > Create Group Data entries
The group should include 2 charges of the same item type, the same term for 2 unique students

3. Post your new group.
Student finanicals > Charges and payments > Group processing > Post transactions

4 Create a new Group for the HOUSING group type.
Student financials > Charges and Payment > Create Group Data entries
The group should include 2 cash payment item types for the same term as step 2 and the same 2 students as in step 2.
(Ideally make the payments less then the due amount so we aren't complicating this with excess payments.)
SAVE - DO NOT POST

5. Create a new Group for the HOUSING group type.
Student financials > Charges and Payment > Create Group Data entries
The group should include the same 2 charge item types, the same term for same 2 students as used in step 2.
SAVE - DO NOT POST

6. Post the 2 groups on the same run control/process instance
Student finanicals > Charges and payments > Group processing > Post transactions
Set your Starting group id to be the group id created in step 4 and the ending group id to be the group id created in step 5.

7 Review PS_ITEM_SF to see no new charge item was created.  Charge posted in Step 2 has been increased.

8 Review PS_ITEM_LINE_SF to see original charge item was increased with a LINE_SEQ_NBR

Cause

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