Sunday, May 11, 2014

R12: GL posting ends in ORA-00001

Staying with my R12 updates, you will need to verify you don't run into the issue detailed in the MOS document "GLPPOS: Posting Terminated With ORA-00001: unique constraint (GL.GL_JE_HEADERS_U2)" in ID 758785.1 because there is a known restriction on the uniqueness/length of the journal names.  The problem?  It doesn't seem like the uniqueness is enforced 100% of the time, so you will need to verify how the business sends this data into the system to ensure it will not hit this error.

No comments:

Post a Comment