Impacted of delete operation on Finance module PVOs — Oracle Analytics

Oracle Transactional Business Intelligence Idea Lab

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Impacted of delete operation on Finance module PVOs

21
Views
1
Comments

Organization Name

Ricoh Europe PLC

Description

Please provide a document which has list of PVOs for Finance module where delete operation has impact. We need need to have this document because Ricoh is looking for it from past few weeks. We do not have any handy document where we can identify for delete what all PVOs can be impacted.

Use Case and Business Need

IN BICC we identify the deleted records for a particular PVO by primary key comparison. We are aware about the process. In this case the ask is what all PVOs can be impacted by delete operation from front end.

The background for asking this question

Ricoh planning to extract data from Fusion and load the data in already existing DWH and other downstream systems. They are looking for the active records as well as the delete records and find the same based on standard BICC process. The number of PVO is huge so Ricoh don't want to perform primary key comparison operation to find deleted records for all PVOs, rather they want a list of PVOs where any delete can be impacted based on Fusion standard business processes. Primary key extraction will take place only those identified PVOs which have impact for delete operation from front end.

Original Idea Number: f6386368db

2
2 votes

Submitted · Last Updated

Comments