My Oracle Support Banner

INVSDSUB Receive an Error When Opening Subinventories Form FRM-41051: You cannot create records here After Setup Personalization to Disable Insert/Update/Delete (Doc ID 3018189.1)

Last updated on APRIL 26, 2024

Applies to:

Oracle Inventory Management - Version 12.2.12 and later
Information in this document applies to any platform.

Symptoms

After applying personalization to disable INSERT/UPDATE/DELETE for subinventories form as explained in document:  How to Setup Sales Orders form to be Read Only ? (Doc ID 2413313.1) #2 , the following error is received when opening the form and no data is displayed.

Error
FRM-41051 : You cannot create records here.

Steps to Reproduce

  1. (N)Inventory> Setup > Organizations > Subinventories
  2. Menu-bar > Help > Diagnostics > Custom Code > Personalize
  3. Create a personalization on 'WHEN-NEW-BLOCK-INSTANCE'
    Level: Form
    Enabled

    For the action, set the property of

    Seq: 10
    Object Type : Block
    Target Object : SUBINV
    Property Name : INSERT_ALLOWED
    Value: FALSE

    Seq: 20
    Object Type : Block
    Target Object : SUBINV
    Property Name : UPDATE_ALLOWED
    Value: FALSE

    Seq: 30
    Object Type : Block
    Target Object : SUBINV
    Property Name : DELETE_ALLOWED
    Value: FALSE

  4.  Close the form and open it again
  5. Receive the error and no data is displayed

Changes

 Upgrade from 12.0.6 to 12.2.12

Cause

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
Symptoms
Changes
Cause
Solution
References


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