Best Of

Re: BI_PRNXPN01 - add email to template

You need to make sure the field exists in the Extract tables used by the process. Email is not part of that as far as I am aware (at least not in our 9.2 version). So we created a Bill Inquiry phone ID named EMAIL and have a rule in the template to print the proper Email ID based on the BU in case this Bill Inquiry phone ID is in the extract. We didn't want to customize the entire program to get this included, so this was a simple solution…

Ronald Bouwmans

2

Re: Can we define auto accounting rules in AR to be prorated based on days instead of number of months

Hi

"Daily Revenue Rate, All Periods" and "Daily Revenue Rate, Partial Periods" Type is available, you can use the same.

The Daily Revenue enables accurate revenue distribution over all accounting periods, including full and partial periods. A partial period is an accounting period where the start date is not the first day of the period and/or the end date is not the last day of the period.

For example, you have a contract that is valid from January 14 to April 13. The total revenue is $900.

Using the new Daily Revenue enhancement, Receivables calculates the daily revenue rate as follows:

Service duration = 90 days
(18 days in January + 28 days in February + 31 days in March + 13 days in April = 90 days)
Receivables calculates the daily revenue rate by dividing the total revenue by the number of days for the contract duration.
(Daily revenue rate = $900/90days = $10/day)
Receivables bases the revenue amount per accounting period using the daily revenue rate, and the selected accounting rule.
This table illustrates the difference between selecting an accounting rule with a type of either Daily Revenue Rate, All Periods or Daily Revenue Rate, Partial Periods.

GL Date Period Days in Period Daily Revenue Rate, All Periods Daily Revenue Rate, Partial Periods
January 14 January 18 180 180
February 14 February 28 280 295
March 14 March 31 310 295
April 13 April 13 130 130

Read Note 1116934.1, How To Setup And Troubleshoot Invoicing Rules and Accounting Rules

Best Regards,
Bharat

Bharat -Oracle

1

Re: Weblogic Zip file is corrupt

Are you using jar to extract them?
jar -xvf filename.zip

Have you validated the checksum against the patching server?

Nick [Application Server] -Oracle

1

Re: Sched Server submitting jobs

Hi

Are you talking about the standard JDE Scheduler accessed through JDE Solutions Explorer, or the AIS Scheduler used for scheduling Orchestrations? The JDE Scheduler will launch any missed jobs, while the AIS Scheduler will ignore any missed jobs and only submit any that become due while it is active.

Thanks
Jonathan

MasonJo

1

Re: Performance management appraisal issue

Hi Qrail @Qrail

Please open a Service Request and attach screenshots with detailed steps performed by the user till the error is raised.
Also, upload Appraisal Analyzer for the affected appraisal_id.

Regards,
Mihaita_Oracle

Mihaita Totu-Oracle

1

Re: What procedure should I follow for upgrading Oracle Grid Infrastructure in a RAC environment

I'd rather prefer the in-place patching option.

There are 2 ways of doing that:

1.) opatchauto (as root) . This is the easiest method

2.)

rootcrs.sh -prepatch (as root, unlocks the software)
opatch (install all required GI patches, as grid owner)
rootcrs.sh -postpatch (as root, locks the software and start the GI software stack again)

Helmut -Oracle

1

Re: How to validate the standard "Application Accounting Definitions"

The reason for the error was that I directly copied the request record that ran in the Chinese environment in the English environment, so the request’s language environment was still in Chinese. After manually resubmitting the request in the English environment, the error was resolved

User_6XL6G

1