Payables and Cash Management - EBS (MOSC)

MOSC Banner

How to mask taxpayer id in the trading partner lookup of the invoice workbench


All,

I am attempting to mask all but the last four digits of the taxpayer id when using the trading partner name LOV of the find invoices window in the invoice workbench.  Support had a note on it, but it is no longer applicable to 12.0.6  I retrieved the query from the form and inserted it as an argument of a form personalization, but I still get the error FRM-41826 Cannot replace group; columns don’t match LOV and FRM-41075 Error deleting group.

Below is the query from the record group for our version of R12. I just want to display the last four digits for hp.jgzz_fiscal_code num_1099

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