E-Business Suite

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Source Organization is not getting populated for Internal Requisition from Interface table

BommiSep 22 2023 — edited Sep 22 2023

Hi Team,

We are using R12.2.8.
In PO_REQUISITIONS_INTERFACE_ALL table we are populating source_organization_id and source_organization_code for Internal Requisitions(and requisition_type as INTERNAL).
After this we are running Requisition Import progam to create requisitions.
By this Internal Requisitions are getting created, but the Source Organization is not getting populated.

Do anyone help me on this. Am I missing anything else in PO_REQUISITIONS_INTERFACE_ALL table or any setups need to be done?
Below are the fields we are populating in interface table.

INTERFACE_SOURCE_CODE
ORG_ID 
DESTINATION_TYPE_CODE 
AUTHORIZATION_STATUS 
ITEM_SEGMENT1 
ITEM_ID 
SOURCE_ORGANIZATION_ID 
DESTINATION_ORGANIZATION_ID 
UOM_CODE 
QUANTITY 
NEED_BY_DATE 
REQUISITION_TYPE 
SOURCE_TYPE_CODE 
GROUP_CODE 
LINE_ATTRIBUTE11 
CREATION_DATE 
LAST_UPDATE_DATE 
LAST_UPDATED_BY 
CREATED_BY 
DELIVER_TO_LOCATION_ID 
PREPARER_ID 
DELIVER_TO_REQUESTOR_ID 
AUTOSOURCE_FLAG 
SUGGESTED_VENDOR_ID 
SUGGESTED_VENDOR_SITE_ID

Thanks in Advance,
Bommi

This post has been answered by Bommi on Sep 26 2023

Jump to Answer

Added on Sep 22 2023

#interface, #internalrequisitions, #plsql, #purchasing, #requisitionimport

2 comments

236 views