My Oracle Support Banner

With Formula Security On Cannot Copy/Create New Formula Version, Error: FRM-40735: POST-FORMS-COMMIT trigger raised unhandled exception ORA-01403 (Doc ID 1553932.1)

Last updated on MARCH 01, 2019

Applies to:

Oracle Process Manufacturing Product Development - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.1.3 version, Product Development Formulas

When attempting to copy/create new formula version error occurs.
Customer reported that when updating a exiting formula, and formula security
enabled for that formula and responsibility, save it to a new version, then error shown up.

FRM-40735: POST-FORMS-COMMIT trigger raised unhandled exception ORA-01403

The issue can be reproduced at will with the following steps:
1. Formulator > Formula

Have formula security setup for two responsibilities.  Assign method: Manual and Access level: Automatic

Enable formula security for the organization. Now in the one responsibility query a formula and go to Tools > Assign access.

Include both responsibilities in this setup.

Now another user goes into the other responsibility, makes changes to the formula. Save and receives error.




To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.