1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Service Contract Query

Discussion in 'Oracle CRM' started by sniffing, Aug 21, 2013.

  1. sniffing

    sniffing Guest

    Hi-

    I am new to Service to Contracts and trying to come up with a query to Find all Contracts that are ready to be created as invoice but didn't get transferred to Ra_interface_lines_all table.

    I need to find which table has billing date for the Contract and also how to find if a contract is ready to be Invoiced. Any help would be really appretiated.


    Thanks,,
     
  2. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi ,

    I think after completing the Billing Concurrent Program (Service Contracts Main Billing), Invoice Interface Lines get generated to RA_INTERFACE_LINES_ALL Table.

    We need to submit this program manually.

    SELECT * FROM OKS_BILL_CONT_LINES WHERE ROWNUM<6;
    SELECT * FROM OKS_BILL_TXN_LINES WHERE ROWNUM<6;

    Check in these two tables whether you can see billing information or not. Take BTN_ID from 1st query and put in second query to see the related records.
     
  3. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi ,

    Is your problem solved ?
     
  4. jamesmount

    jamesmount Guest

    I think Bharat say true. i am agree with this advice. Thanks