Skip to main content

Example of $FLEX$ Syntax Used In Value Set







Example of $FLEX$ Syntax Used In Value Set ($flex$ in oracle apps)

Example of using “:$FLEX$.Value_Set_Name” to set up value sets where one segment depends on a prior segment that itself depends on a prior segment. Suppose you have a three-segment flexfield where the first segment is Country, the second segment is State, and the third segment is District. You could limit your third segment's values to only include Districts that are available for the Address specified in the first two segments. Your three value sets might be defined as follows: 


Segment Name              Country_Segment
Value Set Name             Country_Value_Set
Validation Table             Country_Table
Value Column               Country_NAME
Description Column     Country_DESCRIPTION
Hidden ID Column       Country_ID
SQL Where Clause       (none)


Segment Name             State_Segment
Value Set Name            State_Value_Set
Validation Table            State_Table
Value Column              State_Name
Description Column    State_DESCRIPTION
Hidden ID Column       State_ID
SQL Where Clause      WHERE Country_ID =
                                                                                 :$FLEX$.Country_Value_Set


Segment Name            District_Segment
Value Set Name           District_Value_Set
Validation Table           District_Table
Value Column              District_NAME
Description Column   District_DESCRIPTION
Hidden ID Column     District_ID
SQL Where Clause     WHERE Country_ID =
                                                                               :$FLEX$. Country_Value_Set
                                                                               AND Country_ID =
                                                                               :$FLEX$.State_Value_Set 


In this example, Country_ID is the hidden ID column and Country_Name is the value column of the Country_Value_Set value set. The Model segment uses the hidden ID column of the previous value set, Country_Value_Set, to compare against its WHERE clause. The end user never sees the hidden ID value for this example.

"Example of $FLEX$ Syntax Used in Oracle Apps ($flex$ in oracle apps) "


For More Information Visit on www.OracleAppsGuide.com Or Subscribe your email-id on OracleAppsGuide
Labels:

Comments

  1. Logan JackMarch 1, 2020 at 11:00 PM

    Glad to be one of the visitors on this awe inspiring web site : D. iphone template

    ReplyDelete
  2. YousufzaiMarch 8, 2020 at 12:15 PM

    Most appropriate the human race messages work to show your and present exclusive chance with special couple. Beginer appear system in advance of raucous people will most likely always be aware most of the golden value off presentation, which is a person’s truck. best man jokes iphone mockup

    ReplyDelete
  3. jacob oliviaMarch 13, 2020 at 3:12 AM

    I am definitely bookmarking this website and sharing it with my acquaintances. You will be getting plenty of visitors to your website from me! ipad png

    ReplyDelete
  4. UnknownMarch 25, 2020 at 11:57 AM

    Thanks for such a fantastic blog. Where else could anyone get that kind of info written in such a perfect way? I have a presentation that I am presently writhing on, and I have been on the look out for such great information. android mockup

    ReplyDelete
  5. UnknownMay 26, 2020 at 12:42 AM

    This is really fascinating, You are a very professional blogger. I’ve joined your rss feed and sit up for searching for more of your great post. Also, I have shared your site in my social networks! front end development company

    ReplyDelete

Post a Comment

Popular posts from this blog

AP, AR, GL, INV, PA, FA, PO, TCA, Workflow - Interface and Base table in Oracle Apps R12

Main Interface and Base table in Oracle Apps R12 GL Module (General Ledger Module tables in Oracle Apps R12) Interface Table Base Table gl_interface gl_budget_interface gl_je_batches gl_je_headers gl_je_lines gl_je_sources gl_je_categories gl_sets_of_books gl_daily_rates gl_balances gl_periods gl_period_sets gl_code_conbinations AR Module (Account Receivable Module  tables  in Oracle Apps R12) Interface Table Base Table ra_customers_interface_all   ra_contact_phones_int_all ra_customer_profiles_int_all hz_parties hz_cust_accounts hz_cust_acct_sites_all hz_cust_sit_use_all hz_party_sites hz_locations hz_party_site_uses hz_customer_profiles hz_organization_profiles hz_person_profiles ra_interface_lines_all ra_interface_distributions_all ra_interface_salescredits_all ra_customer_trx_all ra_customer_trx_lines_all ra_cust_trx_line_gl_dist_all ra_cust_trx_types_all ar_payment_schedules_all ra_batch_sources_All ar_vat_tax_all ra_terms ...
2 comments
Read more

Error: - APP-PER-50022: Oracle Human Resource Could Not Retrieve a Value For The User Type Profile Option. Please ensure it is set property for your responsibility

Error: - APP-PER-50022: Oracle Human Resource Could Not Retrieve a Value For The User Type Profile Option. Please ensure it is set the property for your responsibility. Solution-:      (1)  Go to System administrator > Profile > System       (2) Now Search “ HR: User Type ” Profile option at Responsibility level with Respective Responsibility. And Click On FIND Button. Now Select HR: User Type Value “HR with Payroll User” (you can choose another option as well accordingly). And SAVE. Now check your responsibility, error removed. Go ahead with your next step and enjoy Oracle Apps. For More Information Visit on www.OracleAppsGuide.com Or Subscribe your email-id on OracleAppsGuide.
3 comments
Read more

APP-PO-14624: Source organization is missing or invalid

APP-PO-14624: Source organization is missing or invalid. At the time of creating an internal requisition with Source name Inventory and entering the Organization name that time this error occurs. Firstly check whether used Item should be ‘Transactable’, ‘Stockable’ & ‘Internal order enabled’ at both level Source and destination Organizations. Go to Inventory > Items > Master Items > Find the Item. Now go to Inventory tab and check attribute ‘Stockable’ and ‘Transactable’ are checked or not (It should be).And In Order Management tab, check ‘Internal Orders enabled’ attribute is available. Careful –: If Item attribute ‘Internal ordered’ is enabled then we cannot enable “Internal Orders enabled” attribute. Unless all the above three attributes are enabled we cannot Proceed with the Internal Requisition. For More Information Visit on www.OracleAppsGuide.com Or Subscribe your email-id on OracleAppsGuide
Post a Comment
Read more