Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Can Not Copy And Rename An Seeded HCM Extract such as "Payments"
Summary:
Hi All,
When we are trying to copy the existing HCM Extract getting below error on the same instance.
JBO-26041: Failed to post data to database during "Insert": SQL Statement "INSERT INTO PAY_REPORT_CATEGORIES(REPORT_CATEGORY_ID,REPORT_GROUP_ID,SHORT_NAME,LEGISLATION_CODE,LEGISLATIVE_DATA_GROUP_ID,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,CREATED_BY,CREATION_DATE,OBJECT_VERSION_NUMBER,ENTERPRISE_ID,BASE_CATEGORY_NAME) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13)".: ORA-01400: cannot insert NULL into (???)https://docs.oracle.com/error-help/db/ora-01400/
I am trying to customize the seeded report Cheque Report and modify the template output. This is the first time I have ever attempted this so I hope I have the process correct. I have customized the report and copied the data model to the custom folder and linked the custom report to the custom DM. My next step was to create the custom Extract for the Custom Report.