From where the PROCESSED_DATE gets saved in Oracle Commission Tables?
Hi All,
Using Oracle 11.5.10 version.
We have seen PROCESSED_DATE column in the below commission tables,
CN_COMM_LINES_API_ALL
CN_COMM_HEADERS_ALL
What date this column stores and from where it gets the value. I have seen that BOOKED_DATE is Order Booked Date and it is different from PROCESSED_DATE in some records and there are records which has same value for both the dates.
Can you please tell me from where the processed_Date gets value and what is the action which brings this different date than order booked date for the records which have TRX_TYPE in ORD, INV & PMT.