Thursday, 26 April 2018

Personalization at Adjustment/Sales order/Credit Memo application form


This component can be used, for requirement related to personalization where we want to restrict the user to create RMA/Adjustment/Credit memo if certain(user defined) conditions are not met.



Personalization at Transaction/Adjustment Form

Responsibilty: Receivables

Form       : Transaction

This personalization will restrict the users to create 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')








4 comments:

  1. PLSQL Android Apps - Useful productivity solution for Oracle consultants, please it checkout in google play store :

    Code profiler App
    https://play.google.com/store/apps/details?id=appinventor.ai_pshreedhar.PLSQL_Review1

    Plsql Flowchart App
    https://play.google.com/store/apps/details?id=appinventor.ai_pshreedhar.PLSQL_Flow2

    and also check out the solution demo in Youtube

    https://youtu.be/Wckm1_s9Y0M?list=PLqfoPI5nmJaNJNleopCOYh3rqX-8zraqU

    ReplyDelete
  2. Your website is very good and nice information was provided in your site, thanks for sharing.
    Oracle HRMS Training in Ameerpet

    ReplyDelete
  3. It's interesting to read blog about punchout cxml.
    Punchout CXML

    ReplyDelete
  4. Thanks for sharing very good information about OCI Punchout.
    OCI Punchout

    ReplyDelete