| Supplier Merge ( problem) [message #153058] |
Wed, 28 December 2005 15:51 |
dcouliba
Messages: 2
Registered: December 2005
Location: Lille-France
|
Junior Member |
|
|
Hello everybody
I have this when i launch the supplier merge program, i have this message. Who can help me to resolve the problem ?
This is the message text
fact: Oracle Payables 11.5.5
fact: APXINUPD - Merge Suppliers
symptom: Running report fails with error
symptom: REP-01401: 'c_modify_rfq_vendorsformula' Fatal PL/SQL error
occurred
symptom: ORA-01403: no data found
symptom: Issue occurs when there is a contract in PO on the supplier site
cause: The cause of this problem is still undetermined
Complete error message:
MSG-00001: After SRWINIT
MSG-00002: After Get_Company_Name
MSG-00003: After Get_NLS_Strings
MSG-00004: After Get_Base_Curr_Data
MSG-00007: After Custom_Init
MSG-01000: Checking for duplicate tax sites...
MSG-01001: Selecting duplicate vendor sites...
MSG-01002: Modifying recurring payments...
MSG-01004: Selecting duplicate vendors (INV)...
MSG-01003: Updating Vendor...
MSG-01005: Selecting duplicate vendors (PO)...
REP-1401: 'c_modify_rfq_vendorsformula': Fatal PL/SQL error occurred.
ORA-01403: No data found
MSG-00020: After SRWEXIT
fix:
Workaround:
Change report function <c_modify_rfq_vendorsformula> :
From:
UPDATE po_headers
SET vendor_id=:C_VENDOR_ID_PO,
vendor_site_id=:C_VENDOR_SITE_ID_PO,
last_updated_by=:P_LAST_UPDATED_BY,
last_update_date=sysdate
WHERE po_header_id=:C_PO_HEADER_ID;
To:
srw.do_sql('UPDATE po_headers
SET vendor_id=:C_VENDOR_ID_PO,
vendor_site_id=:C_VENDOR_SITE_ID_PO,
last_updated_by=:P_LAST_UPDATED_BY,
last_update_date=sysdate
WHERE po_header_id=:C_PO_HEADER_ID');
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
