My Oracle Support Banner

[Data Fix] Resource [WIP_COST_TXN_INTERFACE (WCTI)]/ Material [MTL_MATERIAL_TRANSACTIONS (MMT)] Transactions Having Error CST_INVALID_JOB_DATE - Transaction Date Precedes Release Date For The Job/schedule (Doc ID 1461855.1)

Last updated on DECEMBER 10, 2024

Applies to:

Oracle Cost Management - Version 11.5.10.2 and later
Oracle Work in Process - Version 11.5.10.2 and later
Oracle Enterprise Asset Management - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

When viewing resource or materials transactions, observed erred transactions with the following error message

Error Code Explained
Error Code Error Message
CST_INVALID_JOB_DATE The transaction date precedes the release date of the job or schedule.

 

The erred transactions can be observed with any of the below steps

A. From the application you can view them using below navigation

    1. Follow the below responsibility[R] according to the product
        case A - [R] Enterprise Asset Management (EAM) or
        case B - [R] Manufacturing and Distribution Manager (WIP) or
        case C - [R] Cost Management-SLA

    2. Observed erred transactions in below navigation according to the product
        For resource transactions
            A. Work Order Transactions -> Pending Resource Transactions form
            B. WIP -> Resource Transactions -> Pending Resource Transactions form
            C. View Transactions -> Pending Resource Transactions form        

        For material transactions
            A. Inventory -> Transactions -> Material Transactions form
            B. WIP -> Material Transactions -> View Material Transactions form
            C. View Transactions -> Material Transactions form       

B. From the data base you can view them using below SQL scripts

    1. For Resource Transactions, the below query output display the errors


           
C. From data collection outputs for EAM Work Orders or WIP Discrete Jobs

    1. For EAM Work Orders below data collection for a single work order will provide all details
    Enterprise Asset Management - Work Order Data Collection Script (Doc ID 1448341.1)
    
    2. For WIP Discrete Jobs below data collection for a single discrete job will provide all details    
    Work In Process - Discrete / Lot Based Job Data Collection Script (Doc ID 1476250.1)   

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.