My Oracle Support Banner

R12:AP: Supplier Merge Request Failing With Column Phone_Line_Type Must Have a Value (Doc ID 2994478.1)

Last updated on DECEMBER 20, 2023

Applies to:

Oracle Payables - Version 12.0.0 and later
Information in this document applies to any platform.

Symptoms

Supplier merge request (APXVDDUP) is failing with error:

MSG-07380: Error in call AP_VENDOR_PARTY_MERGE_PKG.AP_TCA_Contact_Merge...
MSG-07390: Error in ap_tca_contact_merge call... l_msg_data:Either a Raw Phone Number or the Area Code and Phone Number should be passed.
MSG-07390: Error in ap_tca_contact_merge call... l_msg_data:Column phone_line_type must have a value.
MSG-07460: Error in function Duplicate_sites
MSG-03060: Failure in function BeforeReport
REP-1419: 'beforereport': PL/SQL program aborted.
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error


The issue can be reproduced at will with the following steps:
1. Payables Responsibility
2. Other->Request
3. Run-> Supplier merge

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.