Showing posts with label EDI. Show all posts
Showing posts with label EDI. Show all posts

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.


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_...