Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

Capture change in TAX lines on RA_CUSTOMER_TRX_LINES_ALL on BICC extraction

edited Jul 21, 2024 3:10PM in Reporting and Analytics for ERP 2 comments

Summary: As per business, we understand they could change the Invoice Tax lines attached to a given invoice in Fusion. Since we maintain the Invoice Lines data in TRANSACTIONLINEEXTRACTPVO where Invoice Line ID is primary key. So need to know how we can capture such changes from fusion side in BICC extraction process.

Content (please ensure you mask any confidential information):

Invoice Lines being deleted/changed for given invoice in source needs to be captured somewhere. We need to know how we identify such changes for downstream systems. Also, please confirm how it is handled in FAW as it should have the same problem as BICC extracts have (Having duplicates downstream PVO tables).

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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