Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Unable to modify JobOfferLetterDM as it is giving the error ORA-01719.
in HCM Extract
Summary:
I would like to add the candidate's preferred language column in the OfferRecipient data set Cand.CAND_PREF_LANGUAGE_CODE but when saving the data model, it throws the error: ORA-01719: Outer join operator (+) not allowed in operand of OR or IN.
After removing condition ⇒ AND ((not (&pflag) and Cand.cand_address_id=personAddress.address_id (+)) or (&pflag)), the error disappears, but I need to retain the logic.
Any guidance would be greatly appreciated.
Content (please ensure you mask any confidential information):
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
Tagged:
1