This content has been marked as final. Show 4 replies
#1. I guess, you are referring to the problems that you are encountering while loading GL COA. You may log SR against GL to know more details on how API loads data to instance. DELETE is a specific requirement in your case and I would suggest you to work with GL team and they may provide some solution or workaround to overcome this performance issue.
#2. No, concurrent program does good amount of pre-processing that you would not get if you directly call the java classes.
#3. Not sure, what you are exactly looking at. Are you looking for user guide to write your own iSetup API classes?
11i.AZ.H has got good amount of performances fixes overall and it is recommended release on top of 220.127.116.11CU. I would suggest you to upgrade to 11i.AZ.H.
Specific to GL COA issue, I don't think 11i.AZ.H would really help you much. It is very much functional issue with respect to API and you have to work with GL team to get workaround/solution. This may involve customizing the API according to your requirement.
I will raise a SR with Oracle in regards to the limitation with iSetup for loading into Oracle GL.
Is there a guide to help develop iSetup API? Is this the future direction from R12 onwards, or is the iSetup API framework available in AZ.H patch set itself?
Please let us know.
We have user guide available on metalink on how to create reportable APIs. In R12, registering the API is available through UI whereas in 11i requires bit of customization.
How do you delete records from fnd_flex_value_norm_hierarchy table? Which Oracle standard API did you use? Please share your thoughts.