Oracle ERP User Network Collaborate with Professionals working on Oracle ERP(Oracle Apps) including EBusiness Suite (R12, 11i), Fusion, Peoplesoft, JDE, Siebel, Hyperion, OBIEE, SOA etc.

Hi

I am trying to send email with bursting process and in

email body i want to create a hyperlink which is dynamic url

and even my email body is Dynamic (Basically created diffenrent fnd_messages in the system )for different language

Which is should be formated in HTMl

But when i tried entire body is comming in one single line

Can you please help on this

Thanks and regrads

Rajender Reddy Amireddy

Hi Rajender,

Have you tried adding carriage returns "CHR(13) or CHR(10)" between lines where you wanted to break the line.

Here is an example i've 

'A direct deposit has been sent to your bank. It will post next business day. '||CHR(10)||

Thanks

Malik

Hi Malik,

Thanks for the reply

Yes i have tried using CHR(10) but its still the same

And  Main intention to send a hyperlink in the email body

and format the body as well in HTML

Please let me know your thoughts.

Thanks and regards

Rajender Reddy Amireddy

I have a BI Publisher related qestion,

when I pass a value in the paramter to the report, I can only display it if I put it outside the group, but when I put the field that suppose to display this parameter value inside the the group, it's displayed empty

any advice ?

"Unable to determine conversion rate to replicate journal" error while trying to post a Bank transfer journal from Cash management. Where is this conversion rate to be specified to correct this.

Raman

Hi Rajender,

What client are you using and how the email is sent (exchange server) 

Also you want to check this link 

https://forums.oracle.com/forums/thread.jspa?threadID=1068989

Hi Ahmed,

I didn't fully understand your requirement.

Can you provide more detail. 

1) Are you using oracle report to generate XML output.

2) Are you taking about showing parameter in report group. Or template layout

3) How you are referencing the parameter in the group.

4) Have you tried using a formula column and return parameter value in a place folder as the worst case.

Malik

Hi Raman

Please check the following metalink docs.

Posting Journal Error: Unable to Determine Missing Conversion Rate to Replicate Journal [ID 744677.1]
Error 21 Unable to Determine Missing Conversion Rate to Replicate Journal Upon Posting [ID 1289628.1]

Also this discussion is limited to subject so please  try other sources for such issues.

Malik

Hi Malik,

I'm working on the hash total for a EFT e-text file. What I need is - the sum of the 15 leftmost digits of the vendors bank account number, (substituting a '1' for any non-numeric characters), then truncating the sum to the 10 rightmost digits. So far I have SUM (TRUNCATE (C_BANK_ACCOUNT_NUMBER, 15)). That seems to be working fine, but when I try to add the substitute and right elements, it errors out. Any suggestions on the rest of the syntax?

Thanks!

Hi Malik,

Where do you define the rate for secondary ledger?

Can u explain in detail.....

Rgds

Parasuraman

I have another issue with regarding to printing 1099 forms from AP.

The standard form comes is accomodating two preprinted  forms in one A4 sheet. But the alignment is going wrong when two forms are printed in one page. Client wants two forms to be printed in one page. Can you help?

Raman

Hi Raman,

Either its an oracle issue then follow-up with oracle. You need to create and SR. 

And if its a print driver issue then check with DBA's/Admin

Thanks

Malik

Hi Malik,

I am scheduling a PPR from R12.1.3. The build is getting completed successfully, but when it comes to foramtting, the process is erroring out.

The error I got is

"oracle.apps.iby.exception.PSException: An error has occured while updating instruction and payment statuses and marking them as complete".

I logged an SR with Oracle, after reviewing for any solution pointers on Metalink. And as usual,  it's taking own course of running sqls ,  log reviews, and running additional .sqls to get the logs , when the prior logs did not provide the information to understand the error.

Any help is appreciated.

Thanks,

Sunil

Hi Sunil,

Are you seeing this issue only when schedule the PPR. What about when explicitly running the PPR does everything work then.

Also can you please post the completed logfile. I wanted to see what exactly is the error.

Thanks

Malik

Hi Diane,

I've had not a chance to work on your issue... but its seems like that you've to work this out in the func/proc. Because i'm wondering how are you identifying a non-number value. 

Oracle provides IBY_FD_EXTRACT_EXT_PUB extension package with different procedures to extend the XML file on different level. Please check on that hope that should fix your issue. Search google for more detail on this package if you;ve not worked this before.

Hi Malik,

Thank you for looking into it.

We are not scheduling the PPR's . The PPR is manually submitted.

I have uploaded the log file. File Name : dbug_log_file.log

Please let me know for any additional inputs.

Thanks,

Sunil

Hi Sunil,

From your log the errors to be IBY_PAYINSTR_PUB.flagSeparateRemitAdvcPayments: Non-fatal: Exception occured when attempting to get remit advice setup for profile id: 181 which mapped to system profile code: vPayment.

Please check the Section# 2 in metalink note >> 1306534.1. Looks like you need a patch# 11839898 to fix the issue. 

I would suggest to also test PPR without printing remittance advice and see if that works.

Thanks

Malik

How can I create Customer with GL Accounting Head in AR? So we can able to create transaction of customers with their own Accounting Head.

Hi Malik,

We have a requirement for Wire Recording Payment Template in R12.0.4 so that we can record these Payments in Batches. As the Payment Batches generate a reference number we could use it for audit purposes. 

Need to setup a new template, payment process profile etc. Any document with setups would be helpful.

Thanks in advance.

Hi Krish,

Is your requirement only to make invoice as paid in oracle or you'll be actually sending that wire document to the bank to process payment. 

If its only for recording purpose then use ""German Wire Format" so you don't really need to setup create a new template but duplicate the template and name as per your custom requirement. 

Here is the document on setting up ACH and its same for Wire.

Setting up ACH.docx