what is the exact version of Hyperion are you on?(including patch level)
have you ever successfully loaded on this environment?(e.g using a simple flat file)
Have you open an Oracle SR?
Yes this environment is good, there are other OIA interfaces that work fine.
You might be encountering an issue with source period mapping.
You say you have other open interface adapter integrations that work. Are you using source period mapping for the working open interface adapter integrations?
On the Setup tab, go to Integration Setup > Period Mapping. From there select the Source Mapping tab and from the Source System drop down, select the source system affiliated with one of your working OIA integrations. Are you using explicit mapping? If so, try setting up explicit period mapping with your new integration. You will also need to update your data load rule to use explicit period mapping, too.
If you have access to ODI Studio, you can get the SQL query that exports data from OIA table to TDATASEG_T.
Then you can execute that query in your SQL tool to find the root cause.
As ThinkFDM suggests, it could be related to source period maps. Other reasons might be your batch_name in the data load rule does not match you batch_name in AIF_OPEN_INTERFACE.
DId you check that?
That was it. There was a typo in the Batch Name in the data load rule.
Thank you very much!!