on 05-18-2012 9:45 PM
Hi guys,
I am trying to use *DESTINATION_APP in the script logic to push the data from one application to another. Here is the situation:
*DESTINATION_APP=PTREVENUE
*SKIP_DIM = LINEITEM, PRJCAT, PHASE, PRJSTATUS, PARTNERCC, PRJMGR, PRJSPONSOR
*WHEN VERSION
*IS BUDGET, FORECAST
*REC(EXPRESSION=%VALUE%, DATASRC=XFER_CAPEX, CHARGECAT=NOCCAT, CONTRACT=NOCONTRACT, PTCUSTOMER=FC_NOCUSTOMER, PTPRODUCT=FP_NOPRODUCT, PTTANK = FT_NOTANK, TIER=NOTIER, UOM=NOT_SPECIFIED)
*ENDWHEN
*COMMIT
When I try to validate the Script logic file it gives me an error pop up saying:
"Invalid dimension mapping definition in *DESTINATION_APP: PTREVENUE".
When I checked in UJKT and try to validate the code line, transaction I am getting the same message, "UJK_VALIDATION_EXCEPTION:Invalid dimension mapping definition in *DESTINATION_APP: PTREVENUE"
I checked my security settings, I have access to all the secured dimensions of the Destination Application. I tried to test by entering a different application in the *DESTINATION_APP=OPEX. I am still getting the same error message. The Destination Application has dimensions that are not present in Source Application. I tried using *ADD_DIM, e.g. *ADD_DIM CHARGECAT=NOCCAT. Still the same.
I am not able to pin point what exactly is the issue here. Please help.
Thanks,
Abhishek.
Hi Abhishek,
I think there is some problem with the mapping of dimensions in source and target application. Ensure that for dimension names which are not similar in both the application, you are using *RENAME_DIM keyword to rename the dimensions with different names. Similarly, ensure that additional/missing dimensions in target appliication are being taken care of using *ADD_DIM and *SKIP_DIM instructions.
Hope it helps!!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
14 | |
4 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.