Receivables - EBS (MOSC)

MOSC Banner

Update Date of birth to NULL for PARTY_TYPE = PERSON

edited Apr 18, 2018 4:15AM in Receivables - EBS (MOSC) 2 commentsAnswered ✓

Hi Experts,

I have a requirement where I have to update the date of birth for records of party type = 'PERSON' in the table HZ_PERSON_PROFILES . When I do it from front-end

{

(R) Receivables Manager-->

(N)Customer --> Standard:

Search the customer via Registry_ID:

Go to Profiles TAB: Delete the DATE OF BIRTH

Click on SAVE: Click on APPLY

}

it is happening correctly and the date of birth column correctly sets to NULL in backend table (hz_person_profiles) . However when I am trying to do it from backend via API it is not working. The date of birth column doesn't change and sets to NULL as per expectation. However when I am giving a valid DATE the api updates the record correctly in hz_person_profiles table . Any help is much appreciated.

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