Skip to Content
avatar image
Former Member

Data load brings in records but stuck in yellow

Hi All,

We are using the datasource 0PM_OM_OPA_1 to fetch the plan and actuals cost into BW.

Data Flow : 0PM_OM_OPA_1 >> 0PM_DS04 >> 0PM_C01

We are having an infopackage routine to restrict the data getting pulled only for two years as this datasource does not support Delta update.

We had come across a scenario where we lose some records due to overwriting capability in DSO. To handle that we had made those fields as key fields in the DSO.

One of the field we wanted was in extract structure but not in the datasource. Found that the field was hidden by SAP hence using an ABAP program we had made it visible in ROOSFIELD table.


1. While doing this activity, do we need to modify or tweak the code behind ?

2. I believe we dont need to go for an exit as the field is readily available after changing it to visible the datasource. Please confirm.

Issue we are facing:

1. Infopackage load brings data but stuck in yellow.

- Checked the job in source system and found that it gets cancelled.

- ST22 gives a message as "DBSQL_INVALID_CURSOR" as shown in the screenshot below.

2. Infopackage load with a selection on order number does not bring any records even when the records exist in RSA3. These loads bring 0 records with status green.

Kindly let me know your thoughts.

Referred Links:

Vinoth V

error.jpg (115.4 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Feb 10, 2017 at 08:46 AM

    Vinoth V,

    There are quite a few OSS Notes for 0PM_OM_OPA_1.

    You might want to see if any of them are suitable.


    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 11, 2017 at 01:07 PM

    Hello Vinoth,

    What is the status of the background job? Does it get completed or it gets cancelled in source system?

    If the background job is complete then check for Tcode SLG1 in source system for Object RSAP and Sub Object RSAP_INFO

    You may also try to change the wait time and treatment of warnings in info package (Open IP > Scheduler )


    Abhishek Shanbhogue

    Add comment
    10|10000 characters needed characters exceeded