Hi,
Can someone help me on what I need to query on JDBCBuildMap rule to bring in additional attributes from a table other than FND_USER table for an Oracle EBS connector.
Sorry, I couldn’t understand your question, are you trying to use the JDBBuildMap rule in Oracle E-Business connector!?
Can you please give more details like the integration type and code snippet?
@suresh4iam I’m using Oracle EBS Connector to fetch Oracle EBS accounts, But there are user data on other EBS tables as well other than FND_USER table.
What I see in connector document is:
- In Custom Schema Attributes, enter the names of the attributes that are not standard and not a part of the out-of-the-box schema. Add
<entry key="jdbcbuildMapRule" value="Your BuildMap Rule Name"/>to the source with the build-map rule that initiates a query of the required table and fetches the custom columns.
Can you tell us more about the tables and fields you are trying to pull in? Will you be just pulling data in or trying to write back to these tables?
I’m just trying to aggregate user data from below tables:
FND_PROFILE_OPTION_VALUES
PER_ALL_ASSIGNMENTS_F
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.