Oracle Database 23c Free Version Now Available to Developers

Oracle Database 23c Free Version Now Available to Developers

 

Developers have first access to new application development features coming to Oracle Database 23c, including the groundbreaking JSON Relational Duality

Oracle today announced a free version of Oracle Database 23c. The new Oracle Database 23c Free—Developer Release meets growing demand from developers and organizations worldwide to access the newest features in Oracle Database 23c “App Simple”. Developers now have access to innovative Oracle Database features that simplify development of modern data-driven applications, getting them ready for the planned release of Oracle Database 23c, the next Long-Term Support Release.

“Oracle is delighted to provide developers early access to the world’s most advanced database technologies for developing and running modern applications,” said Juan Loaiza, executive vice president, mission-critical database technologies, Oracle. “With Oracle Database 23c Free­–Developer Release, developers will be able to level up their skills and start building new apps using breakthrough features such as the JSON Relational Duality which unifies the Relational and Document data models providing the best of both worlds, SQL support for Graph queries directly on OLTP data, and Stored Procedures in the world’s most popular programming language - JavaScript.”

Putting developers first, Oracle Database 23c Free—Developer Release

Oracle Database 23c Free—Developer Release is available for download as a Docker Image, VirtualBox VM, or Linux RPM installation file, without requiring a user account or login. A Windows version is planned to follow shortly.

“Developers are the most important constituency in tech decision making today. Therefore, getting tools into their hands with a minimum of friction is more important than ever,” said James Governor, co-founder of RedMonk. “Oracle Database 23c Free­–Developer Release is designed to remove obstacles to developer access, allowing devs to define the ecosystem without requiring permission. This is a radical departure for Oracle.”

Oracle Database 23c Free–Developer Release includes:

·       JSON Relational Duality: Developers can build applications in either relational or JSON paradigms with a single source of truth and benefit from the strengths of both—relational and document models. Data is held once, but can be accessed, written, and modified with either approach. Developers benefit from the best of both JSON and relational models, including ACID compliant transactions and concurrency controls, which means they no longer have to make tradeoffs between complex object-relational mappings or data inconsistency issues.

·       JavaScript Stored Procedures (powered by GraalVM): JavaScript code can now be executed closer to data than ever before by writing JavaScript Stored Procedures or loading existing JavaScript libraries into Oracle Database. Support for JavaScript code improves developer productivity by allowing reuse of existing business logic straight inside the data tier and reuse of JavaScript developer skills. JavaScript code invocation can be intermixed with SQL and PL/SQL, providing polyglot programming language support.

·       JSON Schema: Developers can now ensure and validate JSON document structures via industry-standard JSON Schemas, enabling the confident and reliable use of the JSON data format.

·       Operational Property Graphs: Developers can now build both transactional and analytical property graph applications with Oracle Database, using its industry-leading, new SQL standard property graph queries support, including running graph analytics on top of both relational and JSON data.

·       Oracle Kafka APIs: Kafka applications can now run against Oracle Database Transactional Event Queues with minimal code changes. This enables much more robust microservices built using transactional events that perform event operations and database changes in a single atomic transaction.

·       SQL Domains: The new domain construct can act as lightweight type modifiers that centrally document intended data usage, extending and drastically improving SQL standard domains. This allows developers to better understand how data is used and improves overall data quality, without the complexity and incompatibility of usage-specific data types or user-defined types.

·       Annotations: Database metadata can now be stored directly alongside the data with the new annotation mechanism inside the Oracle Database. Developers can annotate common data model attributes for tables, columns, views, indexes, and more—providing a central, lightweight, declarative facility to register and exchange usage properties across applications. Storing the metadata along with the data guarantees consistency and universal accessibility to any user or application that uses the data.

“With Oracle Database 23c Free—Developer Release, developers get early access to new app dev features highlighted by JSON Relational Duality,” said Carl Olofson, research vice president, Data Management Software, IDC. “This release finally gives developers an opportunity to try out a feature that unifies and synchronizes the documents and relational worlds. It enables developers and data engineers to access formats for each use case without worrying about data structure, data mapping, data consistency or performance tuning. They can now also run graph analytics on top of both relational and JSON data. Oracle’s JSON Relational Duality, a truly revolutionary solution, is perhaps one of the most important innovations in information science in 20 years.” 

 

P.S: If you like this content share it with your colleagues and friends.

 

Infidocs Technologies || EBS 12.2 Premier Support Extended Through At Least 2034

 

EBS 12.2 Premier Support Extended Through At Least 2034

 

Oracle has announced the extension of Premier Support for Oracle E-Business Suite 12.2 through at least 2034.

The long-term support release for Oracle E-Business Suite, with Premier Support for Oracle E-Business Suite 12.2 available through at least 2030.

Infidocs, provides services support, upgrade and implementation in Oracle EBS r12. We have an excellent pool of in-house and ready to deploy resources. We have supported to almost 20+ clients all around the globe.

You can transform your business with excellent and skilled Oracle resources available on contract on Immediate basis.

We also Focussed and Specialized in:

·       Oracle eBusiness Suite

·       Oracle Fusion, Oracle Cloud Application

·       Oracle Database                    

·       Oracle SOA Suite, OBIEE        

·       Oracle Integration Cloud       

 

Please feel free to connect with us on info@infidocs.com or call us on +91 777 5000 034.

Infidocs Technologies || Withholding Tax Payables ||

Account Payables - Withholding Tax

 

Withholding tax is the amount withheld by the party making a payment to another (payee) and paid to the taxation authorities. The amount the payer deducts may vary, depending on the nature of the product or service being paid for. The payee is assessed on the gross amount, and the tax to be withheld (the withholding tax) is computed in that assessment. 

The purpose of withholding tax is to facilitate or accelerate collection, by collecting tax from payers rather than a much greater number of payees, and by collecting tax from payers within the jurisdiction rather than payees who may be outside the jurisdiction.

 

Withholding Tax Payables Options

 

Use Withholding Tax. Select this option to enable Automatic Withholding Tax. If you enable this option, you have the option to allow your suppliers and supplier sites to be subject to withholding tax.

Allow Manual Withholding. Enable this option to allow manual creation and adjustments of Withholding Tax type distributions for your invoices.

Tax Group. The name of the withholding tax group that you would like to use as the default withholding tax group for the new suppliers you enter.

Apply Withholding Tax. Select the time at which you would like Payables to apply withholding taxes to your supplier's invoices:

Never.

At Invoice Validation Time.

Note: If Payables withholds tax at Invoice Validation, it calculates withholding only once. If you adjust an invoice after you submit Invoice Validation, then you need to manually adjust the withholding tax

At Payment Time. When you create payments in a payment batch or with a Quick payment.

Withholding Amount Basis.

Include Discount Amount. Payables include the invoice discount amount when it calculates withholding tax amounts for the invoice.

Include Tax Amount. Payables include the invoice tax amount when it calculates withholding tax amounts for the invoice.

Create Withholding Invoice. Select the time at which you would like Payables to automatically create withholding tax invoices to remit withheld taxes to tax authorities:

Never. You can create a withholding type tax code without entering a tax authority. However, if you change to an option other than Never, you will need to manually ensure that each withholding type tax code has an associated tax authority.

At Invoice Validation Time.

At Payment Time

Include Income Tax Type on Withholding Distributions. If you enable this option then you can report on federal income tax withheld (MISC4) for 1099 suppliers.

When this option is enabled, then when Payables automatically creates distributions of type Withholding Tax for 1099 reportable suppliers, Payables automatically provides the following values:

Income Tax Type value of MISC4.

Income Tax Region value, if the Combined Filing Payables option is enabled.

Note: Payables provides these values only for distributions it creates automatically. If you create a Withholding Tax distribution manually, then you need to enter these values manually.

When you enable this option, Payables initiates the Update 1099 Withholding Tax Distributions program, which updates these values on existing Withholding Tax distributions. The program selects distributions to update as follows:

If the current date is before March 1 of the current calendar year then the program updates distributions with a payment date of January 1 of the previous calendar year or later.

If the current date is March 1 of the current calendar year or later, then the program updates distributions that have a payment date of January 1 of the current year or later

N: - Setup-> Options-> Payables Options

Enable Use Withholding Tax and Allow Manual Withholding

Enter Tax Group Name as Ivas_WT

Select Radio Button at Invoice Validation Time for

• Apply Withholding Tax
• and Create Withholding Invoice

 

Save and Close

 

N: - Invoices-> Entry-> Invoices

Withholding Tax Invoice

Enter the supplier and at least one pay site in the Suppliers window.

