Hi all,
I an getting the below error while processing Requisition Import Through Interface
The error Populated in PO_INTERFACE_ERRORS is--
If Oracle Projects is installed and PROJECT_ACCOUNTING_CONTEXT is 'Y' then project, task, expenditure type, expenditure item date and expenditure organization must be valid
Cause:The project, task, expenditure type, expenditure item date or expenditure organization that you entered is invalid. These fields are required if the Oracle Projects context is 'Y'
Action:Enter a valid project, task, expenditure type, expenditure item date and expenditure organization
In Application->Purchasing Screen, I created the Purchase Requisition With The Project Details Which i have given in the Interface.Requisition Created where as in Interface its Ending with error.
Below Code is for your reference
DECLARE
L_TRANSACTION_ID NUMBER;
BEGIN
SELECT PO_REQUISITIONS_INTERFACE_S.NEXTVAL INTO L_TRANSACTION_ID FROM DUAL;
INSERT
INTO PO_REQUISITIONS_INTERFACE_ALL
(
INTERFACE_SOURCE_CODE,
DOCUMENT_TYPE_cODE,
BATCH_ID,
transaction_id,
ORG_ID,
DESTINATION_TYPE_CODE,
AUTHORIZATION_STATUS,
PREPARER_ID,
SOURCE_TYPE_CODE,
UOM_CODE,
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,
charge_account_id,
PROCESS_FLAG,
NEED_BY_DATE,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATION_DATE,
CREATED_BY,
PROJECT_ID,
TASK_ID,
PROJECT_ACCOUNTING_CONTEXT,
EXPENDITURE_TYPE,
EXPENDITURE_ITEM_DATE,
expenditure_organization_id
)
VALUES
(
'MTO REQUISITIONS', --Interface Source
'PURCHASE', --DOCUMENT_TYPE_cODE
1, -- batch_id
L_TRANSACTION_ID, -- transaction_id
122, --Operating Unit
'INVENTORY', --Destination Type
'INCOMPLETE', --Status
3498, --This comes from per_people_f.person_id
'VENDOR', --Source Type
'PCS', --UOM
1, --Line Type of Goods
2005, -- Item id
13.66, --Price
5, --quantity
142, --dcg
144, --deliver to location id
3498, --This is the Deliver to Requestor
'Y', -- multiple distributions
PO_REQ_DIST_INTERFACE_S.NEXTVAL, -- dist id
1003,
1,
SYSDATE+1,
SYSDATE,
2533,
SYSDATE,
2533,
2009, --:PRR_BLK.PROJECT_ID,
18253, --:PRR_BLK.TASK_ID,
'Y',
'AL-PROFILES' ,
SYSDATE,
142
);
INSERT
INTO po_req_dist_interface_all
(
interface_source_code,
BATCH_ID,
process_flag,
transaction_id,
charge_account_id ,
distribution_number,
dist_sequence_id,
QUANTITY ,
PROJECT_ID,
TASK_ID,
PROJECT_ACCOUNTING_CONTEXT,
EXPENDITURE_TYPE,
EXPENDITURE_ITEM_DATE,
expenditure_organization_id
)
VALUES
(
'MTO REQUISITIONS',
1,
1 ,
L_TRANSACTION_ID,
1003,
1,
PO_REQ_DIST_INTERFACE_S.CURRVAL,
5 ,
2009, --:PRR_BLK.PROJECT_ID,
18253, --:PRR_BLK.TASK_ID,
'Y',
'AL-PROFILES' ,
SYSDATE,
142
) ;
COMMIT;
END;
Please suggest a solution .