Monthly Archives: August 2015

Oracle EBS: Responsibilities shows Undefined due to Compatibility View Issue

rencontre entre femmes musulmanes site de rencontre pour adolescent quebec find out this here rencontres femmes dans le 27 recherche homme libre site rencontre djibouti kiffer kennenlernen online dating for adults with disabilities warren lichtenstein dating flirter verbe Oracle EBS: Responsibilities shows Undefined due to Compatibility View Issue

Issue

Login to Oracle Applications using Self-Service login page

Responsibilities shows as ‘Undefined’

Responsibilities_Shows_as_Undefined

 

Resolution

In Internet Explorer, Click on ‘Compatability View’ to display the responsibilities

Compatability View

 

Oracle EBS: Receivables AutoInvoice Import Errors: APP-AR-11526: ORA-00972: identifier is too long

Oracle EBS: Receivables AutoInvoice Import Errors: APP-AR-11526: ORA-00972: identifier is too long

Issue

Autoinvoice import program errors out on importing transactions from external sources with the below error

APP-AR-11526: ORA-00972: identifier is too long

Error Log

UPDATE RA_INTERFACE_LINES L1
SET REQUEST_ID = :b1,
LAST_UPDATE_DATE = sysdate,
LAST_UPDATED_BY = :b2,
LAST_UPDATE_LOGIN = :b3, 
CUSTOMER_TRX_ID = NULL, 
INTERFACE_LINE_ID = NVL(INTERFACE_LINE_ID,
RA_CUSTOMER_TRX_LINES_S.NEXTVAL),
SET_OF_BOOKS_ID = NVL(SET_OF_BOOKS_ID, :b4),
LINK_TO_LINE_ID =
(
SELECT INTERFACE_LINE_ID
FROM   RA_INTERFACE_LINES L2
WHERE  L2.REQUEST_ID = :b5
AND    L2.INTERFACE_LINE_CONTEXT = 'Global Data Elements'
AND    L1.LINK_TO_LINE_CONTEXT = L2.INTERFACE_LINE_CONTEXT
AND    L1.LINK_TO_LINE_IBUTE8 = L2.INTERFACE_LINE_IBUTE8
AND    L1.LINK_TO_LINE_RFACE_LINE_ATTRIBUTE1 = L2.INTERFACE_LINE_RFACE_LINE_ATTRIBUTE1

Cause

The Descriptive flexfield views for ‘Line Transaction Flexfield’ / ‘Transaction Information’ descriptive flexfields definitions have not been generated correctly.

Resolution

Context: ‘Global Data Elements’, Unfreeze the DFF definition, delete the existing attributes, Save, Freeze the DFF definition

Descriptive Flexfield Segments