Receivables - EBS (MOSC)

MOSC Banner

DQM "use as filter" attribute

edited Jun 9, 2017 5:00AM in Receivables - EBS (MOSC) 1 commentAnswered

Hi,

I want to filter some customers using the "advanced search" DQM screen using a custom attribute (since the attribute I need is not included in the attributes list). I have created a PLSQL function to filter the customers at the acquisition moment. My function returns "NULL" whenever there is a  NO_DATA_FOUND exception. Is that OK, since I want to filter the customers right from the acquisition moment?.

Then I have assigned the new attribute to a match rule and defined the usage as "use as filter", without any display sequence, since I don’t want to display it. I have recreated all the staging data and cleared the cache memory. For some reason my new attribute is displayed and the data is not filtered, as if my function has not filtered any customer.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center