Revenue Management

Get Involved. Join the Conversation.

Topic

    Aashik Datta
    Purge Contract Import Interface Table
    Topic posted July 30, 2019 by Aashik DattaRed Ribbon: 250+ Points, tagged Revenue Management 
    101 Views, 4 Comments
    Title:
    Purge Contract Import Interface Table
    Summary:
    How to purge record from VRM_SOURCE_DOCUMENTS
    Content:

    We want to purge records from the interface tables of 

    VRM_SOURCE_DOCUMENTS , VRM_SOURCE_DOC_LINES , VRM_SOURCE_DOC_SUB_LINES

    how to submit a program which can purge based on certain parameters. 

     

    Comment

     

    • Ajay Tadakamadala

      If you want to delete unprocessed or rejected data, set line status to Purged in Correct contract document ADFDI spreadsheet.

      There is ESS process to purge records Source document tables.

    • Aashik Datta

      Hi Ajay 

       Probably I am not able to understand it. The ADFDI Spreadsheet has three tabs. 

      They have respectively Header Status, Line Status and Subline Status both at the Parent Block and the Child block lines.

      And when I update any of the status to PURGE . and press upload, apparently it processes only that particular tab and not the whole sheet. (all the three tables) 

       What am I missing ? 

      Regards

      Aashik

      • Mikhail Bakharev

        Hi Aashik,

        That indeed works sheet by sheet.

        You should delete records from each of the datasheets independently. Firstly delete all entries from Document Sub Lines datasheet, then from Document Lines and finally from Document.

        Regards,

        Mikhail

    • Himanshu Ailawadi

      I did the following steps 

      1. Open the ADFDI Spreadsheet

      2. Queried the Documents Error Records for a Ledger

      3. Changed the Header Status to Purged

      4. Pressed the Upload Button

      5. ESS Process completed successfully, but the record in not purged.

      Am I missing something ???

       

      --Himanshu