VIEW MRP_AP_CUSTOMERS_V ONLY 50 CHARACTERS FOR COLUMN PARTNER_NAME (Doc ID 1305510.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 11.5.10.2 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.

Goal

It was noted that during the ASCP collections the Customer Name gets truncated to a 50 character limit as it refers to the MRP_AP_CUSTOMERS_V view where the party_name is having the restriction. This is causing concerns when the Customer Name length exceeds 50 characters and is not being collected completely into ASCP as well as Demantra. Hence there is a data integrity issue and the users are unable to work with the right Customer information.

Can this field partner_name in the view be extended?

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms