Saturday, 31 October 2020

How to find ASN number from customer PO Number

 How to find ASN number from customer PO Number


Supposed user has given you Customer number 'ABC1234' and ask you to find ASN number for this PO.

Please follow below given instruction to find out ASN number against customer PO number.

Step :

  1. Navigate to order management responsibility and open order organizer form
  2. Enter customer PO number value as 'ABC1234' and then click on find button 
  3. It will fetch order details , from header please copy order number
  4. Then navigate to shipping --> Transaction 
  5. Enter order number and click on find button
  6. Open delivery tab and in this form you will get delivery number which is ASN number. 

POAO/855: Acknowledgement 'ACK' Tables Are Not Populated

POAO/855: Acknowledgement 'ACK' Tables Are Not Populated (OE_HEADER_ACKS and OE_LINE_ACKS acknowledgments tables)


he Trading Partner EDI setup has been done for the Transaction Type "Purchase Order Change Acknowledgement" , hence expect the acknowledgement tables to be populated.

STEPS to generate POAO acknowledgement

1. Order Management Responsibility (OM)

2. Import the EDI Order using Order Import

3. Book this Order and find the acknowledgement tables are not populated


Please check below given setup must be missing for this issue

1. Go into the responsibility: Order Management Super User responsibility

2. Navigate to Customer > Standard

3. Query the Customer site for which the Trading Partner setup is done and setup a Sold To Purpose for this site with the Primary flag checked.

4. Retest the issue.


How can one resend an ASN if a customer states that the ASN was never received.

 How can one resend an ASN if a customer states that the ASN was never received.


How can one resend an ASN if a customer states that the ASN was never received.

Since the trip is already closed, Shipping Execution will not allow another Ship Confirm and Interface Trip Stop to be run for that transaction.  

It is not possible to retrigger the ASN from the Shipping Transactions Form.

You can run the concurrent program "Departure Shipment Notice Outbound" for the trip/stop to resubmit it.  This action should retrigger the ASN  and send to the customer.

Using Order Management Super User Responsibility

Navigation:  

Shipping-->Interfaces-->Run

Select Departure Ship Notice Outbound

Select a Trip Stop as the parameter and then submit.

This will create DSNO file on your server and further when your schedule 856 request set will run it will pick DSNO and further processed and sent it to customer.

Oracle EDI

EDI Standards Supported

The Oracle EDI Gateway product is designed to support any EDI standard supported by EDI translation software; it is not tailored to any specific EDI standard.

EDI Transaction Support

The following transactions are supported:

Inbound Transactions :

Outbound Transactions:


Oracle Fusion SQL Queries to get Sales Person/Sales Representative information for an Order

1) Get sales person details if the Sales Person ID is known SELECT  jrs.SALESREP_NUMBER  ,         jrs.status           ,         jrs.START_...