Release Purchase Order - Error Message - Customer number not found on the Supplier set up

  $CATEGORY:LPT/Q=APP_ERROR
         $MESSAGE:LPT/Q=Customer number not found on the Supplier set up.
         $NAME:LPT/Q=
         $SEVERITY:LPT/Q=1
         $EXTRAINFO:LPT/Q=ORA-20110: Customer number not found on the Supplier set up.
         $TRANSLATIONID:LPT/Q=
         $CAUSE:LPT/Q=ORA-20110: PurOrdChargedComp.NOCUSTNO: Customer number not found on the Supplier set up.
ORA-06512: at line 16
         $PLSQL:PLSQL
            (
               $ERROR_CALL_STACK:LPT/Q=__anonymous_block at line 10
PURCHASE_ORDER_API.RELEASE__ at line 14469
PURCHASE_ORDER_API.RELEASE__.CORE at line 14452
PURCHASE_ORDER_API.RELEASE__.BASE at line 14428
PURCHASE_ORDER_API.FINITE_STATE_MACHINE___ at line 14145
PURCHASE_ORDER_API.FINITE_STATE_MACHINE___.BASE at line 14033
PURCHASE_ORDER_API.ACTION_PLANNED_TO_RELEASED___ at line 16775
PURCHASE_ORDER_API.ACTION_PLANNED_TO_RELEASED___.CORE at line 16765
PUR_ORD_CHARGED_COMP_API.CREATE_CUSTOMER_ORDER at line 2975
PUR_ORD_CHARGED_COMP_API.CREATE_CUSTOMER_ORDER.CORE at line 2758
ERROR_SYS.RECORD_GENERAL at line 84
ERROR_SYS.RAISE_APPLICATION_ERROR___ at line 983
ERROR_SYS.RAISE_APPLICATION_ERROR___.FORMAT_CALL_STACK___ at line 977

               $ERROR_KEY_MESSAGE:LPT/Q=

Start Time: 8:58:42 PM,097
Category : Server Invoke[PL/SQL Command]
Sub Category : Error exception!
Info : BEGIN 
&AO.PURCHASE_ORDER_API.RELEASE__( :p0 , :p1 , :p2 , :p3 , :p4 ); 
EXCEPTION 
WHEN &AO.Error_SYS.Err_Security_Checkpoint THEN 
raise; 
WHEN OTHERS THEN 
rollback; 
raise; 
END;
Thread : 0x0010 - IFS Application Explorer Form Thread
Requested URL : http://edcoprod.edco.local:58080/fndext/clientgateway/AccessPlsql/Invoke?frmPurchaseOrder
Redirected URL : 
Request Id : 1a8b1a2d-fa61-4d81-aa8b-b3323a28cc76
Duration (ms): 45
DB Statements Executed : 4
DB Rows Fetched : 0
External Calls : -1
GZip Acc/Req/Resp : 1/1/1
Bytes Sent : 1147
Bytes Sent Compressed : 751
Bytes Sent Compression Ratio : 65%
Bytes Received : 23703
Buffer Parsing (ms) : 0
Record Parsing (ms) : 
Exception : ORA-20110: Customer number not found on the Supplier set up.
 

Hi @EDCLISA ,

The error might be occurring because your site’s purchase component method is set up for 'Customer Order' and one of the parts on the Purchase Order, has a purchase structure.

Thus, when you release the purchase order, a customer order will be created to ship the component parts to the supplier via the CO.

Do you want the part to have a purchase structure?  If so, then create a Customer record for your supplier and enter it on Supplier/Purchase Tab/Genera; Tab - customer no field.

If not, use the workaround below. 

WORK AROUND:

1.) Create a new revision for your Purchase Structure - RMB in the header of your Purchase Structure to 'Copy Structure Revision' to create a new revision.

2.) Leave the new Purchase Structure in a 'Tentative' state, then your Purchase Order will work like a normal Purchase Order.  The error only occurs if the Purchase Structure is set to "Buildable".

If the above does not help may be you have to raise a support case to further investigate this.

Best Regards,

Yasanthi

Thanks for your help.   I was able to find the part with an issue and create a Tentative purchase structure and release the order after I added the part back to the sales order after making changes.  Thanks for your help!