Receivables - EBS (MOSC)

MOSC Banner

Getting Error "FRM-40735: ON-INSERT trigger raised unhandled exception ORA-29471" while creating tra

edited Feb 26, 2018 4:00AM in Receivables - EBS (MOSC) 4 commentsAnswered

 While creating Transaction in AR, Sales person field not taking default as 'No Sales Credit' (-3) and remains blank. After choosing any value from for the mandatory field Sales person LoV, it returns  error -  "FRM-40735: ON-INSERT trigger raised unhandled exception ORA-29471" on saving the Transaction or on clicking the Line Item Tab. Hence not able to create AR Transaction.

I referred following note on Metalink - Transactions Workbench: Field Defaulting Logic (Doc ID 1413565.1)

Primary Salesperson -

Receivables uses following hierarchy to determine the Primary Salesperson to default:
The Salesrep defined at the customer Bill-To Site level
The Salesrep defined at the customer Ship-To Site level

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