Wednesday, April 30, 2025

Creating DFF for Lookup in Oracle Fusion

1. Manage Descriptive Flexfields 
2. Search the Flexfield Code : FND_LOOKUP_VALUES_B 
3. Click Edit Icon 
4. Click Manage Contexts 
5. Create New Context or search existing context 
6. Add or Edit Existing Segments 
7. Save and Close 
8. Click Deploy Flexfield 

Note : You need to open a new session to see the changes.

Job Anniversary Days

 

Formulas

Years  : DATEDIF(A2,B2,"Y")
Months : DATEDIF(A2,B2,"YM")
Days   : DATEDIF(A2,B2,"MD")

Is Anniversary Today : 
    IF(AND((D2=0),(E2=0)),"Yes","No")

IS Anniversary In Next Week : 
    IF( AND((D2=11),(DATEDIF(A2,B2+7,"MD") >=0)),"Yes","No")




Export To Excel From BIP Report - Date Format Is General And Doesn't Convert To Date

 

Symptoms

After you export the BI Report to excel, the date format is shown as  general in Excel and doesn't convert to date.

This way you cannot filter on the date Columns even if you change their format to Data.

Cause

The issue is with Microsoft Excel where it does not recognize the Date due to a Tab Delimiter appended to the Date Value

Solution

Please use the following workaround in Microsoft Excel to convert the date columns from General to Date Select the date column in question.

  1. From the File Menu, choose Data => Text to Columns.
  2. On first screen leave the radio button on "delimited" and click Next.
  3. Uncheck any of the delimiter boxes (any boxes blank; no check marks) and click Next.
  4. Under column data format choose the Date Format you want.