Home » Applications » Oracle Fusion Apps & E-Business Suite » Oracle Date Track - preserve future Effective Dates (Oracle Applications 12.1.3)
Oracle Date Track - preserve future Effective Dates [message #681474] Tue, 21 July 2020 11:01
GOS-BT-Oracle
Messages: 1
Registered: July 2020
Junior Member
Fictional Example of Date Tracked Data:

01-JAN-2016 to 31-DEC-2016 YES
01-JAN-2017 to 31-DEC-2017 YES
01-JAN-2018 to 31-DEC-2018 YES
01-JAN-2019 to 31-DEC-2019 YES

On 01-JUL-2018, I want change YES to NO, make it an update, and change all future stuff - with one transaction

I *think* it would need to look like this: (using UPDATE_OVERRIDE mode)

01-JAN-2016 to 31-DEC-2016 YES
01-JAN-2017 to 31-DEC-2017 YES
01-JAN-2018 to 30-JUN-2018 YES
01-JUL-2018 to 31-DEC-2019 NO

But ideally, I'd want it to look like this (below). Is there a datetrack mode available for this, or would I need to make several updates, using a combination of UPDATE and CORRECTION mode?

01-JAN-2016 to 31-DEC-2016 YES
01-JAN-2017 to 31-DEC-2017 YES
01-JAN-2018 to 30-JUN-2018 YES
01-JUL-2018 to 31-DEC-2018 NO
01-JAN-2019 to 31-DEC-2019 NO

Previous Topic: Cost Collection Manager:CSTPPCCB.pm_process_txn_mmt(30): No data found
Next Topic: AP Check Voucher/Remittance Report
Goto Forum:
  


Current Time: Tue Sep 29 00:22:07 CDT 2020