Oracle Apps SCM: flex fields

Enable Descriptive Flexfield At Header Level In View Requisitions Page

Set the profile POR: Context value for Requisition header descriptive flexfield.

1.Click the Personalize Page link
2. In the Personalization Structure click Complete View
3. Click Expand All
4. Click Personalize for Default Single Column: Additional Information
5. Change Rendered to True
6. Click Apply
7. Click Personalize in Flex: ReqHeaderDFF
8. Change Rendered to True
9. Click Apply

FRIDAY, DECEMBER 11, 2015

AOL - Creating a Custom Account Flex Field Parameter for Concurrent Program in Oracle

We have seen in seeded GL reports that take the accounting flex field as parameters, the DFF form opens on the SRS form when we click on the flex field parameter. The user enters the flex field into the form. The flex field is then transferred into the report and the output is generated. This is a very handy way of allowing the user to enter the Accounting KFF.

To create a custom accounting flex field parameter, Below are the steps

Step 1: Create a RDF(XXAA_ACCT_FLEXFIELD_REP.rdf) with two(P_ACCT_LO, P_ACCT_HI) parameters, below is the query.

SELECT

GCC.CODE_COMBINATION_ID

,GCC.CONCATENATED_SEGMENTS

,GCC.SEGMENT1

,GCC.SEGMENT2

,GCC.SEGMENT3

,GCC.SEGMENT4

,GCC.SEGMENT5

FROM GL_CODE_COMBINATIONS_KFV GCC

WHERE 1=1

AND gcc.segment1 BETWEEN NVL (SUBSTR (:P_ACCT_LO, 1, 2), '00') AND NVL (SUBSTR (:P_ACCT_HI, 1, 2), '99')

AND gcc.segment2 BETWEEN NVL (SUBSTR (:P_ACCT_LO, 4, 3), '000') AND NVL (SUBSTR (:P_ACCT_HI, 4, 3), '999')

AND gcc.segment3 BETWEEN NVL (SUBSTR (:P_ACCT_LO, 8, 4), '0000') AND NVL (SUBSTR (:P_ACCT_HI, 8, 4), '9999')

AND gcc.segment4 BETWEEN NVL (SUBSTR (:P_ACCT_LO, 13, 4), '0000') AND NVL (SUBSTR (:P_ACCT_HI, 13, 4), '9999')

AND gcc.segment5 BETWEEN NVL (SUBSTR (:P_ACCT_LO, 18), '000') AND NVL (SUBSTR (:P_ACCT_HI, 18), '999')

ORDER BY 3,4,5,6,7

Compile the RDF and save

Step 2: Create a value set(XXAA_GL_SRS_LEDGER_FLEXFIELD) with validation type as Pair

Navigation : System Administrator àApplication àValidation àSet

Enter the value set name and select the validation type as Pair and click on the edit information

Pair :

Use the Validation Rules window to define special validation for a Special value set. You also use this window to define validation routines for a Pair value set.

You can use this region to define a value set that lets your users enter an entire key flexfield combination within a single report parameter. For example, you may want to pass concatenated Accounting Flexfield segments as a parameter to a report. With this type of value set, a user can enter the report parameter and then see the "normal" behavior of a key flexfield, such as the key flexfield window and segment validation associated with that key flexfield. You use Oracle Application Object Library flexfield routines for these special value sets

Enter the below code and save

-->Event : EDIT

FND POPIDR APPL_SHORT_NAME="SQLGL" CODE="GL#" REQUIRED="N" DISPLAY="1" DISPLAY="2" DISPLAY="3" DISPLAY="4" DISPLAY="5"VALIDATE="NONE" SEG=":!VALUE" DESC=":!MEANING" NAVIGATE="!DIR"

--> Event : VALIDATE

FND VALIDR APPL_SHORT_NAME="SQLGL" CODE="GL#" VALIDATE="NONE" REQUIRED="N" DISPLAY="1" DISPLAY="2" DISPLAY="3"DISPLAY="4" DISPLAY="5" DESC=":!MEANING" SEG=":!VALUE"