详解EBS接口开发之库事务处理带提前发运通知(ASN)采购接收入库-补充

更新时间:2023-08-12 01:54:50 阅读: 评论:0

详解EBS接⼝开发之库事务处理带提前发运通知(ASN)采购接
收⼊库-补充
A)  Via ROI Create a ASN [ship,ship]  for a quantity =3 on STANDARD PURCHASE ORDER Create  via ROI an Advanced Shipment Notice ASN number F-ASN-PO-17646-3
for  Standard Purcha Order Number 17646 (PO_HEADER_ID=97981) on Vendor =F_Supplier of 3 items in destination organization V1 1) Inrt following Data:
. 1 record in RCV_HEADERS_INTERFACE
RECEIPT_SOURCE_CODE = VENDOR
ASN_TYPE  = ASN
TRANSACTION_TYPE=  NEW
AUTO_TRANSACT_CODE =  SHIP
SHIPMENT_NUM  = F-ASN-PO-17646-3
. 1 record in RCV_TRANSACTIONS_INTERFACE
TRANSACTION_TYPE =  SHIP
AUTO_TRANSACT_CODE = SHIP
RECEIPT_SOURCE_CODE = VENDOR
QUANTITY  = 3
U the inrt script of to create ASN shipment number
'F-ASN-PO-17646-3' SHIPMENT_NUM with quantity shipped=3
for Standard PO 17646 - Line 1 - Shipment line 1
INSERT INTO RCV_HEADERS_INTERFACE
(HEADER_INTERFACE_ID,
GROUP_ID,
PROCESSING_STATUS_CODE,
RECEIPT_SOURCE_CODE,
ASN_TYPE,
TRANSACTION_TYPE,
AUTO_TRANSACT_CODE,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
CREATION_DATE,
CREATED_BY,
SHIPMENT_NUM,
VENDOR_ID,
SHIP_TO_ORGANIZATION_ID,
SHIPPED_DATE,
EXPECTED_RECEIPT_DATE,
EMPLOYEE_ID,
ORG_ID,
VALIDATION_FLAG
)
VALUES
(rcv_headers_val , --Header_Interface_Id
rcv_interface_val,  --Group_Id
'PENDING', --Processing_Status_Code
'VENDOR', --Receipt_Source_Code
'ASN', --ASN_TYPE
'NEW', --Transaction_Type
'SHIP',  --Auto_Transact_Code
SYSDATE, --Last_Update_Date中国家电下乡网
0,  --Last_Updated_By
0,  --Last_Update_Login
SYSDATE, --Creation_Date
0, --Created_By
'F-ASN-PO-17646-3', --SHIPMENT_NUM
7927,  --Vendor_Id
204, -- SHIP_TO_ORGANIZATION_ID
SYSDATE, --SHIPPED_DATE
SYSDATE+1, --Expected_Receipt_Date
13706,    --Employee_Id
204, --Operating_Unit_Id
'Y'    --Validation_Flag
);
INSERT INTO RCV_TRANSACTIONS_INTERFACE
(INTERFACE_TRANSACTION_ID,
GROUP_ID,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_LOGIN,
TRANSACTION_TYPE,
TRANSACTION_DATE,
PROCESSING_STATUS_CODE,
PROCESSING_MODE_CODE,
TRANSACTION_STATUS_CODE,
QUANTITY,
UNIT_OF_MEASURE,
ITEM_ID,
AUTO_TRANSACT_CODE,
RECEIPT_SOURCE_CODE,
SOURCE_DOCUMENT_CODE,
DOCUMENT_NUM,
DOCUMENT_LINE_NUM,
SHIP_TO_LOCATION_ID,
TO_ORGANIZATION_ID,
HEADER_INTERFACE_ID,
ORG_ID,
VALIDATION_FLAG
)
SELECT
rcv_transactions_val, --Interface_Transaction_id            rcv_interface_groups_s.currval,        --Group_id
SYSDATE,              --Last_update_date
0,                    --Last_updated_by
SYSDATE,              --Creation_date
0,                    --Created_by
0,                    --Last_update_login
'SHIP',              --TRANSACTION_TYPE_SHIP
SYSDATE,              --TRANSACTION_DATE
'PENDING',            --PROCESSING_STATUS_CODE
'BATCH',              --PROCESSING_MODE_CODE
'PENDING',            --TRANSACTION_STATUS_CODE
3,                    --QUANTITY
'Each',              --UNIT_OF_MEASURE
新视野大学英语3课文翻译26816,                --ITEM_ID
'SHIP',              --AUTO_TRANSACT_CODE
'VENDOR',            --RECEIPT_SOURCE_CODE
'PO',                --SOURCE_DOCUMENT_CODEhair dryer
'17646',              --DOCUMENT_NUM
'1',                  --DOCUMENT_LINE_NUM
204,                  --SHIP_TO_LOCATION_ID
204,                  --TO_ORGANIZATION_ID
rcv_headers_interface_s.currval, --Header_interface_id
204,                  --ORG_ID
'Y'    --Validation_Flag
FROM DUAL;
COMMIT;
Note: On R12 instance, RHI.ORG_ID or RTI.ORG_id need to be populated. On 11.5.10 instance in RHI and in RTI ORG_ID columns do not exist
2) Run the following scripts to check data have been correctly inrted SQL> Select * from RCV_HEADERS_INTERFACE
where SHIPMENT_NUM like 'F-ASN-PO-17646-3%;
HEADER_INTERFACE_ID    488353
皇家墨尔本理工大学GROUP_ID        63266
PROCESSING_STATUS_CODE  PENDING
RECEIPT_SOURCE_CODE    VENDOR
ASN_TYPE        ASN
TRANSACTION_TYPE        NEW
四级查分网站AUTO_TRANSACT_CODE      SHIP
LAST_UPDATE_DATE        11/01/2008 12:14:52
LAST_UPDATED_BY 0
LAST_UPDATE_LOGIN      0
CREATION_DATE  11/01/2008 12:14:52
CREATED_BY      0
SHIPMENT_NUM    F-ASN-PO-17646-3
RECEIPT_NUM
RECEIPT_HEADER_ID
valuesFROM_ORGANIZATION_ID
SHIP_TO_ORGANIZATION_CODE
SHIP_TO_ORGANIZATION_ID 204
LOCATION_CODE
SHIPPED_DATE    11/01/2008 12:14:52
FREIGHT_CARRIER_CODE
EXPECTED_RECEIPT_DATE  11/01/2008 12:14:52
EMPLOYEE_ID    13706
VALIDATION_FLAG Y
ORG_ID 204
PROCESSING_REQUEST_ID
SQL> Select * from RCV_TRANSACTIONS_INTERFACE where HEADER_INTERFACE_ID=488353;
INTERFACE_TRANSACTION_ID        2159384
GROUP_ID        63266
TRANSACTION_TYPE        SHIP
TRANSACTION_DATE        11/01/2008 12:15:12
PROCESSING_STATUS_CODE  PENDING
PROCESSING_MODE_CODE    BATCH
PROCESSING_REQUEST_ID
TRANSACTION_STATUS_CODE PENDING
QUANTITY        3
UNIT_OF_MEASURE Each
ITEM_ID 26816
AUTO_TRANSACT_CODE      SHIP
SHIPMENT_HEADER_ID
SHIPMENT_LINE_ID
SHIP_TO_LOCATION_ID    204
RECEIPT_SOURCE_CODE    VENDOR
TO_ORGANIZATION_ID      204
SOURCE_DOCUMENT_CODE    PO
HEADER_INTERFACE_ID    488353
DOCUMENT_NUM    17646
DOCUMENT_LINE_NUM      1
ORG_ID 204
VALIDATION_FLAG Y
3) In Purchasing Responsibility, Change to receiving organization V1 and run the Receiving Transaction Processor for the given group_id ud in RHI and RTI: Run RVCTP  for GROUP_ID=63266
-> Request 6913750 RVCTP module: Receiving Transaction Processor
4) Navigate to Manage Shipments form
Org V1
Receiving/Manage Shipments
In Manage Shipments form
Find In-Transit Shipments
Search Criteria
Source Type=Supplier
Shipment = F-ASN-PO-17646-3
One shipment line is retrieved for Qty Shipped =3 for PO Number 17646
5)  Check how the following application tables have been populated/updated
SQL> Select * from RCV_HEADERS_INTERFACE
where SHIPMENT_NUM like 'F-ASN-PO-17646-3%;
HEADER_INTERFACE_ID    488353
GROUP_ID        63266
RECEIPT_HEADER_ID 1920749
PROCESSING_STATUS_CODE  SUCCESS
PROCESSING_REQUEST_ID  6913750
SQL> Select * from RCV_SHIPMENT_HEADERS
where SHIPMENT_NUM like 'F-ASN-PO-17646-3%;
1 record has been created
SHIPMENT_HEADER_ID      1920749
RECEIPT_SOURCE_CODE    VENDOR
VENDOR_ID      7927
VENDOR_SITE_ID  4724
SHIPMENT_NUM    F-ASN-PO-17646-3
RECEIPT_NUM
SHIPPED_DATE    11/01/2008 12:14:52
EXPECTED_RECEIPT_DATE  12/01/2008 12:14:52
EMPLOYEE_ID    13706
REQUEST_ID      6913750
ASN_TYPE        ASN
ASN_STATUS      NEW_SHIP
SHIP_TO_ORG_ID  204
SQL> Select * from RCV_SHIPMENT_LINES where SHIPMENT_HEADER_ID=&Shipment_header_id;
->One record with
SHIPMENT_LINE_ID        1874712
SHIPMENT_HEADER_ID      1920749
LINE_NUM        1
CATEGORY_ID    1
QUANTITY_SHIPPED        3
QUANTITY_RECEIVED      0
UNIT_OF_MEASURE Each
ITEM_DESCRIPTION        Standard Purchad Item
ITEM_ID 26816
SHIPMENT_LINE_STATUS_CODE      EXPECTED
SOURCE_DOCUMENT_CODE    PO
PO_HEADER_ID    97981
PO_LINE_ID      105281
PO_LINE_LOCATION_ID    139830
PO_DISTRIBUTION_ID
DESTINATION_TYPE_CODE  RECEIVING
TO_ORGANIZATION_ID      204
REQUEST_ID      6913750
PRIMARY_UNIT_OF_MEASURE Each
ASN_LINE_FLAG  Y
ORIGINAL_ASN_PARENT_LINE_ID
ORIGINAL_ASN_LINE_FLAG
SHIP_TO_LOCATION_ID    204
B)  Via ROI Create a Receive / Deliver transaction  for a quantity =1  on ASN already created Perform the deliver transaction for the ASN for a quantity = 1
Follow instructions of    For Receiving an ASN which is already  created and
1)  Inrt the following data
. 1 record in RCV_HEADERS_INTERFACE
RECEIPT_SOURCE_CODE = VENDOR
ASN_TYPE  = null (or STD)
TRANSACTION_TYPE=  NEW
AUTO_TRANSACT_CODE =  DELIVER
SHIPMENT_NUM  = RCV_SHIPMENT_HEADERS.SHIPMENT_NUM
RECEIPT_HEADER_ID = RCV_SHIPMENT_HEADERS.SHIPMENT_HEADER_ID
VENDOR_ID= RCV_SHIPMENT_HEADERS.VENDOR_ID
. 1 record in RCV_TRANSACTIONS_INTERFACE
TRANSACTION_TYPE=  RECEIVE
AUTO_TRANSACT_CODE =  DELIVER
RECEIPT_SOURCE_CODE = VENDOR
VENDOR_ID= RCV_SHIPMENT_HEADERS.VENDOR_ID
QUANTITY  = 1
SHIPMENT_HEADER_ID = RCV_SHIPMENT_HEADERS.SHIPMENT_HEADER_ID
SHIPMENT_LINE_ID = RCV_SHIPMENT_LINES.SHIPMENT_LINE_ID
PO_HEADER_ID=PO_HEADERS_ALL.PO_HEADER_ID
INSERT INTO RCV_HEADERS_INTERFACE
(HEADER_INTERFACE_ID,
GROUP_ID,
PROCESSING_STATUS_CODE,
RECEIPT_SOURCE_CODE,
ASN_TYPE,
TRANSACTION_TYPE,
AUTO_TRANSACT_CODE,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
CREATION_DATE,
CREATED_BY,
SHIPMENT_NUM,
RECEIPT_HEADER_ID,
VENDOR_ID,
SHIP_TO_ORGANIZATION_ID,
EXPECTED_RECEIPT_DATE,
EMPLOYEE_ID,
ORG_ID,
VALIDATION_FLAG
)
VALUES
(rcv_headers_val , --Header_Interface_Id
rcv_interface_val,  --Group_Id
'PENDING', --Processing_Status_Code
'VENDOR', --Receipt_Source_Code
null, --ASN_TYPE
'NEW', --Transaction_Type
'DELIVER',  --Auto_Transact_Code
SYSDATE, --Last_Update_Date
0,  --Last_Updated_By
0,  --Last_Update_Login
SYSDATE, --Creation_Date
0, --Created_By
'F-ASN-PO-17646-3', --SHIPMENT_NUM
1920749,  --RECEIPT_HEADER_ID
7927,    --VENDOR_ID
204, -- SHIP_TO_ORGANIZATION_ID
SYSDATE+1, --Expected_Receipt_Date
13706,    --Employee_Id
204,      --Org_Id
'Y'    --Validation_Flag
);
INSERT INTO RCV_TRANSACTIONS_INTERFACE
(INTERFACE_TRANSACTION_ID,
GROUP_ID,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_LOGIN,
TRANSACTION_TYPE,
TRANSACTION_DATE,
PROCESSING_STATUS_CODE,
莫言演讲稿
PROCESSING_MODE_CODE,
TRANSACTION_STATUS_CODE,
QUANTITY,
UNIT_OF_MEASURE,
ITEM_ID,
AUTO_TRANSACT_CODE,
SHIPMENT_HEADER_ID,
初中阅读题及答案SHIPMENT_LINE_ID,
SHIP_TO_LOCATION_ID,
RECEIPT_SOURCE_CODE,
VENDOR_ID,
TO_ORGANIZATION_ID,
PO_HEADER_ID,
DESTINATION_TYPE_CODE,
DELIVER_TO_PERSON_ID,
LOCATION_ID,
DELIVER_TO_LOCATION_ID,
SUBINVENTORY,
HEADER_INTERFACE_ID,
ORG_ID,
VALIDATION_FLAG
)
SELECT
rcv_transactions_val, --Interface_Transaction_id            rcv_interface_groups_s.currval,        --Group_id
SYSDATE,              --Last_update_date
mofos
0,                    --Last_updated_by
SYSDATE,              --Creation_date
0,                    --Created_by
0,                    --Last_update_login
'RECEIVE',              --TRANSACTION_TYPE_RECEIVE
SYSDATE,              --TRANSACTION_DATE
'PENDING',            --PROCESSING_STATUS_CODE
'BATCH',              --PROCESSING_MODE_CODE
'PENDING',            --TRANSACTION_STATUS_CODE
1,                    --QUANTITY
'Each',              --UNIT_OF_MEASURE
26816,                --ITEM_ID
'DELIVER',              --AUTO_TRANSACT_CODE
1920749,                --SHIPMENT_HEADER_ID
1874712,                  --SHIPMENT_LINE_ID
204,                  --SHIP_TO_LOCATION_ID
'VENDOR',            --RECEIPT_SOURCE_CODE
7927,                --VENDOR_ID
204,                  --TO_ORGANIZATION_ID
97981,          --PO_HEADER_ID
'INVENTORY',          --DESTINATION_TYPE_CODE
13706,                --DELIVER_TO_PERSON_ID
204,                  --LOCATION_ID
204,                  --DELIVER_TO_LOCATION_ID
'Stores',            --SUBINVENTORY
rcv_headers_interface_s.currval, --Header_interface_id
204,                  --ORG_ID
'Y'                  --VALIDATION_FLAG
FROM DUAL;
COMMIT;
Note: On R12 instance, RHI.ORG_ID or RTI.ORG_ID need to be populated. On 11.5.10 instance in RHI and in RTI ORG_ID columns do not exist
2) Run the following scripts to check data have been correctly inrted SQL> Select * from RCV_HEADERS_INTERFACE
where SHIPMENT_NUM like 'F-ASN-PO-17646-3%;
There is a new record with
HEADER_INTERFACE_ID    491353
GROUP_ID        63406
PROCESSING_STATUS_CODE  PENDING
RECEIPT_SOURCE_CODE    VENDOR
ASN_TYPE                null建设工程施工合同管理办法
TRANSACTION_TYPE        NEW

本文发布于:2023-08-12 01:54:50,感谢您对本站的认可!

本文链接:https://www.wtabcd.cn/fanwen/fan/78/1129651.html

版权声明:本站内容均来自互联网,仅供演示用,请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系,我们将在24小时内删除。

标签:通知   课文   大学   管理   详解   皇家
相关文章
留言与评论(共有 0 条评论)
   
验证码:
推荐文章
排行榜
Copyright ©2019-2022 Comsenz Inc.Powered by © 专利检索| 网站地图