When releasing a purchase order, the following error appears “Customer number not found on the Supplier set up.”
The user said that they have been doing this and that nothing has changed. I was trying to see if there was a setup issue with he parts on the order.
$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
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!
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
