Descriptives Flexflieds in Oracle ebusiness suite R12

Few weeks ago, during a eBusiness Suite R12 System Administration course  a customer requested some help about the DFF (Descriptives Flexflieds). Customer wants to have the following behavior:
– When an invoice is enterred in AP (Oracle Account Payables) with a currency different from the ledger currency (USD for example) a DFF should appear with some mandatory segments
– If the invoice currency is the default then any DFF should appear.
The solution is the following one, we did it then tested it during the course:
1… Set the column ATTRIBUTE1 as Reference Field to be able to provide a value for Context
2… Return the fixed value NOT if the invoice currency is not the USD currency. The column ATTRIBUTE1 will be used to make this test
3… Setup one or more segments for the context value NOT
– Find here details with related screenshots:
1… (Responsibility) Application Developer, (Menu) Flexfields > Descriptives Flexibles > Register
Search the DFF by using
Application = Payables
Title = Invoice
Add the column ATTIBUTE1 like Field Name…
01_Reference Fields_ENU
2… In the Global Data Element we add a segment with a short SQL statement to feed the column ATTRIBUT1, this segment has no linked Value Set:
Default Type = SQL Statement
Default Value = SELECT ‘NOT’ FROM DUAL WHERE :INV_SUM_FOLDER.INVOICE_CURRENCY_CODE <> ‘USD’
With :
:INV_SUM_FOLDER is the name of the Forms BLOCK where the header of the invoice is enterred in AP
.INVOICE_CURRENCY_CODE is the name FIELD in the Forms used to enter the invoice in AP
02_Validation_ATTRIBUTE1_ENU
3… (Responsibility) Application Developer, (Menu) Flexfields > Descriptives Flexibles > Register
Search the DFF by using
Application = Payables
Title = Invoice
Set the mapping between the Context Field and the Reference Field previously added
Reference Field = ATTRIBUTE1
This Context Field will not be displayed…
03_DFF_Configuration_ENU
Add the requested segments for the value NOT used like Context Value which means the value returned by the ATTRIBUTE1:
04_Segments_for_Context_ENU
4… So, the final behavior is the expected one:
05_DFF_Invoice_ENU
That’s all !

Laisser un commentaire

Votre adresse e-mail ne sera pas publiée. Les champs obligatoires sont indiqués avec *