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!

When Records Struck in OE_EXPOSURE_INTERFACE with import_status_code='ERROR' ?

Discussion in 'Oracle Apps Technical' started by reddyharnath, Jan 4, 2013.

  1. reddyharnath

    reddyharnath Active Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    75
    Hello All,

    Needed one urgent help!!!

    After Validation some records struck in the OE_EXPOSURE_INTERFACE with import_status_code='ERROR', if its really validation failed it should move to the Error table oe_exp_interface_errors but its not moved. What might be the reason for those records struck records in OE_EXPOSURE_INTERFACE.

    Thanks
    Harinath Redd
     
  2. Bharat

    Bharat Community Moderator Forum Guru

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

    Can you please tell us what you exactly done ?
     
  3. reddyharnath

    reddyharnath Active Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    75
    Hello Bharat,

    Through custom program we are populating data into OE_EXPOSURE_INTERFACE, then are calling the Package "OE_EXT_CREDIT_EXPOSURE_PVT.Import_Credit_Exposure" through report, this procedure will validate the data in the interface table and valid data will move to oe_credit_summaries. If any error records found it should move to oe_exp_interface_errors. But records validated in interface table and import_status_code=ERROR and struck in interface itself, what might be reason for those failure. Not able to find the error as well.

    Cheeers,
    Harinath
     
  4. Bharat

    Bharat Community Moderator Forum Guru

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

    Have you checked in Log files. Please shared the log information if you find any there. And check also in output file.