v  To enter a basic invoice:

      1.       In the Invoices window choose Standard or Mixed for the invoice Type.

2.       Enter the Supplier or Supplier Number.

3.       Enter the Supplier Site to which you will send payment of the invoice. Payables will print the address for this site on the payment.

4.       Enter the Invoice Date or accept the Payables default (today's date) by choosing [TAB].

 Payables may use the invoice date you enter as the Terms Date and GL Date default for an     invoice, depending on how your Payables Options and Defaults are set up.

 If your GL Date Basis Payable Option is set to Invoice (Date), you must enter an invoice   date that is in an open or future period.

5.       Enter the Invoice Number from the invoice your supplier sent you or accept the Payables default (today's date) by choosing [TAB]. Payables will not allow you to enter duplicate invoice numbers for the same supplier.

 

Suggestion: 

You may want to use an invoice numbering convention that minimizes the risk of separate entries of the same invoice under different invoice numbers. For example, if you consistently enter alphanumeric invoice numbers in upper case you would enter an invoice number only as ABC123, and not also as abc123.

Enter the full Invoice Amount including tax, freight and miscellaneous charges.

 

6.       Enter the Description of your invoice. This will appear on your payment document and may appear in your general ledger.

7.       Enter distributions automatically by entering a Distribution Set, or choose the Distributions button and enter the distributions manually.

8.       Payables automatically schedules payment of the invoice using the Invoice Amount, Payment Terms, and Terms Date. Enter or review the defaults for these fields.

9. Save your work.

Oracle Human Capital Management Cloud || What's New?

 

HCM Cloud applications have two types of patches you can receive that are documented in this What’s New:

• Release Updates (21A, 21B, 21C, and 21D)
• Optional Monthly Maintenance Packs to each update

It is important for you to know what Release Update your environment is on. You can find this in your Cloud Portal.

This document outlines the information you need to know about new or improved functionality in Oracle HCM Cloud. Each section includes a brief description of the feature, the steps you need to take to enable or begin using the feature, any tips or considerations that you should keep in mind, and the resources available to help you.

In addition to this document you will also want to review the Oracle Human Capital Management Cloud Functional Known Issues and Maintenance Packs . These documents identify bug fixes and possible known issues. You will also need to review these documents based in the release update version you are currently on or will be moving to.

Oracle HCM Cloud release documents are delivered in five functional groupings:

Suggested Reading for all HCM Products:

• HCM Cloud Common Features (This document pertains to all HCM applications. It is the base human resource information for all products and HCM Tools.)
• Global Human Resources Cloud (Global Human Resources contains the base application in which other application use for common data such as workforce structures and person information. Regardless of what products you have implemented you may want to see the new features for Global Human Resources that could impact your products.)

Optional Reading for HCM Products (Depending on what products are in your cloud service):

• Talent Management Cloud (All Talent applications)
• Workforce Rewards Cloud (Compensation, Benefits, Payroll and Global Payroll Interface)
• Workforce Management Cloud (Absence Management and Time and Labor)

Additional Optional Reading:

• Common Technologies and User Experience (This documents the common features across all Cloud applications and is not specific to HCM)

Infidox Technologies || Revenue Recognition

    

Revenue Recognition

 

 

In oracle receivable Run the Revenue Recognition program to generate the revenue distribution records for your invoices and credit memos that use Invoicing and Accounting Rules. You assign accounting rules to recognize revenue over several accounting periods. The Revenue Recognition program will create distribution records for the invoices and credit memos that you create in Receivables. Then run the create accounting program, it will post the revenue-related journal entries to GL.

 

Accounting rule types

Accounting rules helps to Create Revenue Recognition Schedules for your invoices. Accounting rules determine the number of periods and percentage of total revenue to be recorded in each Accounting period. You can use accounting rules with transactions that you import into Receivables using Auto Invoice and with invoices that you create manually in the Transaction windows. You can define an unlimited number of accounting rules.

 

¡  Fixed Schedule

¡  Variable

¡  Daily Revenue Rate, All Periods

¡  Daily Revenue Rate, Partial Periods  

 

Invoicing Rules

Invoicing rules determine the accounting period in which the receivable amount is recorded. You can either manually assign invoicing rule to transactions you create or import these rules into receivables using the Auto Invoice utility.

Types:

¡  Bill in Arrear

¡  Bill in Advance

 

 

 

 

 

Infidox Technologies ||Year End Closing Activities Checklist

 

||Year End Closing Activities Checklist||

The following procedures are typical of most year-end activities:

To complete the year end process:

1.    Run revaluation (if you manage financial information in multiple currencies).

2.    Stop processing accounting transactions for the old year.

3.    Produce preliminary year end reports.

Produce the usual period-end reports and any other special year end reports.

4.    Begin to process the new year.

As you do at other times of the year, you can use the Open Period Update page or Open Periods Mass Update page to open the first accounting period in the new year for entry and posting.

5.    Record adjustments to the old year.

When you are ready to post adjusting entries to the old year:

·         Enter them as adjusting journals.

·         Alternatively, reopen the appropriate accounting period, enter and post the entries, and close the period again.

6.    Close the old year.

To close revenue and expense accounts to retained earnings and roll forward beginning balances to the New Year, use the Close Request page to initiate the background request. General Ledger performs closing according to the options selected in the closing rules.

7.    Produce reports for the New Year.

Until you run year end closing, reports for the next year do not include any results from prior years. Once you run the close process, balance sheet accounts and inception-to-date revenue and expense accounts are available for reporting.

8.    Make additional adjustments to the old year.

When you must make additional adjustments for the old year, follow the same process that you use to record adjustments to the old year.

9.    Reclose the old year.

Whenever you make adjustments to a closed year, you must run year end closing again to ensure that the opening balances for the New Year reflect all activity for prior years.

Infidox Technologies || General Ledger Journal Approval Process

 General Ledger Journal Approval Process

Pre-Requisites:
    Enable Journal Approval’ checkbox should be checked in Ledger setup

    Require Journal Approval’ checkbox should be checked at journal source level    

Profile Options:

• Set profile option “GL: Use Apprvoval Management (AME) for journal approval”  to No or Blank

• Set the profile option “Journals: Find Approver Method” to any of the below values:-

                 Go up the Management Chain

                 Go Direct

                 One Stop then Go Direct

If you’re using Journal Approval via AME then

•          Set profile option “GL: Use Approval Management (AME) for journal approval”  to “YES”

•          Set Appropriate AME Rules depending upon Business requirement.

Hierarchy of Managers:

Name: NeymarJr

Assignment : Lionel Messi

Name: Lionel Messi

Assignment: Cristiano Ronaldo

Name: Cristiano Ronaldo

Assignment: Pele

Name: Pele

Assignment: None

Ensure that the UserID has person assigned:

§ Pele is assigned to Pele

§ CrisRonaldo is assigned to Ronaldo, Cristiano

§ LIOMESSI is assigned to Messi, Lionel

§ Neymar is assigned to Junior, Neymar (As shown below)

Set Journal Authorization Limits

Note: Currency using in approval limits should always be used in functional currency

There are three types of Profile Option “Journals: Find Approver Method” for Journal Approvals:

Go up the Management Chain

Go Direct

One Stop then Go Direct

Set the profile option “Journals: Find Approver Method” to “Go up the Management

Chain”

           

             

Profile Option “Go up the Management Chain” means if NeymarJr raises a journal of 10,000 then it will go near Lionel Messi for approval and then NeymarJr can post the journal. If NeymarJr raises journal of 20,000 then 1st it goes near Lionel Messi for approval, if Lionel Messi approves then it goes near Cristiano Ronaldo for approval. Once Cristiano Ronaldo approves the journal then only NeymarJr can post them.

Set the profile option “Journals: Find Approver Method” to “Go Direct”

      

Profile Option “Go Direct” means it will directly go to the approval as per the approval limit. If NeymarJr raises a journal of 22,000 then it will directly go near Cristiano Ronaldo for approval, it will not go near Lionel Messi.

Once Cristiano Ronaldo approves the journal then only NeymarJr can post them.  

Set the profile option “Journals: Find Approver Method” to “One Stop then Go Direct”

       

Profile Option “One Stop then Go Direct” means it will stop near 1st approver then direct to the final approver. If NeymarJr is submitting a journal of 30,000, it will 1st go  near Lionel Messi(One Stop) then directly near Pele(then Go Direct), it will not go near CrisRonaldo for approval.

Once Pele approves the journal then only NeymarJr can post them.

Content Writer: Araf Shaikh