You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Error from SQL type DFF in applied receipt to get information from DFF in the applied transaction

I want to transfer information for a DFF in receivable transaction to the receipt when applying it

So i have created a DFF type SQL at AR_RECEIVABLE_APPLICATIONS, and entered the following default value

SELECT MAX(rcta.attribute5)
FROM ra_customer_trx_all rcta
WHERE rcta.customer_trx_id = araa.applied_customer_trx_id

after deploying the DFF

i tried to apply a transaction at the receipt and the following error appear

An application error occurred. See the incident log for more information.

An application error has occurred. Your help desk can use the following information to obtain a more detailed description of this incident: 77, Server Domain: FADomain, Server Instance: UIServer_1, Application Name: ORA_FSCM_UIAPP.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!