How to prorate Freight across taxable/non-taxable Items, prorate Tax on taxable items and Freight

Oracle EBS version 12.1.3 -> Payables

We are trying to process an invoice through Payables Open Invoice Import Interface (APXIIMPT) with this scenario: prorate Freight across taxable and non-taxable Item lines and prorate Tax on taxable Item lines and Freight line only.

Example:

We tried importing the invoice with the above line_group_number and prorate_across_flag values but it did not allocate Freight across all items.

Does anyone encountered this scenario? If so, please share what was the solution for this scenario.