Introduction
This component can be used for requirements related to personalization where we want to restrict the user to create an RMA/Adjustment/Credit memo if certain(user-defined) conditions are not met.
Personalization at Transaction/Adjustment Form
Responsibility: Receivables
Form: Transaction
This personalization will restrict the users from creating adjustments against the invoices depending on the condition.
Condition: ‘N’=(SELECT NVL(ATTRIBUTE15 ,’N’)FROM RA_CUSTOMER_TRX_ALL WHERE customer_trx_id=:ADJ_ADJUST.CUSTOMER_TRX_ID AND TRX_DATE>’03-APR-2018′)
Personalization at sales order form for RMA creation
Responsibility: Order Management
Form : Sales Order
This personalization will restrict the users to create RMA against the invoices depending on the condition
Condition : ‘N’=(Select NVL(b.attribute15,’N’)
from ra_customer_trx_all b
where b.customer_trx_id=:Line.return_attribute1
and b.trx_date>’03-APR-2018′) and (:ORDER.ORDER_TYPE LIKE ‘%C/n’ or :ORDER.ORDER_TYPE LIKE ‘%C/N’)
Personalization at Transaction/Application Form
Responsibilty: Receivables
Form : Transaction
This personalization will restrict the users to create credit note memo against the invoices depending on the condition
Condition: ‘N’=(SELECT NVL(ATTRIBUTE15 ,’N’)FROM RA_CUSTOMER_TRX_ALL WHERE customer_trx_id=:APP_FOLDER.CUSTOMER_TRX_ID AND TRX_DATE>’16-FEB-2018′)
Summary
This Post described requirements related to personalization where we want to restrict the user to create an RMA/Adjustment/Credit memo if certain (user-defined) conditions are not met in Oracle EBS R12.
Got any queries?
Do drop a note by writing us at doyen.ebiz@gmail.com or use the comment section below to ask your questions.
