In Data Management, Load method was not set properly for Oracle Planning
and Budgeting Cloud Service(PBCS) application especially for
multi-period loads.
Kindly refer the steps below,
The above steps are applicable for the loads with less number of rows.
If the file size is huge(i.e have millions of rows), then above steps would not help to fix the issue.
There is an Enhancement request already raised with the development but fix is not yet available:
Enh 26834089 - PBCS: UNABLE TO IMPORT LARGE DATA FILES DUE TO DB RESOURCE CONSTRAINTS
Kindly refer the steps below,
- Click on Navigate and go to Data management
- In Target Application, select the application and click on Application options
- Define the Load Method as "All data types with security" and save the changes.
- Goto Data Load Rule -> Target Options -> Ensure Load Method is also set to "All data types with security" and save the changes
- Re-run the export task for multiple periods and it should work fine.
The above steps are applicable for the loads with less number of rows.
If the file size is huge(i.e have millions of rows), then above steps would not help to fix the issue.
There is an Enhancement request already raised with the development but fix is not yet available:
Enh 26834089 - PBCS: UNABLE TO IMPORT LARGE DATA FILES DUE TO DB RESOURCE CONSTRAINTS
No comments:
Post a Comment