My Oracle Support Banner

R12:OIE: Expense Report Has Null Attribute_Category in AP_EXPENSE_REPORT_LINES_ALL Table When Long Expense Item (Doc ID 2483723.1)

Last updated on JANUARY 03, 2024

Applies to:

Oracle Internet Expenses - Version 12.0.0 and later
Information in this document applies to any platform.


DFF(expense report line) is configured on the expense type, but when set expense item length more than 30 characters in expense template, AP_EXPENSE_REPORT_LINES_ALL.attribute_category will be null for new saved expense reports.

When DFF(expense report line) is configured on the expense type, AP_EXPENSE_REPORT_LINES_ALL.attribute_category should be populated.

The issue can be reproduced at will with the following steps:
1. Navigate to Payables > Setup > Invoice > Expense Report Templates
2. Query template name
3. Set expense item with length more than 30 characters, save
4. Navigate to iExpenses > Expense Home, create new expense report and save
5. Check AP_EXPENSE_REPORT_LINES_ALL.attribute_category column, it is null


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.