Payables and Cash Management - EBS (MOSC)

MOSC Banner

Copy values from Invoice Line Description to Invoice distributions for PO Matched invoices

edited Jul 20, 2018 3:56AM in Payables and Cash Management - EBS (MOSC) 7 commentsAnswered ✓

Hi all,

We  have a requirement to automatically copy values from Invoice Line Description to Invoice distributions for PO Matched invoices. As per the standard functionality the Distributions description is defaulted from the PO.

We are using form personalization and the following is our setting:

Condition:

Trigger Event: WHEN-NEW-RECORD-INSTANCE

Trigger Object: D_SUM_FOLDER

Processing Mode: Not in Enter-Query Mode

Action:

Type- Property

Object Type: Item

Target Object : D_SUM_FOLDER.DESCRIPTION

Property Name: VALUE

Value:

Could someone help to with the query that should be written for the fields 'Value'. We need to copy LINE_SUM_FOLDER.DESCRIPTION  to D_SUM_FOLDER.DESCRIPTION

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center