Requisition Import Fails With Multi_distribution Error (Doc ID 1348417.1)

Last updated on MARCH 15, 2022

Applies to:

Symptoms

Unable to successfully import Multiple distributions using Requisition import process due to error:
'You have specified multiple distributions to be created. There are no rows in the requisition distributions interface table.'

Steps to reproduce:

1- Load the interface tables:
 
  INSERT INTO PO_REQUISITIONS_INTERFACE_ALL
(INTERFACE_SOURCE_CODE,
batch_id,
transaction_id,
ORG_ID,
DESTINATION_TYPE_CODE,
AUTHORIZATION_STATUS,
PREPARER_ID,
SOURCE_TYPE_CODE,
UNIT_OF_MEASURE,
LINE_TYPE_ID,
ITEM_ID,
UNIT_PRICE,
QUANTITY,
DESTINATION_ORGANIZATION_ID,
DELIVER_TO_LOCATION_ID,
DELIVER_TO_REQUESTOR_ID,
multi_distributions,
req_dist_sequence_id)
values ('PASS', --Interface Source
1,-- batch_id
PO_REQUISITIONS_INTERFACE_S.nextval, -- transaction_id
81, --Operating Unit
'EXPENSE', --Destination Type
'INCOMPLETE', --Status
61, --This comes from per_people_f.person_id
'VENDOR', --Source Type
'Each', --UOM
1, --Line Type of Goods
3, -- Item id
10, --Price
10, --quantity
81, --dcg
142, --deliver to location id
61, --This is the Deliver to Requestor
'Y',
PO_REQ_DIST_INTERFACE_S.nextval);


INSERT INTO po_req_dist_interface_all
(interface_source_code,
batch_id,
transaction_id,
charge_account_id ,
distribution_number,
dist_sequence_id,
quantity
)
values
('PASS',
1,
PO_REQUISITIONS_INTERFACE_S.currval,
13050,
1,
PO_REQ_DIST_INTERFACE_S.currval,
5
) ;

INSERT INTO po_req_dist_interface_all
(interface_source_code,
batch_id,
transaction_id,
charge_account_id ,
distribution_number,
dist_sequence_id,
quantity
)
values
('PASS',
1,
PO_REQUISITIONS_INTERFACE_S.currval,
1003,
2,
PO_REQ_DIST_INTERFACE_S.currval,
5
) ;

2- Submit Requisition Import with Multiple Distribution parameter = Yes

Cause

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