In this Document
Applies to:Oracle Inventory Management - Version 10.7 to 12.1.2 [Release 10.7 to 12.1]Information in this document applies to any platform. Executable:RCVTPO - Receiving Transaction Manager ***Checked for relevance on 20-Apr-2010*** PurposeFAQ for ASN. Questions and AnswersWhat is an ASN?
A: The ASN (Advanced Shipment Notice (856)) is a document that is sent to a buyer in advance of the buyer receiving the product. It is typically used within the context of an EDI environment. It can be used to list the contents of an expected shipment of goods as well as additional information relating to the shipment, such as order information, product description, physical characteristics, type of packaging, marking carrier information, and configuration of goods within the transportation equipment. In the implementation of the transaction the latest the ship notice may be sent is the time of shipment. In practice the ship notice just arrive before the shipment. The process flow is as follows: What are the business needs for an ASN?
Receive a Shipping notice in Advance.
What are the different ways of populating data in the interface table?The data can be populated in the interface table either by EDI, custom scripts that the customer can write (an example script is provided below) or via SQL Loader. The documentation is available in Oracle Manufacturing APIs and Open Interfaces Manual, Volume 1, Receiving Open interface between pages 658-690.The documentation clearly states which fields are required, which fields are optional and which fields are conditionally populated in each of the receiving open interface tables. A sample script is as follows. Save the below information in a file called asn.sql and run it . /*The following script is what we use to load data for testing. You run the asn.sql script in sqlplus which deletes old data from the
RCV_TRANSACTIONS_INTERFACE. This data is for a DELIVER transaction (TRANSACTION_TYPE ='RECEIVE' & AUTO_TRANSACT_CODE = 'DELIVER') -- DELIVER transaction Other supported types are (TRANSACTION_TYPE ='RECEIVE' & AUTO_TRANSACT_CODE = 'RECEIVE') -- RECEIVE transaction (TRANSACTION_TYPE = 'SHIP' & AUTO_TRANSACT_CODE = 'SHIP'/'RECEIVE') -- SHIP or SHIP and RECEIVE transaction
How can we debug if an error occurs?We can check in the po_interface_errors for errors with shipment numbers. As each ASN uses distinct shipment number, we can identify the error for the shipment. We may get a very generic error message RCV_ASN_NOT_ACCEPT. When we get the error message either there are a series of errors have occurred which cannot be handled or an undetermined error has occurred. To handle this kind of situation we have a script called runit.sql. This actually prints debug messages as the pre-processor process the interface records. We can also run the Receiving Interface report. This report shows you what warnings or errors occurred while the Receiving Transaction Processor was processing rows in the Receiving Open Interface tables. Rows processed in the Receiving Open Interface include Advance Shipment Notices (ASNs), receipts, and deliveries. Any errors that occur during this process are displayed in the Receiving Interface Errors report when you run the report. At the same time, the errors are also sent to the Oracle e–Commerce Gateway process responsible for generating Application Advices. (For example, Application Advices are sent back to suppliers detailing errors that occurred when the suppliers sent ASNs.) What are the profile options available for ASN?The profile option available for ASN is RCV: Fail All ASN Lines if One Line Fails. When this profile option is set to ‘YES’, when multiple lines are being processed, even if one line fails validations or errors, the valid lines also error out. Is ASN available for every customer?In R107, ASN is a controlled production, which means only customers in the controlledproduction list can use ASN. In R11 and R11i, it is available for all customers. Can we cancel a PO after shipping the ASN but before receiving the ASN?We cannot cancel a PO if ASN is yet to be received. |
FAQ: OPEN INTERFACES - ASN Transactions (Doc ID 225233.1)
最新推荐文章于 2021-03-09 15:21:33 发布