OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » Oracle Date Track

Home » Applications » Oracle Fusion Apps & E-Business Suite » Oracle Date Track - preserve future Effective Dates (Oracle Applications 12.1.3)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 21 09:50:16 CST 2024