Technology Stack - EBS (MOSC)

MOSC Banner

How to use Key Flex field in Oracle custom form

edited Aug 20, 2021 11:10AM in Technology Stack - EBS (MOSC) 1 commentAnswered

Hi,

We are creating Custom form for budget transfer. So ,we need to use custom Chart of account fields defined for our client.

When I am tring to invoking the key flexfield in new form instance trigger,i am getting an error.

I am attaching the form & error.


Code used in New-form-instance trigger :

FND_KEY_FLEX.DEFINE(

block => 'XXK_BATCH_TRANS_JRNL_LN',

Field => 'ACCT_CCD_DISPLAY',

Description => 'KACST_ACCOUNTING_FLEXFIELD',--'KACST Accounting Flexfield','KACST_ACCOUNTING_FLEXFIELD'

ID => 'acct_CCD',

Appl_short_name => 'SQLGL',

Code => 'GL#',

Num => '50388',

Vrule => 'GL_GLOBAL\nDETAIL_POSTING_ALLOWED \nE\nAPPL="SQLGL";

name=Parent Values are not allowed\nN'

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