This content has been marked as final. Show 6 replies
so you have a manual record you want to enter from a flat file?
if so, you can just edit the MAPPLET to include the FLAT FILE as a source...and just UNION the PSoft and the values from the flat file. That is probably the easiest way. You can also have a separate mapping/task if you want that loads the same W_EXCH_RATE_GS staging table.
if helpful pls mark correct
If you do not have a data source then the BI Apps will not be able to load the data from anywhere...
As suggested, you could use a flatfile which you populate with the manual exchange rates, or enter them directly into PeopleSoft. An alternative would be to populate the exchange rates into a database table and source them from there, perhaps building an APEX front end for this. Either way, you will need to physically populate a data source with the exchange rates.
If the exchange rates can be inferred/generated (e.g. missing rates within a date range should be extrapolated from existing data points) then you can calculate these during the ETL.
Please mark if helpful / answered,
Thanks for the Reply Andy. So you mean to say I will have to edit the mapping in such a way that I add a flatfile source in the mapping and join in such a way that the exchange rate is taken from the source file to convert the local amounts coming from the instances and populate in the global column in w_gl_balance_f table?
Please see my response to a very similar thread you have posted:-
Re: Informatica Logic for Balance_Global1_Amt column in W_GL_BALANCE_F table.
Please can you mark and comments as helpful / correct within this thread,