Chart of Accounts Segment Descriptions in Oracle EBS

Chart of Accounts Segment Descriptions in Oracle EBS R12 You can use the following query to get the description of COA of Oracle EBS by using apps.gl_flexfields_pkg.get_description_sql and avoid hideous number of joins back to FND_FLEX_VALUES_TL and generally hard-code in value set ids. SELECT gcc.code_combination_id                 ,gcc.segment1                 ,gcc.segment2                 ,gcc.segment3  ...

Read More

APP-AR-96983 : User Write-off limit does not exist

APP-AR-96983 : User Write-off limit does not exist Today when I was working on Receipts (Oracle R12.1.3) and tried to write-off receipt application shows the error 'APP-AR-96983 : User Write-off limit does not exist' as illustrated below:  APP-AR-96983 : User Write-off limit does not exist Solution: Use Receivables Responsibility. 1. Define user write-off limit The Navigation Path is: Setup > Transactions > Approval Limit Enter...

Read More